andrewmckat
New Member
- Joined
- Jun 14, 2020
- Messages
- 4
- Office Version
- 2019
- Platform
- Windows
- Mobile
Hi all,
Fairly new to VBA.
I have a userform that allows you to enter Clients Information into text boxes and add this data to a table in excel. You can then search by Customer Reference no. to show results in textbox they were entered to update etc. I also have a list box that shows all available clients.
When I Search for a client Reference no. I would also like it to select the correct row in the list box.
note that it is also set up so that you can click on the client in the listbox and the information will be shown it text box just like if you were to search.
I have attached screenshots of the userform and also codes used for search and Listbox
Regards
Andy
Fairly new to VBA.
I have a userform that allows you to enter Clients Information into text boxes and add this data to a table in excel. You can then search by Customer Reference no. to show results in textbox they were entered to update etc. I also have a list box that shows all available clients.
When I Search for a client Reference no. I would also like it to select the correct row in the list box.
note that it is also set up so that you can click on the client in the listbox and the information will be shown it text box just like if you were to search.
I have attached screenshots of the userform and also codes used for search and Listbox
Regards
Andy