Clearing Contents ?

**Mhz** · 01-21-2007, 04:14 AM

Hello,

Is there a way I can clear the contents of a predefined area within a
form by simply clicking some type of created RESET button without
using any type of coding? I was hoping this could be done with some
type of excel formula without having to use a script.

example:

Click here to reset your information..

(the information to be cleared would be D5:E30)

Thanks for any helpful respones..

**Bryan Hessey** · 01-21-2007, 04:46 AM

Originally Posted by Mhz

Hello,

Is there a way I can clear the contents of a predefined area within a
form by simply clicking some type of created RESET button without
using any type of coding? I was hoping this could be done with some
type of excel formula without having to use a script.

example:

Click here to reset your information..

(the information to be cleared would be D5:E30)

Thanks for any helpful respones..

Hi,

a formula can affect only the cell in which the formula is located.

The easiest way to do what you ask is to select Tools, Macro. and record a macro, clear the cells, stop recording, then assign a Shortcut key to the macro.

note, you can, of course, add a button to that script as required.

hth
---

**Mhz** · 01-21-2007, 08:10 AM

Thanks Bryan, I think I got it going.

Is there a way to undo the clear contents function just in case a person
clear the fields by mistake? I notice there is no UNDO available when the
contents are cleared.

Or perhaps, is it possible to have a warning before using the clear contents Macro?

thanks for your help..

**VBA Noob** · 01-21-2007, 08:19 AM

Hi,

You can't undo macro usually however John Walkenbach has a tip for you

http://www.j-walk.com/ss/excel/tips/tip23.htm

Just change the zero (0) with "" if you wish

VBA Noob

**Mhz** · 01-21-2007, 09:51 AM

Thanks for the info VBA, although as an ameture I'm a bit confused about where
I should put my range (D5:E30) within the coding. That is the area where
I want cleared.

**VBA Noob** · 01-21-2007, 11:20 AM

Hi,

Add John's code from link to a blank module then use this to call it

Please Login or Register  to view this content.

VBA Noob

Clearing Contents ?

LinkBack

Thread Tools

Rate This Thread

Display

Clearing Contents ?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions