Add items in combobox in a sheet

[siobeh]

Hello,

I have a workbook with Sheet1,Sheet2 and Sheet3.

And i have a combobox in Sheet3.

How can i add items in combobox in Sheet3?

[taps]

Hi siobeh


Use below code in sheet3 code editor..

Please Login or Register  to view this content.

Regards
taps

[siobeh]

on what event on sheet3 should i put this? or should i put this in a module?

[taps]

Hi

You can call the AddData through a command button which you can put in sheet3.

regards
taps

[siobeh]

Hello taps,

i just want when the workbook has been opened, the combobox will be populated.

[taps]

Hi,

Try following steps..
1. In Developer tab there is Controls ribbon.
2. Click Insert option and select combo box from Form Control section.
3. Place the combo box in sheet3.
4. Right click on it and select Format control..
5. Here you will get Control tab.
6. Click on the arrow sign on Input range box.
7. Select the data range you want to populate and click OK.
8. It will be always shown in combo box whenever you open the workbook.

Hope it will solve your problem.

Regards
taps