COMBOBOX

[Fernando Duran]

I have this problem, I never used combo boxes, but I think is the best
solution... i have this woorkbook, that at this moment, works with
only one table of calculations for a transport, but now i need to add
Post tables, etc... differents transports, differents freights. That's
why i though a combobox will do the job, by putting there, all
transport companies and from there, choose the right table, let say
UPS for example, go to that worksheet and pick-up the freight.
I need some help in the combobox side, the rest, no problem..

Thanks

Fernando

 

[Brad]

Take a look at the Data>Validation menu selection. You
want to allow only a list of values. You can create the
list of values in a range somewhere in your workbook. It
essentially makes a cell become a combobox. From my
interpretation of your problem, this would be a better
solution.

-Brad