1
I have a list of items in a dropdown in excel. These values must be selected by the user and from there, edit it as requested. However, I don’t know how to edit these dropdown values. Can anyone help me? Below is an example of two items that must be selected and then changed by the user.
1
Go to the data menu (1), data validation subset (2), as you already have a list in the validation criterion the option allow should be as list (3), edit the source or the contents of the cells indicated in it (4).
In source, is located my dropdown list range
How will I edit the font ?
Can you show the contents of your source field? I think it’s easier to explain
I edited the question with my font added
Browser other questions tagged excel dropdown excel-vba dropdownlist excel-userform
You are not signed in. Login or sign up in order to post.
If what you want is to check if it is number or date, you can use the functions
IsNumeric()andIsDate(). If they are specific numbers and dates, the use of validation as it is being done is correct. And to edit the values, just write the value in the cell. If this is not the question, it could be clearer?– danieltakeshi
What I need Daniel, is to have information there in the default dropdown and from there, the user select and edit. For example, there is the Date(DD/MM/YYYY) option. The User will select this option and enter the values within () correctly. Another example is the NUM(XXXXXXXX) option. The user will select this option and enter the numbers instead of the "X’s"
– Alexsander Caproni
Refers to this answer and see if you have any idea how to use the functions to check if it is number, date and size of the inserted string. But as it is being done, each field must be programmed separately. You can create a form (userform) and validate each Textbox separately. Regex or Wildcards can also be used... There are numerous ways to do this, do some research and see which one is better, but you have many entries which makes it more complex...
– danieltakeshi