| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro to ask yes/no question and continue based on answer
Thanks. Your solution, like Mike H's, works perfectly.
"Per Jessen" wrote: Hi Sub ColToDelete() TargetCol = "D" msg = MsgBox("Do you want to delete column " & TargetCol & " ?", vbYesNo) If msg = vbYes Then Columns(TargetCol).Delete End Sub Regards, Per "JasonP CCTM LV" <JasonP CCTM skrev i meddelelsen ... I am setting up a macro in excel 2007. Is it possible to get excel to ask me if I want to delete a specific column with a yes or no selection and have it delete if I say yes or dont delete if I say no? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I write an Excel macro to pause for data entry then continue? | Excel Discussion (Misc queries) | |||
| Excel Macro: Pause & ask user: "Are you sure you want to continue? | Excel Discussion (Misc queries) | |||
| VB code to continue macro | Excel Discussion (Misc queries) | |||
| Can you pause a macro in excel to input data and continue? | Excel Discussion (Misc queries) | |||
| Create a button to continue old macro execution | Excel Discussion (Misc queries) | |||
![JasonP CCTM LV[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
