Code for searching a worksheet and displaying results in a form for editing

[RossN]

Hi All

I am trying out some codes to create some interactive forms for my work.

Can someone help me with a code to perform the following

I have a Userform called SEARCH. I would like the user to enter a date into a textbox (TextBox1) on this form and hit enter. I then would like the code to search down column A in a worksheet called Sheet1 for that date (there ought to be only one entry with that date). I would then like a second userform called EXPERIMENTAL to be populated with data from the row that contains the searched for date. In this case the data I want displayed as follows - Result from Column A on sheet1 (ie the date) to be displayed in TextBox called DAT2 - Column B on sheet 1 in text box called EXP and Column D on sheet1 in a text box called EXP2.

I would be grateful for any help.
Cheers
Ross

[gjlindn]

If you could upload a sample workbook with your existing forms, that would be very helpful. Thanks!

[RossN]

Hi, Thanks for the reply. I have attempted to attach the file in its simplest version. If you can show me how to make this one work, I will be able to extrapolate that to the more complex version I am creating.

Micro Ab QC forms TEST.xls

Cheers
Ross

[Leith Ross]

Hello Ross,

Welcome to the Forum!

Here is the code for the "Find" button on the "Search" form.

Please Login or Register  to view this content.

[RossN]

Sorry for slow reply - I've been away for a few days.

Many Thanks for your reply! The code works great when I apply it to my more complex working forms.

I will continue working on them for the next week or two. I suspect there may be one more area of code that I may need assistance with but will post that later

Again Many Thanks

Ross