I'm a novice at VBA. I want an add-in data form to display when the workbook
is opened. I have the following code, but nothing happens when the workbook
is opened. I still have to manually select Data from the menu followed by
selecting the add-in form from the drop down list to display the form on
screen. Can someone help me with this.

Sub Workbook_Open()
Application.Run "dataform2.xla!ShowDataForm"
End Sub


TIA

Where are you putting the code? It should be in the ThisWorkbook
code module, not a regular code module.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Jan" wrote in message
...
I'm a novice at VBA. I want an add-in data form to display
when the workbook
is opened. I have the following code, but nothing happens when
the workbook
is opened. I still have to manually select Data from the menu
followed by
selecting the add-in form from the drop down list to display
the form on
screen. Can someone help me with this.

Sub Workbook_Open()
Application.Run "dataform2.xla!ShowDataForm"
End Sub


TIA

This Worked for me in Excel 2000

Dim x

x = Application.Run("personal.xls!bottomrow")

seems like it needs to start with
variable =
--
steveB

Remove "AYN" from email to respond
"Jan" wrote in message
...
I'm a novice at VBA. I want an add-in data form to display when the
workbook
is opened. I have the following code, but nothing happens when the
workbook
is opened. I still have to manually select Data from the menu followed by
selecting the add-in form from the drop down list to display the form on
screen. Can someone help me with this.

Sub Workbook_Open()
Application.Run "dataform2.xla!ShowDataForm"
End Sub


TIA

No, only if you want to retrieve the result, as in a function, do you need
that.

"STEVE BELL" wrote in message
news:y2Ere.3855$yw4.737@trnddc09...
This Worked for me in Excel 2000

Dim x

x = Application.Run("personal.xls!bottomrow")

seems like it needs to start with
variable =
--
steveB

Remove "AYN" from email to respond
"Jan" wrote in message
...
I'm a novice at VBA. I want an add-in data form to display when the
workbook
is opened. I have the following code, but nothing happens when the
workbook
is opened. I still have to manually select Data from the menu followed
by
selecting the add-in form from the drop down list to display the form on
screen. Can someone help me with this.

Sub Workbook_Open()
Application.Run "dataform2.xla!ShowDataForm"
End Sub


TIA

Sorry Bob!

my bad...

--
steveB

Remove "AYN" from email to respond
"Bob Phillips" wrote in message
...
No, only if you want to retrieve the result, as in a function, do you need
that.

"STEVE BELL" wrote in message
news:y2Ere.3855$yw4.737@trnddc09...
This Worked for me in Excel 2000

Dim x

x = Application.Run("personal.xls!bottomrow")

seems like it needs to start with
variable =
--
steveB

Remove "AYN" from email to respond
"Jan" wrote in message
...
I'm a novice at VBA. I want an add-in data form to display when the
workbook
is opened. I have the following code, but nothing happens when the
workbook
is opened. I still have to manually select Data from the menu followed
by
selecting the add-in form from the drop down list to display the form
on
screen. Can someone help me with this.

Sub Workbook_Open()
Application.Run "dataform2.xla!ShowDataForm"
End Sub


TIA