Combo box names.?
Combo box names.?
(OP)
Im trying to use an if statment where the "IF" part refers to the choice taken in a combo box. Iv got it working oerfectly using cell, but I just cant get it to use the combo box instead of the cell.
Basicall all i need to know is what is combo box 1 called, Iv tried combo box 1, combobox1, combobox.1 and a few others, but non seem to work for me.
Please help
Thanx
Will
Basicall all i need to know is what is combo box 1 called, Iv tried combo box 1, combobox1, combobox.1 and a few others, but non seem to work for me.
Please help
Thanx
Will





RE: Combo box names.?
You can directly reference a control from a VBA subroutine by using its codename or shapes collection name.
RE: Combo box names.?
cummings54's reply seems reasonable if the if is in the spreadsheet.
If in the VB code the value of combobox1 is "combobox1.value"