Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Wait for user to change data after msgbox ????
Hi
I have a macro where it creates an Invoice from data on different sheets ... but when complete I need to ask the user if any changes are required to it. If yes then allow changes but not lose place in macro... so that print and clear up routines can be run Any ideas please !!!!! -- Trev in Canada |
#2
|
|||
|
|||
Trev,
If MsgBox("Is there more?", vbYesNo) = vbYes Then ' ... code for more Else ' ... code for no more End If or Response = MsgBox("Is there more", vbYesNo) If Response = vbYes Then ' ... code for yes end if End Sub -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "CanadianTrev" wrote in message ... Hi I have a macro where it creates an Invoice from data on different sheets ... but when complete I need to ask the user if any changes are required to it. If yes then allow changes but not lose place in macro... so that print and clear up routines can be run Any ideas please !!!!! -- Trev in Canada |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I change my data, my formulas don't update the answers,why? | Excel Discussion (Misc queries) | |||
How do I change from all caps to regular for existing data? | Excel Discussion (Misc queries) | |||
How do I change a data series from bars to lines in an Excel char. | Charts and Charting in Excel | |||
How do I change a cell so I can have the data it contains in seve. | Excel Discussion (Misc queries) | |||
change font color of first cell in data table attached to chart | Charts and Charting in Excel |