MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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"


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