Generating Error messages for empty fields in Excel
Generate error messages based on what is selected. Use Vba to generate error messages. Use the isempty command. Check that a merged and centred field is empty
For more help visit my website
I am able to provide online help on your computer for a reasonable rate.
MY videos are all created on Camtasia.
Check out my courses
Follow me on Facebook
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
This is good but as a user, how would the macro get run? No command button to save the data or anything. The point of this code would be to make sure the form is filled out completely by someone else? The macro won't run automatically so it they leave comments blank after choosing termination at what point would they be prompted? This video seems incomplete on the full process on how it would work for the user.
What if you need to have more than one for the comments – like the termination and then they pick new hire and you still want them to fill out comments?
This was just what I was looking for! Thank you