How to bring up blank form

[petro62]

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.

Sub AddNewTag()
'
' AddNewTag Macro
' Click button to get new tag entry form
'

'
    ActiveSheet.ShowDataForm
End Sub

 

[dmt32]

Hi,
quick search & found same question asked here:VBA - ShowDataForm and add new record
#Post 2 should do what you want

Dave

 

[petro62]

Hi,
quick search & found same question asked here:VBA - ShowDataForm and add new record
#Post 2 should do what you want

Dave

Yes that worked perfectly thanks

Sub AddNewTag()
'
' AddNewTag Macro
' Click button to get new tag entry form
'

'
    With Sheets("Tag Name")
        .Select
        Application.SendKeys ("%w")
        DoEvents
        Application.SendKeys ("%w")
        .ShowDataForm
    End With
    Sheets("Tag Name").Activate
End Sub

 

[dmt32]

You are welcome although credit really should go to author @Jaafar Tribak

Dave