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

Take a look at the DataValidation 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
-----Original Message-----
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
.