Greetings,
I am using an UserForm to enter information. ListBox1 has a RowSource "EmployeeName". When a name is selected within ListBox1, the name is placed in TextBox1. Textbox2 will contain a Door Number.
I am wanting to place an "X" on the worksheet "DoorTest" when a name and door number are found.
Ex: If Anderson, Bob and 104 are are chosen on the UserForm, then an "X" would be placed in Cell E2.
Last edited by brentjohn; 06-30-2025 at 12:59 PM.
Here's one way.
You may wish to error handle instances where a door number is not found.
Please Login or Register to view this content.
Let us know if you'd like help with that.
BSB
Badly,
Thank you so much - works perfectly!!
Regarding an "error handle" if the door number is not found. I would like to create a 2nd ListBox and use a Named Range in the RowSource. However, the Named Range ("DoorNumbers") which contains DoorTest!$B$1:$O$1 - it does not show in ListBox2.
Badly,
I just came across the following code and it works.
Please Login or Register to view this content.
Problem solved then
Although here's a one liner alternative.
BSBPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks