Controlling ComboBox from VBA-script
Hi NickHK,
This does not work for me.
But I tryed something similar:
ComboBox1.List = Array("Alfa", "Beta", "Gamma", "Delta")
and also added a default value with the following line:
ComboBox1.Value = "Gamma"
So now it works for me.
Br,
/Sören
"NickHK" wrote:
Sören,
ListBox1.AddItem "Item 1"
NickHK
"Sören_Marodören" wrote in message
...
Hi,
How can I control the data in a ComboBox without using cells in a
worksheet?
Now I have the ListFillRange pointing to cells in my worksheet.
I don't want that. I want to set the value for this from my VBA-script.
Is that possible?
I already use "ComboBox1.Value" to read out its value.
Best regards,
/Sören
|