Good Day Folks!
I am attempting to create a form which uses a validation list for cell A2. I have created the list I want to use in range H2:H5. That part is easy. The hard part is that several folks that have limited Excel skills may need to add new names as new people are needed on the list. What I did was create a UserForm asking for the First and Last names. There is a button under cell A2 which launches the UserForm. The user will populate the first and last name and click a button to send it to the list in column H. The problem now becomes, how do I expand the validation list to include the new cell within the macro?
I have worked on several solutions but none have worked. Any ideas on how to write this one? Any help would be appreciated. An example of what I am trying to do can be found on Add or remove a value in a drop down list | Get Digital Help - Microsoft Excel resource . The difference is that I am trying to use a UserForm instead of another cell. Thanks
I am attempting to create a form which uses a validation list for cell A2. I have created the list I want to use in range H2:H5. That part is easy. The hard part is that several folks that have limited Excel skills may need to add new names as new people are needed on the list. What I did was create a UserForm asking for the First and Last names. There is a button under cell A2 which launches the UserForm. The user will populate the first and last name and click a button to send it to the list in column H. The problem now becomes, how do I expand the validation list to include the new cell within the macro?
I have worked on several solutions but none have worked. Any ideas on how to write this one? Any help would be appreciated. An example of what I am trying to do can be found on Add or remove a value in a drop down list | Get Digital Help - Microsoft Excel resource . The difference is that I am trying to use a UserForm instead of another cell. Thanks
