Thanks to some amazing help on here I am updated my large asset management excel file. With some great macros that were posted on here I was able to accomplish a lot of what I needed including bring up a form for the user to fill in when they want to add a new asset. The issue I have is the form always start pre-filled with the first item on the list which would allow them to overwrite it. Is there a way to make that form start blank?
I guess all I need to know of the code to put in after the following to so it automatically selects the New button on the form which would bring up a blank form then.
I guess all I need to know of the code to put in after the following to so it automatically selects the New button on the form which would bring up a blank form then.
VBA Code:
Sub AddNewTag()
'
' AddNewTag Macro
' Click button to get new tag entry form
'
'
ActiveSheet.ShowDataForm
End Sub