Excel . Reset Button - ??

  • Thread starter Thread starter portugueselink
  • Start date Start date
P

portugueselink

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

if so ...I would aprecciate some help.

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


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

--JP





- Mostrar texto citado -
Click to expand...

Errm . i am quiet new to Excel,

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

thank you
 
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
 
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 -
Click to expand...

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
 
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 -
Click to expand...

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
 
Back
Top