• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1330
  • 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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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