tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone
I have an input sheet layed out like a form,
The range is D24:V74
No its all laid out the same with headers and input cell below the headers
If possible, what I like is to Identify the required field with a "*" after the header so "Name*" for example.
then have a macro chedck if every required cell has been filled in
if any are missing bring up a msgbox box saying "The following fields must be completed before proceeding" and list the Header after each other,
so if 3 headers where missing message box would say
"The following fields must be completed before proceeding"
"Name*"
"Email*"
"Age*"
for example.
please help if you can.
thanks
Tony
I have an input sheet layed out like a form,
The range is D24:V74
No its all laid out the same with headers and input cell below the headers
If possible, what I like is to Identify the required field with a "*" after the header so "Name*" for example.
then have a macro chedck if every required cell has been filled in
if any are missing bring up a msgbox box saying "The following fields must be completed before proceeding" and list the Header after each other,
so if 3 headers where missing message box would say
"The following fields must be completed before proceeding"
"Name*"
"Email*"
"Age*"
for example.
please help if you can.
thanks
Tony