This is a little complicated so, forgive me if this isnt 100% clear. Here is a diagram to help.
___H_____I_______J_________________
3 5 A
5 2 B
5 5 B
4 1 C
2 5 B
In colum 'J' I have coding ('A', 'B' and 'C'), now say I wanted to...
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...
How do you reference to a combo box, its hard to put into words I will explain what Im doing.
Im making a spreadsheet for a company, they need all there expenses for each day listed and they have several (around 20) catergories ranging from motoring to rent, ext. I need to spreadsheet to look...