Controlling ComboBox from VBA-script

[Guest]

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

 

[NickHK]

Sören,

ListBox1.AddItem "Item 1"

NickHK

 

[Guest]

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