• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1308
  • Last Modified:

VBA ComboBox default value?

I have a ComboBox3 on userform1, that I would like to default to "Select from List" when the userform is shown.  I have other comboboxes that I would like shown blank.  Currently they are all blank and I am not sure how I did that.

How do I show the "Select from List" default value, and not have it as part of the list to select from.

Please advise and thanks. -R-
0
RWayneH
Asked:
RWayneH
  • 3
  • 2
  • 2
1 Solution
 
MontoyaProcess Improvement MgrCommented:
The text property in the Combobox would give you what you want. You can do it programatically, or you can just change the Text Property by clicking on your combobox and then going to Properties section and look for Text.
0
 
RWayneHAuthor Commented:
What is the programatic code version of this command so I can reset it to blank and reset focus to the combobox?  -R-
0
 
MontoyaProcess Improvement MgrCommented:
Combo1.Text="Select from List"
Combo1.SetFocus

0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
patrickabCommented:
For a blank:

Combo1.Text=""
Combo1.SetFocus
0
 
RWayneHAuthor Commented:
Thanks this is it and I got it to work.  -R-
0
 
RWayneHAuthor Commented:
Thanks for the help!  EXCELent!
0
 
patrickabCommented:
RWayne - Thanks for the grade - Patrick
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now