Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

[VBA] combo box

Status
Not open for further replies.

szczasiek

Technical User
Apr 18, 2011
1
PL
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 ???
 


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

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
If the options are just 'Yes' and 'No', why not use a checkbox instead of a combo box?
 
Or OptionButtons, because checkboxes tend to be overlooked.

M.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top