View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Vergel Adriano Vergel Adriano is offline
external usenet poster
 
Posts: 857
Default Macro that opens a window giving you info in a few cells

How about something like this:

Private Sub ShowMessage()
With ActiveSheet
MsgBox "M1 = " & .Range("M1").Text & vbNewLine & _
"Q1 = " & .Range("Q1").Text & vbNewLine & _
"U1 = " & .Range("U1").Text & vbNewLine & _
"Y1 = " & .Range("Y1").Text
End With
End Sub


"One-Leg" wrote:

Hello,

I have an Excel document with info being updated on a daily base. I have 4
cells (M1 - Q1 - U1 - Y1) in which I have info.

I would like to run a macro that when launched, it will give me a little
window telling me the 4 infos...

Is that possible???

Thanks!!!