+ Reply to Thread
Results 1 to 11 of 11

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

  1. 01-31-2020, 05:43 AM #1
    ashishpatel34
    ashishpatel34 is offline
    Registered User
    Join Date
    06-30-2012
    Location
    Gujarat
    MS-Off Ver
    Excel 2013
    Posts
    36

    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
    Reply With QuoteRegister To Reply
  2. 01-31-2020, 06:06 AM #2
    bakerman2
    bakerman2 is offline
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    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.
    Reply With QuoteRegister To Reply
  3. 01-31-2020, 06:07 AM #3
    NeedForExcel
    NeedForExcel is offline
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    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
    Reply With QuoteRegister To Reply
  4. 01-31-2020, 06:22 AM #4
    ashishpatel34
    ashishpatel34 is offline
    Registered User
    Join Date
    06-30-2012
    Location
    Gujarat
    MS-Off Ver
    Excel 2013
    Posts
    36

    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
    Reply With QuoteRegister To Reply
  5. 01-31-2020, 06:35 AM #5
    ashishpatel34
    ashishpatel34 is offline
    Registered User
    Join Date
    06-30-2012
    Location
    Gujarat
    MS-Off Ver
    Excel 2013
    Posts
    36

    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?
    Reply With QuoteRegister To Reply
  6. 01-31-2020, 06:38 AM #6
    bakerman2
    bakerman2 is offline
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

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

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 01-31-2020, 06:49 AM #7
    ashishpatel34
    ashishpatel34 is offline
    Registered User
    Join Date
    06-30-2012
    Location
    Gujarat
    MS-Off Ver
    Excel 2013
    Posts
    36

    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
    Reply With QuoteRegister To Reply
  8. 01-31-2020, 07:37 AM #8
    nigelog
    nigelog is offline
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    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.
    Reply With QuoteRegister To Reply
  9. 01-31-2020, 08:14 AM #9
    ashishpatel34
    ashishpatel34 is offline
    Registered User
    Join Date
    06-30-2012
    Location
    Gujarat
    MS-Off Ver
    Excel 2013
    Posts
    36

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

    Thanks nigelog it works perfectly
    Reply With QuoteRegister To Reply
  10. 01-31-2020, 08:20 AM #10
    bakerman2
    bakerman2 is offline
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    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.
    Reply With QuoteRegister To Reply
  11. 01-31-2020, 08:25 AM #11
    BMV
    BMV is offline
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    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 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)

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. Display the number value of the cell in scientific value if exceeds certain digits?
    By kannox in forum Excel General
    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. [SOLVED] 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1