+ Reply to Thread
Results 1 to 5 of 5

MsgBox with range

  1. #1
    Registered User
    Join Date
    12-13-2018
    Location
    Davenport, IA
    MS-Off Ver
    Office365
    Posts
    5

    MsgBox with range

    Ok I have been searching for awhile doing a project for work. I am trying to create a macro that will display a message box when a value of B13 through AW13 is greater than 3.5. So if B13 is calculated higher than 3.5 I need a message to pop up saying Resample and later on if I get a value in J13 it to pop up saying the samething. I currently have it so it will pop up however, if B13 is higher than 3.5 then every time I enter more data the message continues popping up I only want it to pop up once per time it sees over 3.5 in those cells. I will attach my excel so you can see what I am referring to.Untitled.png
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: MsgBox with range

    There's no data in the workbook you uploaded which makes formulating a response so much harder.
    Please upload one with some real data and explain how you use the system, where you add stuff..etc and what you expect the result should be.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    12-13-2018
    Location
    Davenport, IA
    MS-Off Ver
    Office365
    Posts
    5

    Re: MsgBox with range

    I see my formulas and code on the workbook, anyways using B10, B11, and B12 I have a formula on B13 that gives me a number. If this number is above 3.5 I need a messagebox to pop like displayed in my photo. The same formula is used across the whole page C10, C11, and C12 displays a value in C13. All the way to AW. I have no issue getting the message box to open as it should, my problem is it continues popping the box over and over everytime I type another number in doesn't matter where, it is like it continues to pop up from B13 when I only need it to open 1 time for B13 if it is above 3.5

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: MsgBox with range

    try this,

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  5. #5
    Registered User
    Join Date
    12-13-2018
    Location
    Davenport, IA
    MS-Off Ver
    Office365
    Posts
    5

    Re: MsgBox with range

    This worked thankyou very much

+ 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] Msgbox if certain value exists in range
    By Crispy85 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-19-2016, 09:40 AM
  2. [SOLVED] Msgbox all empty rows in a range
    By nickmax1 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 09-11-2014, 11:48 AM
  3. [SOLVED] If range contains value then msgbox (but just once)
    By papasmurfuo9 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2014, 07:40 AM
  4. [SOLVED] Show sum value of range in msgbox
    By TimmerSuds in forum Excel General
    Replies: 5
    Last Post: 06-18-2014, 06:27 AM
  5. msgbox containing the range of values
    By AbdallahHajbed in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-23-2012, 12:35 PM
  6. MsgBox if a range of cells do not sum to 100%
    By kchen in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-29-2010, 04:18 AM
  7. Add data to range using MsgBox
    By dmspen in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-28-2008, 12:43 PM

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