Results 1 to 8 of 8
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,423
    Thanks
    126
    Thanked 5 Times in 5 Posts

    Macro to display message

    I have account numbers 635X & 734X in Col A and values pertaining to these account numbers are in Col C

    I would like a message box to advise me where the value is 0 on all sheets pertaining to these account numbers

    I have set up two separate macros to do this, but cannot get it to work properly

    It would be appreciated if someone could assist me.

    I have posted a similar post on MrExcel.com yesterday

    http://www.mrexcel.com/forum/excel-q...lue-col-c.html
    Attached Files Attached Files

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi Howard

    I have modified your code slightly - I'm sure you will see the changes I made.
    see attached.

    I added a Worksheet Activate routine for sheet [Br1]
    When you switch to sheet [Br1], the sheet activate routine is triggered, which then executes your two routines.

    You could add this sheet activate routine to your other sheets as required.

    Let me know if this helps.
    I am in Barbados, flying back to UK today, landing tomorrow, so may not be able to reply.

    zeddy
    Attached Files Attached Files

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,423
    Thanks
    126
    Thanked 5 Times in 5 Posts
    Hi Zeddy

    Thanks for the reply. Hope you had a good trip to Barbados

    The file you attached is the wrong one. Kindly attach correct file

    Thanks

    Howard

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi Howard

    ..oops! I just attached what the newest file (but from the wrong folder!)
    I did it again.
    ..here it is.

    leaving shortly!

    zeddy
    Attached Files Attached Files

  5. #5
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,423
    Thanks
    126
    Thanked 5 Times in 5 Posts
    Hi Zeddy

    Thanks for the help, much appreciated. Hope you have a good flight

    It would be appreciated if you could amend the macro, so the message box displays the row number as well as the sheet name

    Howard

  6. #6
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi Howard

    ..the flight was OK, but next day I was admitted to hospital again. Internal gunk removed. Still here. Nothing major. More ops to come.
    Apologies for delay.

    I have attached an updated file to show sheet names etc etc.
    Macro is triggered, as before, when you switch to sheet [Br1]

    zeddy
    (in-hospital-beddy)
    Attached Files Attached Files

  7. #7
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi Howard

    ..now back at home.
    Did you check previous posting out?

    zeddy

  8. #8
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,423
    Thanks
    126
    Thanked 5 Times in 5 Posts
    Hi Zeddy

    Thanks for the reply. Hope you have made a full recovery. I overlooked your reply. It works perfectly

    Howard

Posting Permissions

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