VBA Excel SPreadsheet ComboBox issue

[dprayner]

Good morning people. I have many ComboBoxes on myspreadsheet tab. They all populate (correctly) when the spreadsheet is opened, except for 1. The one ComboBox doesn't display an initial value on the ComboBox control, but the list is populated. The list however had five blank spaces before the first entry. I used the same code with each. As follows:

With Sheet1.ComboxBox1
.Text = "A1"
.AddItem "A1", 0
.AddItem "A2", 1
.AddItem "A3", 2
etc.
End With

I was wondering if this might be an issue of something in the properties? Any suggestions? DAVE

 

[SkipVought]

Hi,

"The list however had five blank spaces before the first entry..."

Does this mean that if the first entry is Skip,

that the first entry string is " Skip"

or

that you have 5 blank rows before Skip?

"I have many ComboBoxes on myspreadsheet ..."

Can you explain what this means? I almost never place more than ONE combobox on a sheet but I make the List and Click behavior, context sensitive. Keeps things simple.

Skip,

_{[red]Be Advised![/red] A man who jumps from a bridge in Paris, is…
INSANE!}