[VBA] combo box

[szczasiek]

Hi Guys
I have a problem with VBA combo box
I wanna to create combo box with list (Yes,No), when I tick the No – some rane become locked and formulas don’t use the data to callculations. If I tick Yes the data is available for formulas.
How to do it ???

 

[SkipVought]

Huh? My crystal ball is a bit cloudy this AM. You just might need to add some clarity to your somewhat cryptic post.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[MarkWalsh]

If the options are just 'Yes' and 'No', why not use a checkbox instead of a combo box?

 

[Markus4]

Or OptionButtons, because checkboxes tend to be overlooked.

M.