Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pause
hi,
I have the following: '//------------------------------------------------- '-Make sure total lines titled "totals" in sheet "options" are all equal '//------------------------------------------------- Sheets("options").Activate Sheets("options").Select MsgBox "Make sure total lines titled 'totals' in sheet optionsare all equal" I would like for the code to be able to pause to allow the user to actually performs what the messagebox is instructing, then for the code to continue execution when the user clicks the messagebox or something. How can I do this? Thanks in advance, geebee |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
pause
use a modeless Userform to display your message.
Userform1.show vbModeless -- Regards, Tom Ogilvy "geebee" wrote: hi, I have the following: '//------------------------------------------------- '-Make sure total lines titled "totals" in sheet "options" are all equal '//------------------------------------------------- Sheets("options").Activate Sheets("options").Select MsgBox "Make sure total lines titled 'totals' in sheet optionsare all equal" I would like for the code to be able to pause to allow the user to actually performs what the messagebox is instructing, then for the code to continue execution when the user clicks the messagebox or something. How can I do this? Thanks in advance, geebee |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
pause
hi,
Then how do I resume back to the code after the form is closed, without putting all of the code that follows in the UserForms "contunue button" I added? Thanks in advance, geebee "Tom Ogilvy" wrote: use a modeless Userform to display your message. Userform1.show vbModeless -- Regards, Tom Ogilvy "geebee" wrote: hi, I have the following: '//------------------------------------------------- '-Make sure total lines titled "totals" in sheet "options" are all equal '//------------------------------------------------- Sheets("options").Activate Sheets("options").Select MsgBox "Make sure total lines titled 'totals' in sheet optionsare all equal" I would like for the code to be able to pause to allow the user to actually performs what the messagebox is instructing, then for the code to continue execution when the user clicks the messagebox or something. How can I do this? Thanks in advance, geebee |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
pause
You would have to put a continue button on the userform for the user to
indicate they had finished doing their work on the worksheet. Lotus has the provision for the code to pause and let the user make changes on the sheet. Excel doesn't have that capability. so you have to kludge together a solution if your want to do that. Without knowing what you are doing, I would have the code check the condition that needs to be satisfied and if the code couldn't fix it itself, then warn the user and quit. Tell them to run the procedure again when they have fixed the sheet. -- Regards, Tom Ogilvy "geebee" wrote: hi, Then how do I resume back to the code after the form is closed, without putting all of the code that follows in the UserForms "contunue button" I added? Thanks in advance, geebee "Tom Ogilvy" wrote: use a modeless Userform to display your message. Userform1.show vbModeless -- Regards, Tom Ogilvy "geebee" wrote: hi, I have the following: '//------------------------------------------------- '-Make sure total lines titled "totals" in sheet "options" are all equal '//------------------------------------------------- Sheets("options").Activate Sheets("options").Select MsgBox "Make sure total lines titled 'totals' in sheet optionsare all equal" I would like for the code to be able to pause to allow the user to actually performs what the messagebox is instructing, then for the code to continue execution when the user clicks the messagebox or something. How can I do this? Thanks in advance, geebee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Best way to pause? | Excel Programming | |||
Pause a macro? | Excel Programming | |||
Pause a Macro? | Excel Programming | |||
Pause | Excel Programming | |||
Pause? | Excel Programming |