Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Input box inside a macro
Ok, I need to create a button with a macro attached which allows me to delete columns within a worksheet, in this macro I must include an input box which asks the user to either identify as 'the treasurer' and delete all 'financial' data Sheets("Membership").Select Range("G3:H17,K3:K17").Select Range("K3").Activate Selection.ClearContents End Sub or identify as 'the registrar' and delete all 'results' data Sheets("Results").Select Range("E3:I17").Select Selection.ClearContents End Sub how do I this?, above is two seperate macros I have recorded which I want to combine with an input box, can anybody give me an example that I can copy and paste into the macro?? -- Drummy ------------------------------------------------------------------------ Drummy's Profile: http://www.excelforum.com/member.php...o&userid=34780 View this thread: http://www.excelforum.com/showthread...hreadid=549321 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
input conditional formulas using VBA Macro in axcel sheet | Excel Discussion (Misc queries) | |||
using Goal Seek inside a recorded macro | Excel Worksheet Functions | |||
Macro to pause for user input in dialog box | Excel Discussion (Misc queries) | |||
Macro to move to specified cells, pause for input at each? | Excel Discussion (Misc queries) |