Referring to form controls in formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I reference a form control in a formula? Example:
I have a list or drop-down box on an Excel form with
values A, B, C, etc. How would I reference the control in
=IF(value in form control=B, T, F)?

Thank you for your time and cooperation.
 
You can't. There is no link to the userform object, and you would not get an
update if you used VBA.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top