+ Reply to Thread
Results 1 to 17 of 17

Pop-up Message

  1. #1
    Registered User
    Join Date
    09-16-2014
    Location
    Durban, South Africa
    MS-Off Ver
    MS Excel Office 365
    Posts
    30

    Question Pop-up Message

    Can I have a pop-up message to say that one or more fields are empty, to avoid saving without capturing all the data?

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Pop-up Message

    The following checks cell range A1:A20. If any of those cells is blank, a pop up MsgBox appears.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-16-2014
    Location
    Durban, South Africa
    MS-Off Ver
    MS Excel Office 365
    Posts
    30

    Re: Pop-up Message

    Hi Logit

    Thank you for responding.

    I am trying your Excel workbook out, and when I delete info. from A1: A20 nothing is happening? Is there something else that I need to be doing?

    Kind Regards
    Sash

  4. #4
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Pop-up Message

    Assign the macro to the button.

  5. #5
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Pop-up Message

    .
    Are you receiving an error message when you click the button ?

  6. #6
    Registered User
    Join Date
    09-16-2014
    Location
    Durban, South Africa
    MS-Off Ver
    MS Excel Office 365
    Posts
    30

    Re: Pop-up Message

    Hi Logit

    Thank you so much for your help.

    I have assigned the macro to the button and am getting the "Error" message, but am struggling to apply your VBA code to my information.

    I am not very clued up on VBA, so I am looking to input this kind of functionality, using MS Excel commands; can you help with that?

    Kind Regards
    Sash

  7. #7
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Pop-up Message

    What error message are you receiving ?

    Also, why not post your workbook for review.

  8. #8
    Registered User
    Join Date
    09-16-2014
    Location
    Durban, South Africa
    MS-Off Ver
    MS Excel Office 365
    Posts
    30

    Re: Pop-up Message

    Hi Logit

    I am getting the "Error" message after I delete information from any cell between A1:A20 on your work book and then press the 'Button'.

    I have attached an example of the workbook I am working on, into the file you originally attached. I want to make sure all cells that are colour-filled are not left blank, so an error
    message should pop-up before the information is saved.


    Kind Regards
    Sash
    Attached Files Attached Files

  9. #9
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Pop-up Message

    .
    On SHEET2 of your workbook, there are numerous fields. Which fields do you require the user to complete before the data is saved ?

  10. #10
    Registered User
    Join Date
    09-16-2014
    Location
    Durban, South Africa
    MS-Off Ver
    MS Excel Office 365
    Posts
    30

    Re: Pop-up Message

    Hi

    I want the fields that are colour-filled to be completed before the data is saved

  11. #11
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Pop-up Message

    .
    Please Login or Register  to view this content.

  12. #12
    Registered User
    Join Date
    09-16-2014
    Location
    Durban, South Africa
    MS-Off Ver
    MS Excel Office 365
    Posts
    30

    Re: Pop-up Message

    Hi Logit

    I am going to now ask you a question, that is going to make you laugh at me: How do I put this VBA Code into my actual workbook? I have no idea...

  13. #13
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Pop-up Message

    .

    Open the workbook.

    Click on DEVELOPER tab on top menu selections.

    Click VISUAL BASIC - left side of menu bar.

    Click MODULES on left side (white colored window).

    DOUBLE CLICK MODULE1.

    In the large white colored window on right side, paste this macro.




    Please Login or Register  to view this content.

  14. #14
    Registered User
    Join Date
    09-16-2014
    Location
    Durban, South Africa
    MS-Off Ver
    MS Excel Office 365
    Posts
    30

    Re: Pop-up Message

    Hi Logit

    I have done that, and it works. Thanks a million for that.

    Do you know whether a Macro can operate within a Macro?

  15. #15
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Pop-up Message

    .
    You can include macro code within another macro ... yes.

    How well it works depends on the goal and how it is coded. Sometimes it is just as easy or easier to have the code separate in another macro and
    include a "call" to the other macro from within the first macro.

    Do some Googling on some of those terms to learn more. When you run in to a problem, post in a new thread for assistance.

  16. #16
    Registered User
    Join Date
    09-16-2014
    Location
    Durban, South Africa
    MS-Off Ver
    MS Excel Office 365
    Posts
    30

    Re: Pop-up Message

    Thank you Logit. You have helped me so much.

  17. #17
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Pop-up Message

    .
    Glad to help.

+ 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. Replies: 1
    Last Post: 05-30-2018, 12:17 PM
  2. Adding an input message to each cell to bring back corrsponding message
    By Nic31 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-01-2014, 09:28 AM
  3. [SOLVED] How to pop up a warning message before any Excel automatic update link reminder message
    By billj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2013, 10:41 AM
  4. Extracting mail message(outlook) table in the message body
    By andywsw in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2012, 10:14 PM
  5. need of pop up message dynamically using data validation input message method
    By vba_life in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2010, 09:03 AM
  6. [SOLVED] replace VBA run-time error message with custom message
    By BEEJAY in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-14-2006, 11:05 AM
  7. Intercept/replace standard 'cell protected' message with my own message?
    By KR in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-16-2006, 10:35 AM

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