+ Reply to Thread
Results 1 to 3 of 3

Include Cell Value In Message Box

  1. #1
    Registered User
    Join Date
    03-28-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    37

    Include Cell Value In Message Box

    I have the below macro designed to display a message box if a cell in the range specified is greater than the value in the designated cell (BF7). In the message, I'd like to include the value for the cell in another column, from the same row as the cell that met the condition. For example:
    Cell E11.........Cell BF11........Cell BF7
    Mark....................1.......................0

    What I want the message box to say: Mark worked too many days.

    I understand how to include a cell value like so:
    Please Login or Register  to view this content.
    But I need the value of cell E11 to be dynamic and match the row that the value in BF11 exceeded the value in BF7.

    Please Login or Register  to view this content.

    Thanks for any help,

    CVinje
    Last edited by CVinje; 10-08-2009 at 09:57 PM. Reason: Solved

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Include Cell Value In Message Box

    Does this work?

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-28-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    37

    Thumbs up Re: Include Cell Value In Message Box

    Thank you so much for the reply; the proposed solution works great. I really appreciate it!!

    CVinje

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1