How to code a 'Search Button'

[mssianlf]

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

 

[VBACO]

Maybe I am just lazy, but I would just save the trouble and

Application.SendKeys("^f")

 

[mssianlf]

what does that do? Please forgive my ignorance of code!

 

[VBACO]

It is the same as pressing ctrl+f

 

[VBACO]

For example if you put

Private Sub CommandButton1_Click()
Worksheets("Sheet1").Range("A1").Activate
Application.SendKeys "^f"
End Sub

When you click the button, it will pull up excels find & replace box

 

[mssianlf]

Ha Ha Ha

As much as I would love to get away with that I don't think I can although I wish I could.

 

[Richard Schollar]

Hi

Can you provide an example of what the users would type into the search box and what subsequent data would be returned to the userform?

 

[mssianlf]

Hi,
They would be entering something like:

'NECO Ltd' or 'Joe Bloggs'

The data being returned is all held in the worksheet with ranges from 2 dates on a calender (start and end) Value in numbers names, email address, co name. contents of a couple of click boxes and a couple of dropdown boxes.
I tried to include a screen print so you could see the form but I cant make it work

 

[Richard Schollar]

So there are multiple fields in each row that could contain the sought for data? Are there likely to be multiple rows that might contain the sought for data too? If so, which rows (records) would you want to return and how would you want this presented?

Do you just want to return the row numbers (or record IDs) of the rows that contain the sought for term?

 

[mssianlf]

I hadn't actually thought of that? Would it be possible to highlight the rows or bring each set of data up one after the other in the form?
I am totally happy with just showing the relevant lines of data in the worksheet to the user.