|
Text Box
How do I add a drop down list to a Text Box?
-- Ed |
Text Box
Try using a combobox
-- capt "Ed" wrote: How do I add a drop down list to a Text Box? -- Ed |
Text Box
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 |
Text Box
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 |
Text Box
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 |
| All times are GMT +1. The time now is 03:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com