Text box

  • Thread starter Thread starter Ed
  • Start date Start date
How do I put several drop down lists in a single text box on a worksheet?  
Click to expand...



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
 
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.
 
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-excel-userforms-creating-coding.htm

If you have any other concern or need anything else, please feel free to
let me know.

Regards,
Jialiang Ge ([email protected], 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.
 
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 ([email protected], 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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open Specific Worksheet Using Button Form Control in Excel 0
Selecting values in sheet list box using vba 3
Would like to locate a text box based on a search string and copy 1
Changing the test of checkboxes (shapes) programmatically? 3
Excel Move or Copy Stopped Working? 0
Macro to retrieve values corresponding to the value selected in Dropdown box 4
Active XText box vbcr shows symbol instead of an actual carraige return 2
User Form Problem 1

Back
Top