Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
HI,
I'd like to add a message box that requires no input to the following macro. The message box should say "Reviewing Row [i]" and should close when the macro is done. THANKS! Private Sub CommandButton1_Click() Dim i As Long i = 7 Do If Sheets(2).Cells(i, 8).Value = "CLOSED" Then Rows(i).EntireRow.Hidden = True End If i = i + 1 Loop Until i = 300 End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro to extraxt information | Excel Programming | |||
Macro to change information | Excel Discussion (Misc queries) | |||
Macro to retrieve information | Excel Discussion (Misc queries) | |||
INFORMATION MESSAGE BY MACRO | Excel Programming | |||
Macro additional information | Excel Programming |