Matt,

I will be using the information you gave me tomorrow at work.

Thanks.
--
Ed


"Matt Richardson" wrote:

On Feb 13, 3:55 am, Ed wrote:
Hi Capt,

Thanks for the Info. I know nothing about comboboxes so I will have to read
up on them.
--
Ed

"capt" wrote:
Try using a combobox
--
capt

"Ed" wrote:

How do I add a drop down list to a Text Box?
--
Ed

If you are talking about adding a dropdown list to an individual cell,
you can do this by going to DataValidation.

In the screen, under validation criteria and 'Allow:' choose list.
From here you can then specify where the list of data resides in your
workbook that you want to appear in the dropdown list.

Otherwise (If you are creaing a userform) as capt said I would look
into comboboxes. They would take a little more explaining on here,
but there are some really good resources on the net about their use
with VBA.

Regards,
Matt Richardson
http://teachr.blogspot.com