Archive of Mr Excel Message Board


Back to Controls in Excel archive index
Back to archive home

Comboboxes and referencing

Posted by M Walker on July 09, 2001 1:18 AM
Hi,

I'm having a little trouble with the following combobox. The references are to the sixth sheet of my workbook but i don't know how to use absolute referencing to make sure that the references are correct. I'm pritty sure that it involves "sheet6!" but thats as far as i can get.

Any help would be appreciated.

Cheers,

M Walker

ComboBox1.ColumnCount = 5
ComboBox1.RowSource = "a5:a47"
ComboBox2.ColumnCount = 5
ComboBox2.RowSource = "a48:a157"
ComboBox3.ColumnCount = 5
ComboBox3.RowSource = "a185:a304"
ComboBox4.ColumnCount = 5
ComboBox4.RowSource = "a305:a316"
ComboBox5.ColumnCount = 5
ComboBox5.RowSource = "a158:a184"


Re: Comboboxes and referencing

Posted by Ivan F Moala on July 09, 2001 1:54 AM
You are correct in your sytax ie.
"Sheet6!a5:a47" Note: That sheet6 is the Tab name
and NOT the sheets Code name.

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.