Macro to Reset data input form
Write the start of your macro first on a module sheet. You can write the
whole thing or start with one line and add additional lines later.
Sub Resetform()
Range("A1").ClearContents
......
(add cells as needed)
End Sub
Using ClearContents will leave formatting and validations intact
Make the reset box a Form Control command button and link it to this macro.
--
If this helps, please remember to click yes.
"MichaelRobert" wrote:
I have a worksheet set up as a data entry page to allow customers to select
features in a product. This data then generates a part number to capture that
particular set of features.
However, this leaves me with the Data Input form populated with the last
customer's selections. How can I write my macro to Reset the form to the
'blank' starting position? I envision having a 'Reset' box in the worksheet
to cue the Macro.
Thanks.
Mike
|