MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Comboboxes and addressing


Posted by J Thompson on July 06, 2001 2:51 AM

Hi,

I've got 5 comboboxes on a userform but can't work out the syntax to make combobox1 display data form worksheet 1 and combobox2 display data form worksheet 2 etc...

ANy help would be appreciated.

Thanks


Posted by Ivan F Moala on July 06, 2001 3:22 AM

If you want to link data from your worksheets
to the combobox then use the comboboxs rowsource.
Syntax for the rowsource is; Sheet4!a1:a10
assumnig you wanted to link to Sheet4.

Or to do this by code lookup online help for
AddItem Method


HTH

Ivan