LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 30
Default Message box this is what your looking for

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
replace VBA run-time error message with custom message BEEJAY Excel Programming 13 July 14th 06 03:59 PM
Replace Excel Message w/Custom Message Kevin R Excel Programming 1 May 18th 06 04:13 PM
Intercept/replace standard 'cell protected' message with my own message? KR Excel Programming 3 March 16th 06 02:31 PM
Opening an attachment of a message that has a message as attachmen vetron Excel Programming 0 January 30th 06 06:17 PM
Displaying a message in a message box without requiring user to click anything to proceed Android[_2_] Excel Programming 2 June 25th 04 06:44 PM


All times are GMT +1. The time now is 07:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"