Create a Macro Button to Launch the Form Dialog Box

Hi Rebecca,

Thank you for your question.

Do you mean in Excel?

Can you please tell me some more detail of what you are trying to achieve.

Regards

Simon

Hi Rebecca,

Further to my response, you would have to write small macro.

Here is the code:

Sub auto_open()
' Activate the sheet that contains your database.
Worksheets("Sheet1").Activate

' Show the data form for the selected range.
ActiveSheet.ShowDataForm
End Sub

Copy the code from Sub Auto_open up to and including End Sub in to the VB Editor window.

On your keyboard, use Alt + F11 which will open the code window. There should be a project explorer window on the left with all the sheet names. Double click on the sheet name you want the data form to appear on and paste the code in the right hand window.

Let me know how you get on.

Regards

Simon