View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob Rob is offline
external usenet poster
 
Posts: 718
Default How to reference a cell into a Dialog Box ?

Hi,
In the code below I have included a Dialog Box named CriteriaReached to show
if cell g6 < h6 < k6.

My question being. Is it possible to reference a cell with text in it into
the Box?

Sub CheckVolumeRise1()
If Range("g6") < Range("h6") < Range("k6") Then
CriteriaReached.Show
End If
End Sub

Thank you.