Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
push button question
Hello,
I am cvurrently running Excel 2007. 1. Could somebody please tell me how to create a push button within a worksheet. 2. a macro that I can amend which when the buttonj is pressed will clear various cell ranges with in the worksheet. I know it's a lot to ask but all help would be greatfully accepted. Thanks in anticipation Finance Guru Wales - the land of fire breathing dragons and rugby playing wizards |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
push button question
Hello,
In Excel go to View - Toolbars and select Control Toolbox. On the new set of controls lies the command button tool. Click this (it's the square) and click anywhere on your sheet. Double click this button, and it will open the code area. Beneath the line that says Private Sub CommandButton1_Click() Copy and paste the following Sheets("Sheet1").Range("A1:A2").ClearContents Replace Sheet1 with the name of your sheet, and put your own Range where it says "A1:A2". You can have multiple lines in this macro incase you want to delete around something. Hope this helped somewhat. P.S Once you're on your sheet, make sure you click out of DESIGN Mode, the button is blueish on the toolbar, this will make it possible to click the button. "Finance Guru" wrote: Hello, I am cvurrently running Excel 2007. 1. Could somebody please tell me how to create a push button within a worksheet. 2. a macro that I can amend which when the buttonj is pressed will clear various cell ranges with in the worksheet. I know it's a lot to ask but all help would be greatfully accepted. Thanks in anticipation Finance Guru Wales - the land of fire breathing dragons and rugby playing wizards |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
push button question
Hi Nate,
Thanks for the respone. I am new to Excel 2007. If I go to View I cannot see the Control Toolbox anywhere. Any ideas on where in 2007 I can find it? Kind regards Finance Guru. -- Wales - the land of fire breathing dragons and rugby palaying wizards. "NateBuckley" wrote: Hello, In Excel go to View - Toolbars and select Control Toolbox. On the new set of controls lies the command button tool. Click this (it's the square) and click anywhere on your sheet. Double click this button, and it will open the code area. Beneath the line that says Private Sub CommandButton1_Click() Copy and paste the following Sheets("Sheet1").Range("A1:A2").ClearContents Replace Sheet1 with the name of your sheet, and put your own Range where it says "A1:A2". You can have multiple lines in this macro incase you want to delete around something. Hope this helped somewhat. P.S Once you're on your sheet, make sure you click out of DESIGN Mode, the button is blueish on the toolbar, this will make it possible to click the button. "Finance Guru" wrote: Hello, I am cvurrently running Excel 2007. 1. Could somebody please tell me how to create a push button within a worksheet. 2. a macro that I can amend which when the buttonj is pressed will clear various cell ranges with in the worksheet. I know it's a lot to ask but all help would be greatfully accepted. Thanks in anticipation Finance Guru Wales - the land of fire breathing dragons and rugby playing wizards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Push button and input box? | Excel Discussion (Misc queries) | |||
Time with the push of one button | New Users to Excel | |||
push a command button | Excel Programming | |||
Push the button | Excel Programming | |||
Which button did I push | Excel Programming |