PDA

View Full Version : Putting temporary data in a Combobox



vodkasoda
01-16-2013, 12:37 PM
I am sure I have done this before, but I seem to have brainfreeze !!!

I am populating my ComboBox from a TXT file.

I want my ComboBox, when it displays, to say "Please Choose From The Following Options" & then when the user clicks on the DropDown arrow, the data from the TXT file displays.

This data is used in different places, so I can't add the "Please Choose ..." line at the top of that file & display it as the first option ...

However, when I use the lines

UserForm1.ComboBox1.Value = "Please Choose ..."

or

UserForm1.ComboBox1.Text = "Please Choose ..."

I am just getting an empty box ... I am sure I am going to be embarrassed when somebody tells me what I am doing wrong, but hey, I'll accept my ridicule :help !!!!!

vodkasoda
01-17-2013, 03:47 AM
OK, I have done it in the design, by putting the text into the Value field, I am unable to enter into the Text field for some reason, but it works, so I am happy !!!

Case Closed, as they say ...