MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Set default value for combo box on form

  Asked By: Bakir    Date: Dec 18    Category: MS Office    Views: 1564

I have created a user form with a combo box, which pulls its values
from a named range in the workbook.

It is possible to set a default value for the combo box?

Since the combo box on my form asks the user to select a month - I
would ideally like it to default to the current month.



1 Answer Found

Answer #1    Answered By: Elaine Stevens     Answered On: Dec 18

You can set  the Value property of the combobox. This is the value in the
bound column of the combobox. Unless the user  selects or enters another value
this would remain as the value of the control.

Didn't find what you were looking for? Find more on Set default value for combo box on form Or get search suggestion and latest updates.