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

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

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