Button to open entry form

[Stan5582]

Excel has a built in data entry form window which is opened from the ribbon, how can I create a button which opens this form for a specific table on the worksheet. It should allow the user to create or edit entries in the table. I tried creating a macro to select the data range and open the form, but this returns an error.

[6StringJazzer]

When asking for help on errors you get on your code, PLEASE show your code and the text of the error message.

Write code to select the table you want. Then

Please Login or Register  to view this content.

Change Sheet1 to your actual Sheet codename.

If this sounds like what you already did, attach your file, or at least show all of your code.

[Stan5582]

to be honest, I don't know any code and was just trying to create a macro by selecting the table manually and clicking the ribbon button. What code would I need to select the table?

[6StringJazzer]

Can you attach your file? Need to see where the table is, etc.