+ Reply to Thread
Results 1 to 11 of 11

I want to display MsgBox if the value exceeds the value is Cell

  1. #1
    Registered User
    Join Date
    06-30-2012
    Location
    Gujarat
    MS-Off Ver
    Excel 2013
    Posts
    35

    I want to display MsgBox if the value exceeds the value is Cell

    Hey Guys

    I need your help I am not able to find out the right code for a function.

    I want to display MsgBox in my excel if the value entered in the column B7 is greater than or equal to 310.

    MsgBox "This will be an ODC shipment".

    Please help me in this case.

    Regards
    Ashish Patel

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,630

    Re: I want to display MsgBox if the value exceeds the value is Cell

    Something like this. In Sheet Module.

    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  3. #3
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,785

    Re: I want to display MsgBox if the value exceeds the value is Cell

    Hi,

    Please Login or Register  to view this content.
    Put this on the Worksheet Module, not on a regular code module..
    Last edited by NeedForExcel; 01-31-2020 at 06:09 AM.
    Cheers!
    Deep Dave

    www.NeedForExcel.com

  4. #4
    Registered User
    Join Date
    06-30-2012
    Location
    Gujarat
    MS-Off Ver
    Excel 2013
    Posts
    35

    Re: I want to display MsgBox if the value exceeds the value is Cell

    Thanks bakerman2 thank you very much this code is perfect and works perfectly

  5. #5
    Registered User
    Join Date
    06-30-2012
    Location
    Gujarat
    MS-Off Ver
    Excel 2013
    Posts
    35

    Re: I want to display MsgBox if the value exceeds the value is Cell

    If I want to apply the code to a particular range in the column B7 to B37 then how should I do?

  6. #6
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,630

    Re: I want to display MsgBox if the value exceeds the value is Cell

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    06-30-2012
    Location
    Gujarat
    MS-Off Ver
    Excel 2013
    Posts
    35

    Re: I want to display MsgBox if the value exceeds the value is Cell

    Now If I want to apply this code to three more columns but it is showing error, I want to use it for range B7to B37 C7 to C37 & D7toD37

  8. #8
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,138

    Re: I want to display MsgBox if the value exceeds the value is Cell

    Change Bakermans code to
    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    06-30-2012
    Location
    Gujarat
    MS-Off Ver
    Excel 2013
    Posts
    35

    Re: I want to display MsgBox if the value exceeds the value is Cell

    Thanks nigelog it works perfectly

  10. #10
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,630

    Re: I want to display MsgBox if the value exceeds the value is Cell

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

  11. #11
    Valued Forum Contributor BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,163

    Re: I want to display MsgBox if the value exceeds the value is Cell

    Please Login or Register  to view this content.
    and in any cell
    Please Login or Register  to view this content.
    its allow to inform if a formula in the B7.
    for the range
    Please Login or Register  to view this content.
    Last edited by BMV; 01-31-2020 at 08:29 AM.

+ 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. [SOLVED] Iterate through row and then msgbox if value in column exceeds a set number
    By ihb95 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-01-2019, 07:12 AM
  2. [SOLVED] Cell match to display msgbox if found
    By Templemind in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-27-2014, 07:22 AM
  3. MsgBox when cell value in column exceeds a threshold.
    By Stew1234 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-14-2014, 02:41 PM
  4. Replies: 0
    Last Post: 01-19-2012, 02:55 PM
  5. Display a message when a Cell value exceeds 75% of the total allowed expenditure
    By chamdan in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-15-2011, 12:38 AM
  6. WordWrap exceeds cell display
    By Mack in forum Excel General
    Replies: 1
    Last Post: 08-01-2006, 10:20 AM
  7. display cell value in msgbox formatted as %
    By rgarber50 in forum Excel General
    Replies: 5
    Last Post: 07-10-2005, 11:05 AM

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