Adding a Clear Field Button to an excel file?

[Legacy 50109]

Not too familiar with visual basics, and I believe its possible.

I have an excel file that will be used on a constant basis for some basic calculations.

Does anyone know how to add a "Clear Field" button to an excel file?

It would be about 2-3 fields that would require constant data entry and needs to be cleared each time, with the click of a button.

Thanks,

 

[Craig92604]

Sub clear()
Range("D43,D44,D45").Select
Range("D45").Activate
Selection.ClearContents
End Sub

 

[Legacy 50109]

I know I'm kind of new, but it didn't work?

Am I doing something wrong?

I changed the value to correspond with the cells I want cleared, but how to I create the "clear button".

Thanks,

 

[Nimrod]

Selects will lead to troubles ... here's the above macro cleaned up :wink:

Sub clearV2()
    Range("D43,D44,D45").ClearContents
End Sub

Once you've got the macro running you can create a ShortCut-Key to it by going to Tools..Macro..Macros... and clicking on the "Options" button.