View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Sören_Marodören[_2_] Sören_Marodören[_2_] is offline
external usenet poster
 
Posts: 4
Default 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