Text box
 

How do I put several drop down lists in a single text box on a worksheet?
--
Ed

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

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

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.

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.