Can I have a pop-up message to say that one or more fields are empty, to avoid saving without capturing all the data?
Can I have a pop-up message to say that one or more fields are empty, to avoid saving without capturing all the data?
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.
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
Assign the macro to the button.
.
Are you receiving an error message when you click the button ?
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
What error message are you receiving ?
Also, why not post your workbook for review.
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
.
On SHEET2 of your workbook, there are numerous fields. Which fields do you require the user to complete before the data is saved ?
Hi
I want the fields that are colour-filled to be completed before the data is saved
.
Please Login or Register to view this content.
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...
.
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.
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?
.
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.
Thank you Logit. You have helped me so much.
.
Glad to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks