Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have two worksheets. Sheet Referencethis and sheet Enterinfo
Range B7:B116 and D7:D115 on sheet Referencethis has contents I am looking for already entered into them. Each row belongs together so the data in B7 belong with the data in D7. The data in B50 belongs with the data in D50. The data in B100 belongs with the data in D100, and so on. D7:D116 and F7:F116 on sheet Enterinfo is set up the same way as sheet Referencethis, however it does not have any data in any of the rows. So when data is entered into D7 and F7 the data will belong together. When data is entered into D50 and F50 the data will belong together. When the data is entered into D100 and F100 the data will belong together,etc. After data is entered into any row in the range D7:D116 and F7:F116I on sheet Enterinfo and it matches any row in the range B7:B116 and D7:D115 on sheet Referencethis Id like a message box to appear with the data from the row of Referencethis that matches the row of Enterinfo . I aiming to have the message box say something like (Put data from Referencethis here ) this is what your looking for. Can you help, I put below what I have so far, I know its not much. Sub Findthis() MsgBox "This is what your looking for" End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
replace VBA run-time error message with custom message | Excel Programming | |||
Replace Excel Message w/Custom Message | Excel Programming | |||
Intercept/replace standard 'cell protected' message with my own message? | Excel Programming | |||
Opening an attachment of a message that has a message as attachmen | Excel Programming | |||
Displaying a message in a message box without requiring user to click anything to proceed | Excel Programming |