Textbox and dropdown list
Solved
kdegue
-
kdegue -
kdegue -
Hello,
In my tool, I want to open a UserForm that contains a TextBox.
The idea is that within it, I can directly set a value coming from a drop-down list (items from the list on an Excel sheet) or enter a completely new value.
In other words, I’m looking for a way to insert a drop-down list into a TextBox, while still being able to type any text.
Am I clear enough? Thanks in advance
Configuration: Windows 7 / Firefox 22.0
In my tool, I want to open a UserForm that contains a TextBox.
The idea is that within it, I can directly set a value coming from a drop-down list (items from the list on an Excel sheet) or enter a completely new value.
In other words, I’m looking for a way to insert a drop-down list into a TextBox, while still being able to type any text.
Am I clear enough? Thanks in advance
Configuration: Windows 7 / Firefox 22.0
2 answers
-
Hello,
Am I clear enough? Thanks in advance
No... :-)
Your dropdown list, is it a validation list or a combobox?
See you
--
If you hit a pot and it sounds hollow, it doesn't necessarily mean the pot is empty. ;-)(Confucius)
Note: I do not respond to DMs for technical questions. And my crystal ball is broken.-
Hello, So, I don’t see what a combobox is, but I’ll try to clarify my points. In my userform, I would like to have a textbox. On the right, I’d like there to be an arrow (pointing downward) which, when clicked, shows a list of elements. (This list will be present on a sheet of the Excel workbook.) Visually, for now, it resembles a dropdown list. Then, if I click on an element, I’d like that element to be placed in the textbox. However, if the elements don’t interest me, I’d still like to have the possibility to enter something else. Is that better? Thank you.
-
-
Hi,
If I understood correctly!
See you
--
If you bang your head on a pot and it sounds hollow, it's not necessarily the pot that is empty. ;-)(Confucius)
Note: I don't respond to DMs for technical questions. And my crystal ball is broken.
