ExcelBanter - Command Button

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Command Button (https://www.excelbanter.com/excel-programming/391256-command-button.html)

Fraelorn

Command Button

Could anyone suggest a simple layout of code required to setup a Command
Button that will clear a range of fields?

Thanks in advance.

FSt1

Command Button

sub commandbutton1_click()
Range("A1:F50").ClearContents
end sub
edit to your data.

Regards
FSt1

"Fraelorn" wrote:

Could anyone suggest a simple layout of code required to setup a Command
Button that will clear a range of fields?

Thanks in advance.

All times are GMT +1. The time now is 03:11 PM.