Display a msgbox if value in a cell
Solved
myke59
Posted messages
3
Status
Membre
-
myke59 Posted messages 3 Status Membre -
myke59 Posted messages 3 Status Membre -
Hello,
I'm a beginner in VBA
I'm rather someone who can manage, but I'm starting to lose patience on a topic that seems very simple to me
Before throwing the PC out the window, I'm coming to ask for your help.
Sub macro1()
Worksheets("Sheet1").Select
If Cells(1, 2).Value = "1" Then
MsgBox ("1 is in cell B1")
End Sub
I specify that data validation does not seem to apply since what is in cell B1 is the result of a formula.
If any of you have solved this before, I would be happy to know how...
A big thank you in advance! :)
Configuration: Windows XP / Chrome 23.0.1271.64
I'm a beginner in VBA
I'm rather someone who can manage, but I'm starting to lose patience on a topic that seems very simple to me
Before throwing the PC out the window, I'm coming to ask for your help.
Sub macro1()
Worksheets("Sheet1").Select
If Cells(1, 2).Value = "1" Then
MsgBox ("1 is in cell B1")
End Sub
I specify that data validation does not seem to apply since what is in cell B1 is the result of a formula.
If any of you have solved this before, I would be happy to know how...
A big thank you in advance! :)
Configuration: Windows XP / Chrome 23.0.1271.64
