|
||
|
|
|||||||
| Welcome to the Exploding Garrmondo Weiner Interactive Swiss Army Penis. |
|
GFF is a community of gaming and music enthusiasts. We have a team of dedicated moderators, constant member-organized activities, and plenty of custom features, including our unique journal system. If this is your first visit, be sure to check out the FAQ or our GFWiki. You will have to register before you can post. Membership is completely free (and gets rid of the pesky advertisement unit underneath this message).
|
![]() |
|
|
Thread Tools |
Silly Excel Question - VBA may be necessary
So... my boss wants me to add a little sumthin to an excel spreadsheet he has. It's a very simple table, and he wants a button that he clicks and it clears the fields of the table. I know, this is stupid. You could simply highlight them all and press delete. But it's all about pleasing the boss. Can someone point me in the right direction to find a tutorial on how to do this? Or perhaps post an example? Thanks guys.
I also realize I could use a macro, I'll use this if I have trouble creating a pretty delete button for him. Jam it back in, in the dark. |
Clear cells in excel? - Yahoo! Answers
Clear Button - Excel Help Forum You will have to name the table range, record a macro of you clearing it, and then map the macro to a pretty delete button. There's nowhere I can't reach. |
Thanks for the quick reply Zergrinch. That works perfectly... on Excel 2007. Unfortunately at my office we have 2003, and I got the macro to work just fine with a hotkey, but assigning it to a button I haven't been able to figure out yet.
EDIT: Okay, I found that when I insert a shape, I can assign a macro to it, but when it's a button I have trouble. No problem though, I can make a shape look just like a button :P I'd still like to know how to assign one to a button out of curiousity. EDIT #2: Well I decided to copy the code from a macro into the code of the button, which worked just fine. I guess there isn't a way to just assign a macro to a button in 2003 like there is in 2007. How ya doing, buddy? |
![]() |
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| The impossible quiz! | S_K | Pang's Violence Basement | 16 | Sep 12, 2007 11:39 AM |
| This is a really silly question... | Divest | Help Desk | 5 | Aug 24, 2007 10:57 AM |
| This is a silly question, but... | Dark Chocolate | Help Desk | 7 | Oct 24, 2006 10:49 PM |
| I have a silly question - please don't be mean. ;_; | I poked it and it made a sad sound | Board Support | 5 | Aug 29, 2006 06:01 PM |
| Silly Question | The GreyFox | Help Desk | 4 | Jul 27, 2006 04:13 PM |