Anyone who can help me with Excel?

Larumbelle

I'm hoping someone can tell me how to do this. I'm not sure how difficult or easy this is.
I want to create a button that will clear the contents of certain cells. Could someone tell me how to go about it? I've tried googling a description of what i'm trying to do, but I can't find what I mean to do.

Thanks x

ManAtHome

F1 just starting - try googling EXCEL COMMANDBUTTON - think this is what you're after. Come back if you get stuck.

totalsolutions

http://www.mrexcel.com/

Larumbelle

Thank you both for your help. I have figured it out

(not really. A friend is coming round to do it for me :rotfl:)

Thanks though. I've bookmarked that page for next time I get stuck.

Stubert

You need to create a button, and then assign a macro too it. Start recording and then clear the cells then stop recording. Thats probably a bit simplistic but I think thats how you do it!

waynedance

Stubert wrote: »

You need to create a button, and then assign a macro too it. Start recording and then clear the cells then stop recording. Thats probably a bit simplistic but I think thats how you do it!

you got it record a macro and use a shortcut.........