Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message box help
Hi
In sheet1 A2 to A500 are numbered, I'm working in sheet2 and run a macro, when the macro finishes I'd like a message box to popup telling me what the number is in the cell in sheet1, which moves down 1 cell every time the macro is run. Thanks in advance DaveM |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message box help
Sub macro1()
Static iRow 'do other stuff If iRow = 0 Then iRow = 1 iRow = iRow + 1 MsgBox Sheets("Sheet1").Range("A" & iRow) End Sub Hth, Merjet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
replace VBA run-time error message with custom message | Excel Programming | |||
Replace Excel Message w/Custom Message | Excel Programming | |||
Intercept/replace standard 'cell protected' message with my own message? | Excel Programming | |||
Opening an attachment of a message that has a message as attachmen | Excel Programming | |||
Displaying a message in a message box without requiring user to click anything to proceed | Excel Programming |