initialize comboboxes value list during sheet activation

[mfran2002]

hello,
i have some ComboBoxes within a sheet and i need to inizialize their values during sheet activation

i've already written the statements but i don't know where i have to put them....

may someone help me?

[Shijesh Kumar]

Which type of combo box u hav..

Forms Control or Control Tool Box

[mfran2002]

i have added a forms combobox onto a worksheet....

[Shijesh Kumar]

its a sample code
modify as per your need

Please Login or Register  to view this content.

Assumed that u want to fill the combo box with data in Column A

[mfran2002]

sorry Shijesh Kumar but i do not understand your code
i am not so skilled...
i fill my combo statically

the statements i wrote to fill my ComboBox are the following:

Sheet1.ComboBox1.Clear
Sheet1.ComboBox1.AddItem "A"
Sheet1.ComboBox1.AddItem "B"
Sheet1.ComboBox1.AddItem "C"

but i don't know where i have to put them....to fill my combo when i open my file...

[Shijesh Kumar]

If it is static you can simply assing value...


Right Click on combo box
Select Format Control
In the input Type A1:A5
In the Linked Cell type B1

now whatever is there from A1 to A5 will automatically be displayed in the combobox.. no need to write the macros for this...

U can choose any range ... and hide that...

[mfran2002]

ok, i tried your suggestion but i still have a problem:

into Format Control i have these tabs:

Dimension
Protection
Property
Web

where may i find "input" and "linked cell"?

furthermore:
if i mandatorily need to fill my combo with the statements i wrote, where have i to put them?