| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Box
How do I add a drop down list to a Text Box?
-- Ed |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text Box
Try using a combobox
-- capt "Ed" wrote: How do I add a drop down list to a Text Box? -- Ed |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| grab cell text from multi-tab workbook, show text in another workb | Excel Worksheet Functions | |||
| Text does not display in "Text boxs" and when wrapping text in a c | Excel Discussion (Misc queries) | |||
| Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
| Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) | |||
Linear Mode
