Command button to clear inputs
 

Could you help me with the macro so I could assign a button to clear inputs?
Is there a place to go to look up different macros? I don't have much
experience with this and it is hard to know what to put so the macro will
work.

Thanks!

Command button to clear inputs
 

One possibility is discussed he
http://groups.google.com/group/micro...9d357cb00e8f77

As to looking up macros: this is the google search I did to find the above
link:
http://www.google.com/search?sourcei...o+clear+values

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"mbing916" wrote:

Could you help me with the macro so I could assign a button to clear inputs?
Is there a place to go to look up different macros? I don't have much
experience with this and it is hard to know what to put so the macro will
work.

Thanks!

Command button to clear inputs
 

You could record a macro by going 'tools'....'macro'....'record new macro'
and manually delete the data from the cells you want it gone from. When you
have made the last deletion stop the macro and assign it to a key or create a
button and assign the macro to the button.

"mbing916" wrote:

Could you help me with the macro so I could assign a button to clear inputs?
Is there a place to go to look up different macros? I don't have much
experience with this and it is hard to know what to put so the macro will
work.

Thanks!

Command button to clear inputs
 

You need to supply some more details to get anything other than a few guesses.

What "inputs" need to be cleared and when?

Sub Clearit()
Selction.ClearContents
End Sub

Will clear all data from the selected cells.

The Delete key will do the same thing.

Why do you think you need a macro?


Gord Dibben MS Excel MVP


On Mon, 2 Apr 2007 12:36:04 -0700, mbing916
wrote:

Could you help me with the macro so I could assign a button to clear inputs?
Is there a place to go to look up different macros? I don't have much
experience with this and it is hard to know what to put so the macro will
work.

Thanks!

Command button to clear inputs
 

Typo Alert

Selction.ClearContents
Selection.ClearContents

For the OP
If you select the cells you want to clear with the CTRL key down you can give the cells a name with Ctrl-F3.

After that you can use
Range("YourRangeName").ClearContents



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
You need to supply some more details to get anything other than a few guesses.

What "inputs" need to be cleared and when?

Sub Clearit()
Selction.ClearContents
End Sub

Will clear all data from the selected cells.

The Delete key will do the same thing.

Why do you think you need a macro?


Gord Dibben MS Excel MVP


On Mon, 2 Apr 2007 12:36:04 -0700, mbing916
wrote:

Could you help me with the macro so I could assign a button to clear inputs?
Is there a place to go to look up different macros? I don't have much
experience with this and it is hard to know what to put so the macro will
work.

Thanks!

Command button to clear inputs
 

I am trying to set up an application and price quote forms as part of a
workbook. I would like the clear inputs button so all the cells that have
had data entered can be cleared at once vs. manually deleted since the
workbook will be used for multiple customers.

"Gord Dibben" wrote:

You need to supply some more details to get anything other than a few guesses.

What "inputs" need to be cleared and when?

Sub Clearit()
Selction.ClearContents
End Sub

Will clear all data from the selected cells.

The Delete key will do the same thing.

Why do you think you need a macro?


Gord Dibben MS Excel MVP


On Mon, 2 Apr 2007 12:36:04 -0700, mbing916
wrote:

Could you help me with the macro so I could assign a button to clear inputs?
Is there a place to go to look up different macros? I don't have much
experience with this and it is hard to know what to put so the macro will
work.

Thanks!

Command button to clear inputs
 

Follow Ron's advice and create named ranges then run his code to delete values
from each named range you choose.


Gord

On Mon, 2 Apr 2007 13:24:02 -0700, mbing916
wrote:

I am trying to set up an application and price quote forms as part of a
workbook. I would like the clear inputs button so all the cells that have
had data entered can be cleared at once vs. manually deleted since the
workbook will be used for multiple customers.

"Gord Dibben" wrote:

You need to supply some more details to get anything other than a few guesses.

What "inputs" need to be cleared and when?

Sub Clearit()
Selction.ClearContents
End Sub

Will clear all data from the selected cells.

The Delete key will do the same thing.

Why do you think you need a macro?


Gord Dibben MS Excel MVP


On Mon, 2 Apr 2007 12:36:04 -0700, mbing916
wrote:

Could you help me with the macro so I could assign a button to clear inputs?
Is there a place to go to look up different macros? I don't have much
experience with this and it is hard to know what to put so the macro will
work.

Thanks!

Command button to clear inputs
 

Thanks for all the tips! I got it to work.

"Ron de Bruin" wrote:

Typo Alert

Selction.ClearContents
Selection.ClearContents

For the OP
If you select the cells you want to clear with the CTRL key down you can give the cells a name with Ctrl-F3.

After that you can use
Range("YourRangeName").ClearContents



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
You need to supply some more details to get anything other than a few guesses.

What "inputs" need to be cleared and when?

Sub Clearit()
Selction.ClearContents
End Sub

Will clear all data from the selected cells.

The Delete key will do the same thing.

Why do you think you need a macro?


Gord Dibben MS Excel MVP


On Mon, 2 Apr 2007 12:36:04 -0700, mbing916
wrote:

Could you help me with the macro so I could assign a button to clear inputs?
Is there a place to go to look up different macros? I don't have much
experience with this and it is hard to know what to put so the macro will
work.

Thanks!