PDA

View Full Version : Self filling combo boxes



JGobert
09-07-2007, 12:45 PM
I am building a user form with several combo boxes that refer to several cells on a single row. There are two unique objects in each row; a location and a store id (both of which are text and both of which are in the user form). I am trying to have all of the combo boxes (which refer to other cells on the same line) self fill as I one of the unique objects....but I don't even know where to start. I have attached a sample and would appriciate any help.
Thanks
Jason

mdmackillop
09-07-2007, 01:19 PM
I'm not clear why you need more than one combo box to work as you describe. To fill textboxes, use something like this
Private Sub cbxStoreID_Change()
Dim c As Range
Set c = Columns(1).Find(cbxStoreID)
TextBox1 = c.Offset(, 1)
TextBox2 = c.Offset(, 2)
'etc.
End Sub