| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text box
How do I put several drop down lists in a single text box on a worksheet?
-- Ed |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Text box
On 16 Feb, 18:08, Ed wrote:
How do I put several drop down lists in a single text box on a worksheet? * -- Ed why do you need to do this? usually you would put a Frame around other controls but it seems strange putting listboxes in a Textbox? jasonq |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Text box
Maybe you are thinking of a UserForm as a container for the listboxes.
UserForms are created in the VB Editor using Insert form the menu bar. See VBA help topic Creating a UserForm. "Ed" wrote: How do I put several drop down lists in a single text box on a worksheet? -- Ed |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Text box
Hello Ed,
According to the description, you are look for a TextBox control to which a dropdownlist is attached. Users can either input texts directly into the textbox, or select a value from the dropdownlist. Am I right? In UserForm, I think the control "ComboBox" will fit your request. Please open you VBE in Excel (Alt+F11), right click the VBA project-Insert-UserForm, then drag a ComboBox from the Toolbox to the form. Here is a more detailed list of how to use userforms in VBA for Excel: http://www.excel-vba.com/vba-23-exce...ing-coding.htm If you have any other concern or need anything else, please feel free to let me know. Regards, Jialiang Ge , remove 'online.') Microsoft Online Community Support ================================================= When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ================================================= This posting is provided "AS IS" with no warranties, and confers no rights. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Text box
Hi Ed,
Would you mind letting me know the result of the suggestions? If you need further assistance, feel free to let me know. I will be more than happy to be of assistance. Have a great day! Regards, Jialiang Ge , remove 'online.') Microsoft Online Community Support ================================================= When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ================================================= This posting is provided "AS IS" with no warranties, and confers no rights. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using TEXT and &TEXT - display numbers with commas, underline text | Excel Discussion (Misc queries) | |||
| Text does not display in "Text boxs" and when wrapping text in a c | Excel Discussion (Misc queries) | |||
| select text in cell based on text from another cell, paste the text at the begining of a thrid cell, etc... | Excel Programming | |||
| Excel VBA: Worksheet cell .Text property: 1024 bytes text len limit | Excel Programming | |||
| extracting text from within a cell - 'text to rows@ equivalent of 'text to columns' | Excel Programming | |||
Hybrid Mode
