• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 375
  • Last Modified:

The best way to develop a drop-down-list controlled by a macro in a User Form for data-entry

My question is if there is a user form controlled by a macro, that when the data-entry user select a cell a macro is activated with a drop-down-list where the user can select an option and if in the options provided there is not a best one, then the user can add their own. There are several way to do this but I will like if somebody have a macro example, please provide it to me I will modify as required. I have several macros that do this process differently, one read the data to be selected from several cells from a worksheet and I have other that everything is in the macro. Please, let me know which way is the best

Thank you very much

Dennis Cantellops
US FDA
0
dcantel1
Asked:
dcantel1
  • 2
1 Solution
 
byundtCommented:
Dennis,
The trick is to use a ComboBox control on your userform. You can use the RowSource property of that ComboBox to fill the dropdown with your default choices.

Brad
UserformComboBoxQ28139372.xlsm
0
 
byundtCommented:
Another way to do the dropdown does not require macros or a userform. Instead, you use a Data Validation dropdown. You can link its source to a named range. You can also turn off the warning message if the user types in a different value than one of the choices (uncheck the "Show error alert after invalid data is entered" on the Error Alert tab of the Data Validation dialog).
UserformComboBoxQ28139372.xlsm
0
 
dcantel1Author Commented:
Very nice example.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now