I NEED URGENT HELP WITH COMBO BOXES!
i have a userform for a carpet company. i already have a combo box with a
list of the carpets available, but what i want to do now is once one is
selected i want the price of the carpet to be shown without clicking
anything, in a text box or list box!!! whichever is easier! PLEASE HELP!!!

gem

Gem

You need some quite detailed coding to pick this up into another textbox or
dropdown, also you give no idea where the data is held, on a hidden sheet,
etc. You will need to use the combobox_change event or similar for sure.

It may be a little beyond the scope of this forum without more detail or
smaller questions as you attempt to build the application

BTW capitals is considered shouting in newsgroups and therefore rude, that
may stop some people helping...just a heads up

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"gem" wrote in message
...
I NEED URGENT HELP WITH COMBO BOXES!
i have a userform for a carpet company. i already have a combo box with a
list of the carpets available, but what i want to do now is once one is
selected i want the price of the carpet to be shown without clicking
anything, in a text box or list box!!! whichever is easier! PLEASE HELP!!!

gem