Tim has attended:
Excel VBA Intro Intermediate course
Combo boxes - default option or message
When I'm using a Combo Box on a form (i.e. a drop down menu), is there a way of setting one of the options as the default?
I want the user to suggest from three options (say, Option 1, Option 2, and Option 3), and when the form first initializes I would like the option selected to automaticelly be Option 1 (which the user can then change if they wish). Thank you!
RE: Combo boxes - default option or message
Hi Tim
Sorry for the delay.
To make a value in the ComboBox default to the first name you write the following line of code :
cboMyOptions.ListIndex =0
This places the first name on the list in the ComboBox window
Hope this helps:
Carlos