VBA: Clear Contents of active cell with form control button

[bamaisgreat]

I am needing some code to Clear contents of what ever cell is selected at the time. I would like this to be where I select a cell then press a form control button to clear whatever cell is selected. Thanks as always....

 

[scott_n_phnx]

After you have created the button, you can add this into the Click event. Something like this

Private Sub CommandButton1_Click()
Selection.Clear
End Sub

 

[bamaisgreat]

ok thanks, Can it bee where it only deletes the value instead of my borders and formatting. Thanks

 

[Juglaz]

Private Sub CommandButton1_Click()
Selection.value = ""
End Sub

 

[bamaisgreat]

Thanks

 

[Juglaz]

Of course you could always just use the delete key instead XD