Hello everyone.
I have this macro with 3 if-else-then to display 3 alerts:
If Cells(3, 1) = "" And Cells(2, 2).Value = "no" Then '=A3
MsgBox "Devi PRIMA incollare i dati da suddividere", vbCritical + vbOKOnly, "Attenzione!" 'OK
Exit Sub
'--------------------------------------------1
ElseIf Cells(6, 1) <> "" And Cells(2, 2).Value = "no" Then '=A6/B2
risp = MsgBox("divido in colonne?....", vbQuestion + vbYesNo + vbDefaultButton2, "Attenzione!")
If risp = vbNo Then Exit Sub
'--------------------------------------------2
Else
If Cells(3, 1) <> "" And Cells(2, 2).Value = "si" Then '=A3/B2
MsgBox "Dati gią inseriti", vbCritical + vbOKOnly, "Attenzione!" 'OK
Exit Sub
'--------------------------------------------3
End If
End If
I can not view them in order.
I am attaching an example.
I hope I explained.
A help?
max_max
testo colonne avvisi.xls
Bookmarks