Combo boxes - default option or message

Resolved · Low Priority · Version 2007

Tue 31 Mar 2009, 16:46 Delegate Tim said...

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!

Thu 9 Apr 2009, 11:01 Trainer Carlos said...

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

Thu 16 Apr 2009: Automatically marked as resolved.

Training courses