Hello to all.
This macro:
you must enter a date in cell A mandatory
Please Login or Register to view this content.
Now I added mandatory too column B / C / D but the warning appears 3 times, but it should only appear in the selected cell.
you can edit?Please Login or Register to view this content.
xam
Last edited by xam99; 01-12-2020 at 04:47 AM.
Why not just exit the sub after the first failed test?Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim cella As Range
Application.EnableEvents = False
'Set cella = Range("A3") '<<< cella singola
'Set cella = Cells(Target.Row, Target.Column) '<<< colonna
Set cella = Cells(Target.Row, 1) '<<< cella singola
With cella
If .Value = "" Then
'MsgBox "Devi inserire una data nella cella A" & Target.Row & " ", vbCritical, "Errore!"
MsgBox "You must enter a date in cell A" & Target.Row & " ", vbCritical, "Errore!"
End If
End With
' ...... etc
End Sub
e.g.HTHPlease Login or Register to view this content.
Tim
EDIT
Remember to re-enable events!
Please Login or Register to view this content.
Last edited by harrisonland; 01-12-2020 at 05:50 AM.
For starters. This one will only give 1 messagebox when data is missing in one of the columns.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Thanks bakerman2 but the message must be referred to the cell to be inserted
Hi harrisonland your modified:
work well.Please Login or Register to view this content.
Thans you
xam
Please Login or Register to view this content.
Haha! Bakerman2's solution is far more elegant (as usual), why not tweak it a bit to make it flexible:
TimPlease Login or Register to view this content.
Never stop learning!
<--- please consider *-ing !
Thanks bakerman2 and harrisonland
the warning must be referred to the cell, see my first thread
data / reparto / operatore / tempo
Didn't notice there was always a different message.
Please Login or Register to view this content.
Hi bakerman2 the new modified work well.
i tried moving the required cells now are:
A / D and E / F but as I did it doesn't work
Please Login or Register to view this content.
Post an example file with the new layout.
Here is an example.
Another thing must start from row 3
Try this then.
Please Login or Register to view this content.
Thanks bakerman2 I think it is correct now.
To be sure I have to try the macro in the office where I work.
A greeting and thanks again.
xam
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks