+ Reply to Thread
Results 1 to 6 of 6

MsgBox popup when user enters a value in a cell

  1. 04-26-2012, 12:40 PM #1
    okelly is offline
    Registered User
    Join Date
    07-24-2006
    Location
    Dublin, Ireland
    Posts
    44

    MsgBox popup when user enters a value in a cell

    Hello all

    I'm trying to generate MsgBox popups when a value >0 is entered by the user into Sheet1!A1 , A2, etc..
    Snippet is below. The MsgBox works perfectly when a value is entered in A1. However the MsgBox does not popup if a value is entered in A2.
    I've used two separate macros as I need to replicate the msgBox(s) across a number of cells in my sheet.
    I'm open to either separate macros for each alert or some smart way to work it into a single loop..
    (the values will be entered manually by the users, not by formula or link etc..)
    Thanks in advance for any insights

    Conor


    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 04-26-2012, 12:43 PM #2
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: MsgBox popup when user enters a value in a cell

    Hello okelly,

    Rather than use a VBA event procdure, did you think about using Data Validation?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
  3. 04-26-2012, 12:48 PM #3
    okelly is offline
    Registered User
    Join Date
    07-24-2006
    Location
    Dublin, Ireland
    Posts
    44

    Re: MsgBox popup when user enters a value in a cell

    Hi Leigh- ideally I'd like a MsgBox
    Reply With QuoteRegister To Reply
  4. 04-26-2012, 12:50 PM #4
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: MsgBox popup when user enters a value in a cell

    Hello okelly,

    Which cells do you want the message box to popup on?
    Reply With QuoteRegister To Reply
  5. 04-26-2012, 12:50 PM #5
    tigertiger is offline
    Valued Forum Contributor
    Join Date
    11-11-2008
    Location
    Euro
    MS-Off Ver
    2007, 2010
    Posts
    470

    Re: MsgBox popup when user enters a value in a cell

    for each work sheet, there is only a sub named Worksheet_Change corresponding with the even change of worksheet

    So the code is

    Please Login or Register  to view this content.
    if more cells or range you need, change like that
    Please Login or Register  to view this content.
    for example [A1:A2], [C3], [D5:E8]
    Best regard, -)iger-/iger
    If you are pleased with a solution mark your post SOLVED.
    Reply With QuoteRegister To Reply
  6. 04-26-2012, 01:00 PM #6
    okelly is offline
    Registered User
    Join Date
    07-24-2006
    Location
    Dublin, Ireland
    Posts
    44

    Re: MsgBox popup when user enters a value in a cell

    Thanks TigerTiger, works perfect. Thanks also Leigh
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1