If statement and Message Box

[mustanggirl531]

Hi,

I am trying to write a macro so that if the value of one cell is > the value of another cell then a message box appears. I've tried to write it myself but it doesn't seem to work. I've named my two cells HoldUpVol and RinseVol.

Sub RinseMessageBox()
If HoldUpVol > RinseVol Then

MessageBox.Show(Prompt:="The hold up volume on the system selected is more than your rinse volume. Please choose another system.", Buttons:=vbOKOnly)
End If

End Sub

Any help would be greatly appreciated.

Thanks,
Jillian

 

[Rick Rothstein]

Does this line of code do what you want?

MsgBox Prompt:="The hold up volume on the system selected is more than your rinse volume. Please choose another system.", Buttons:=vbOKOnly

 

[mustanggirl531]

Nope...the box doesn't appear when the number in HoldUpVol is > the number in RinseVol.

 

[Rick Rothstein]

Nope...the box doesn't appear when the number in HoldUpVol is > the number in RinseVol.

What are HoldUpVol and RinseVol... real VB variables or Excel range names? Also, what values are in them?

 

[Manohar M G]

Hi,

Check this :

Answer = MsgBox("The hold up volume on the system selected is more than your rinse volume. Please choose another system.", vbOKCancel)..

If you got any error let me know