I would like to have a search box so that when the name searched for is found the appropriate data is placed in cells C2, C4, C6, F2, F4, F6. I cant figure out how to do this.
I would like to have a search box so that when the name searched for is found the appropriate data is placed in cells C2, C4, C6, F2, F4, F6. I cant figure out how to do this.
Something like this should work.
Please Login or Register to view this content.
Teach me Excel VBA
Thank you for your help. This macro works perfectly... but only if I enter the text in the sort box and go into Macros and run the macros. How can this macros load upon opening the file and run without having to manually trigger the macros?
The macro in post #2 will overwrite the formulas in the destination cells. Your selection change code need to be modified to check if the search box has been changed, search in column A and return the appropriate rec number (i.e. row -8) to cell F3 which is used by the index/match formulas.
Please Login or Register to view this content.
Last edited by protonLeah; 08-18-2018 at 05:57 PM.
Ben Van Johnson
You can call it from Worksheet_Change event like this
Please Login or Register to view this content.
You can call it from Worksheet_Change event like this
Please Login or Register to view this content.
Thank you for your response. I know very little about VBA and what I presented is what others figured out for me. I wouldn't know how to correct the problem you presented. However, your initial solution does work.
Please see the attached I have attached copy of your workbook that has the working code. Type a name in A3 and hit enter.
Thank you for your help. I keep getting a ScrollBar1 error when I go from sheet 1 to sheet 2 and then back to sheet 1. Also is it possible to enter data directly into F2 that will update &F&9 data.
Sorry, the line:
' Me.scrollbar1.Max = 4
was an experiment I forgot to delete. Change to:
Please Login or Register to view this content.
Last edited by protonLeah; 08-19-2018 at 06:36 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks