Comboboxes and referencing
Posted by M Walker on July 09, 2001 1:18 AM
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.
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"