Hi,
I was looking for some help in coding a search button.
I need a single text box in which people can type a name and press go. I then need the data displayed in a user-form. already have the user form as it is the same format as the one I have created for data entry and the data returned needs to be editable. The data is held in one workbook and I only need two columns to be searchable.
I know there is a lookup option but tbh the people I have been charged with creating this for have trouble with ctrl+f
.
I am sure this is a complicated and time consuming ask and will be grateful for any help anyone can offer as it took me nearly a whole week to make my user form work
Thank you in advance.
Sian
I was looking for some help in coding a search button.
I need a single text box in which people can type a name and press go. I then need the data displayed in a user-form. already have the user form as it is the same format as the one I have created for data entry and the data returned needs to be editable. The data is held in one workbook and I only need two columns to be searchable.
I know there is a lookup option but tbh the people I have been charged with creating this for have trouble with ctrl+f
![Wink ;) ;)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f609.png)
I am sure this is a complicated and time consuming ask and will be grateful for any help anyone can offer as it took me nearly a whole week to make my user form work
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
Thank you in advance.
Sian