+ Reply to Thread
Results 1 to 3 of 3

Using VBA Wksht Change Codes to Show MsgBoxes

  1. #1
    Registered User
    Join Date
    09-02-2015
    Location
    Grand Rapids, MI
    MS-Off Ver
    2013
    Posts
    5

    Using VBA Wksht Change Codes to Show MsgBoxes

    The below VBA does prompt users with an information box when anything is typed in the target cells, but I would like the prompts to work when the target cell values are more than 44000 for the one message and more than 3200 for the later. Please advise how I can change or add lines to make this work accordingly.

    Please Login or Register  to view this content.
    Last edited by SheavF; 09-10-2015 at 08:00 AM.

  2. #2
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    2007
    Posts
    3,475

    Re: Using VBA Wksht Change Codes to Show MsgBoxes

    Hi SheavF,

    Welcome to the forum!!

    Once you put tags around your code as per Rule 3 from here which you recently agreed to when you signed up, I'll try and provide an answer.

    Thanks,

    Robert
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post

  3. #3
    Registered User
    Join Date
    09-02-2015
    Location
    Grand Rapids, MI
    MS-Off Ver
    2013
    Posts
    5

    Re: Using VBA Wksht Change Codes to Show MsgBoxes

    My co-worker figured it out... I had to remove the quotes from the Target.Value.

    Before: If Target.Value > "44000" Then
    After: If Target.Value > 44000 Then

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Suppressing msgboxes appearing during loop
    By msixdatateam in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-24-2014, 01:13 PM
  2. Replies: 4
    Last Post: 08-12-2013, 01:35 PM
  3. Need to suppress MsgBoxes
    By bconner in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-20-2009, 02:12 PM
  4. copy text strings form multiple wksht to single wksht
    By Richard.Alcantar in forum Excel General
    Replies: 1
    Last Post: 12-09-2008, 01:50 PM
  5. Replies: 1
    Last Post: 03-10-2007, 10:20 PM
  6. [SOLVED] How do I Change Column Width for only some rows in an Xcel WkSht
    By Cherokee in forum Excel General
    Replies: 1
    Last Post: 07-29-2006, 08:25 PM
  7. change footer in workbook w/o changing on each wksht?
    By Zolli6769 in forum Excel General
    Replies: 2
    Last Post: 04-20-2005, 04:06 PM

Tags for this Thread

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