Excel . Reset Button - ??

[portugueselink]

Is it possible to create a "Button" able to reset a certain Field or
Fields?

if so ...I would aprecciate some help.

ty

 

[JP]

What kind of field do you mean? Like a textbox on a userform? Or a
range of cells? Something else?


--JP

 

[portugueselink]

What kind of field do you mean? Like a textbox on a userform? Or a
range of cells? Something else?

--JP





- Mostrar texto citado -

Errm . i am quiet new to Excel,

I mentioned above FIELD - when it is really a CELL .

thank you

 

[JP]

Click View>Toolbars and select the Control Toolbox, then click the
"Command Button" control and, using your mouse, draw the button on
your worksheet. Then double click the button, press Ctrl-A, press
Delete, then insert this code:

Private Sub CommandButton1_Click()
Range("A1").Clear
End Sub

You can change the range above to suit your needs.

Now press Alt-Q to return to Excel. On the Control Toolbox toolbar,
click "Design Mode". Now you can click on your button and anything in
cell A1 will be deleted.

HTH,
JP

 

[portugueselink]

Click View>Toolbars and select the Control Toolbox, then click the
"Command Button" control and, using your mouse, draw the button on
your worksheet. Then double click the button, press Ctrl-A, press
Delete, then insert this code:

Private Sub CommandButton1_Click()
Range("A1").Clear
End Sub

You can change the range above to suit your needs.

Now press Alt-Q to return to Excel. On the Control Toolbox toolbar,
click "Design Mode". Now you can click on your button and anything in
cell A1 will be deleted.

HTH,
JP







- Mostrar texto citado -

Thank you for the Fast reply...

Ermmm...this Clear Function .. Wipe out all CELL formats, Backgrounds,
anotations , tips ...
But its works Thank you -- just need to re-arrange all .
Thank You so much

 

[T. Valko]

If you want to retain formats and the such change clear to clearcontents:

Private Sub CommandButton1_Click()
Range("A1").ClearContents
End Sub


--
Biff
Microsoft Excel MVP

Click View>Toolbars and select the Control Toolbox, then click the
"Command Button" control and, using your mouse, draw the button on
your worksheet. Then double click the button, press Ctrl-A, press
Delete, then insert this code:

Private Sub CommandButton1_Click()
Range("A1").Clear
End Sub

You can change the range above to suit your needs.

Now press Alt-Q to return to Excel. On the Control Toolbox toolbar,
click "Design Mode". Now you can click on your button and anything in
cell A1 will be deleted.

HTH,
JP







- Mostrar texto citado -

Thank you for the Fast reply...

Ermmm...this Clear Function .. Wipe out all CELL formats, Backgrounds,
anotations , tips ...
But its works Thank you -- just need to re-arrange all .
Thank You so much