Archive of Mr Excel Message Board

Back to Controls in Excel archive index
Back to archive home

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

Re: Comboboxes and addressing

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.