Including an inputbox within a macro

D

Drummy

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? can anybody give me an example that I can copy and paste
into the macro??
 
B

Bob Phillips

see other thread (excel.misc)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Including an input box within a macro 1
input box within macro 1
Input box inside a macro 3
putting an input box inside a macro 1
Run macro from active workbook whose name keeps changing 20
Run Time Error 6
Clearing an Active X text box with a macro 3
Deactivate macros but reactivate again once another macro is run 2

Top