How to notify the person to fill in the empty field

[Domenico]

Hi everyone my querie is I'm creating a fill in / order form whereby I
require the consumer to fill in the neccerary fields.

Example the Consumer puts his/her details in. They happen to not fill in the
field "Name of Dealer". I want the document to notify the consumer that the
"Name of Dealer" field needs to be filled in, either wise this form can not
be sent via email.

PLEASE HELP!!!

 

[Héctor Miguel]

hi, Domenico !

Hi everyone my querie is I'm creating a fill in / order form whereby I require the consumer to fill in the neccerary fields.
Example the Consumer puts his/her details in. They happen to not fill in the field "Name of Dealer".
I want the document to notify the consumer that the "Name of Dealer" field needs to be filled in
either wise this form can not be sent via email...

try using conditional formatting for the user can "see" any field that needs to be filled -?-
another options could include the use of code (i.e.) to prevent selectionchange from current unfilled fields -?-

hth,
hector.

 

[Domenico]

hi, Domenico !


try using conditional formatting for the user can "see" any field that needs to be filled -?-
another options could include the use of code (i.e.) to prevent selectionchange from current unfilled fields -?-

hth,
hector.

Hi Hector

Thanks so much, I forgot to mention that my Excel knowledge is pretty
limited so I'm not sure how to use conditional formatting and or coding.
Sorry about that, if you can help, it would be greatly appreciated.Domenico

 

[David Biddulph]

If you don't know how to use conditional formatting, look it up in Excel
help. Similarly with other things about which you are still learning.

 

[Héctor Miguel]

hi, Domenico !

Thanks so much, I forgot to mention that my Excel knowledge is pretty limited
so I'm not sure how to use conditional formatting and or coding.
Sorry about that, if you can help, it would be greatly appreciated.

let's suppose your filling cells is A1, B3:C3 & E6

- select the cells in reverse order and make sure A1 remains as the active cell
- go to (menu) format > format conditions > use "formula": =isblank(a1)
- apply formats as you wish/need/... (i.e. back color in black)

for a code solution, it might be something like this:
- right-click on that sheet tab-name and choose "view code"
- copy/paste (or type) the following (replace whatever in the code module if necessary)

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With Range("a1,b3:c3,e6")
If Intersect(Target, Range(.Address)) Is Nothing Then _
If Evaluate("counta(" & .Address & ")") <> .Cells.Count Then _
.Cells.Find(Empty).Select: MsgBox "Please, don't forget to fill this cell !!!"
End With
End Sub

hth,
hector.

__ OP __

 

[Domenico]

Hi Hector, I'm so sorry for not replying sooner. Thanks for the code I'm
going to try it and try to make sense of it. If I have any queries can I send
a message. Thanks so much for your help.