add the DataForm to a Form Control Button

Question

I am trying what I thought would be a simple button add to an excel 365 worksheet. I need to add the DataForm to a button so users will have an easy location to click and add data.

The code I am using is this:

Sub open_form()
'
' open_form Macro
Range("e5").Select (the first cell in the table of data)
ActiveSheet.ShowDataForm
End Sub

But I am getting Run-time error '1004'
ShowDataForm method of Worksheet class failed.

All the examples i am seeing on line state this should work..
What am i doing wrong??

Thanks in advance...

Answer 1

Re: starting the Data Form

1. Just in case: A Mac doesn't have this feature.
2. Name your data "Database"

NLtL
https://1drv.ms/u/s!Au8Lyt79SOuhZ_zj8wEtOjDcqAI?e=MrzfpA
Calculate Payments, Custom_Functions, Professional_Compare, Add_Table of Contents