I have built a user form per Debras instructions @ contextures. It
works fine, but when I close and save and later re-open, how do I see
my form? Is there a way to make it automatically re-appear on
opening? Or did I lose it?

Put your Open_Form macro in Workbook_Open()

"wx4usa" wrote:

I have built a user form per Debras instructions @ contextures. It
works fine, but when I close and save and later re-open, how do I see
my form? Is there a way to make it automatically re-appear on
opening? Or did I lose it?

On Oct 22, 9:46*am, wx4usa wrote:
I have built a user form per Debras instructions @ contextures. It
works fine, but when I close and save and later re-open, how do I see
my form? *Is there a way to make it automatically re-appear on
opening? Or did I lose it?

By the way, I used a button with the following code. and it says
error 424 object required??

Sub Rectangle1_Click()
frmSalesEntry.Show
End Sub

You could use a macro.

This goes in a General module--not behind a worksheet and not behind
ThisWorkbook.

Option Explicit
Sub Auto_Open()
userform1.show
End Sub

Change userform1 to the real name of your userform.

wx4usa wrote:

I have built a user form per Debras instructions @ contextures. It
works fine, but when I close and save and later re-open, how do I see
my form? Is there a way to make it automatically re-appear on
opening? Or did I lose it?

--

Dave Peterson

On Oct 22, 10:22*am, Dave Peterson wrote:
You could use a macro.

This goes in a General module--not behind a worksheet and not behind
ThisWorkbook.

Option Explicit
Sub Auto_Open()
* *userform1.show
End Sub

Change userform1 to the real name of your userform.

wx4usa wrote:

I have built a user form per Debras instructions @ contextures. It
works fine, but when I close and save and later re-open, how do I see
my form? *Is there a way to make it automatically re-appear on
opening? Or did I lose it?

--

Dave Peterson

Thanks Dave and Sheeloo !!

On Oct 22, 10:27*am, wx4usa wrote:
On Oct 22, 10:22*am, Dave Peterson wrote:



You could use a macro.

This goes in a General module--not behind a worksheet and not behind
ThisWorkbook.

Option Explicit
Sub Auto_Open()
* *userform1.show
End Sub

Change userform1 to the real name of your userform.

wx4usa wrote:

I have built a user form per Debras instructions @ contextures. It
works fine, but when I close and save and later re-open, how do I see
my form? *Is there a way to make it automatically re-appear on
opening? Or did I lose it?

--

Dave Peterson

Thanks Dave and Sheeloo !!

Hi Dave,

I cannot get the form to open automatically when the workbook is
opened. It will work when I hit run sub with the VB editor window. Did
I put it in the wrong place?

I don't know.

Where did you put it?

Did you call it Auto_Open?

If you're new to macros:

Debra Dalgleish has some notes how to implement macros he
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

wx4usa wrote:
<<snipped

Hi Dave,

I cannot get the form to open automatically when the workbook is
opened. It will work when I hit run sub with the VB editor window. Did
I put it in the wrong place?

--

Dave Peterson

On Oct 22, 10:52*am, Dave Peterson wrote:
I don't know.

Where did you put it?

Did you call it Auto_Open?

If you're new to macros:

Debra Dalgleish has some notes how to implement macros hehttp://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

wx4usawrote:

<<snipped



Hi Dave,

I cannot get the form to open automatically when the workbook is
opened. It will work when I hit run sub with the VB editor window. Did
I put it in the wrong place?

--

Dave Peterson

Hi Dave

Thanks so much for your help.

I pasted the following...

Option Explicit
Sub Auto_Open()
SalesEntry.Show
End Sub

Under the This workbook tab. The top of the window says general and
auto_open

SalesEntry is the user form name.

I can manually run the macro, but not automatically.

It will not auto open when the workbook is opened. I have to click
enable content. Is there a security issue? Should it auto open after I
click enable content?

On Oct 22, 10:52*am, Dave Peterson wrote:
I don't know.

Where did you put it?

Did you call it Auto_Open?

If you're new to macros:

Debra Dalgleish has some notes how to implement macros hehttp://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

wx4usawrote:

<<snipped



Hi Dave,

I cannot get the form to open automatically when the workbook is
opened. It will work when I hit run sub with the VB editor window. Did
I put it in the wrong place?

--

Dave Peterson

Hi Dave

Thanks so much for your help.

I pasted the following...

Option Explicit
Sub Auto_Open()
SalesEntry.Show
End Sub

Under the This workbook tab. The top of the window says general and
auto_open

SalesEntry is the user form name.

I can manually run the macro, but not automatically.

It will not auto open when the workbook is opened. I have to click
enable content. Is there a security issue? Should it auto open after I
click enable content?

You have two choices.

Move the code to a general module (insert|Module).

Or rename the procedure (and leave it under the ThisWorkbook module).
Option Explicit
Sub Workbook_Open()
SalesEntry.Show
End Sub



wx4usa wrote:

Hi Dave

Thanks so much for your help.

I pasted the following...

Option Explicit
Sub Auto_Open()
SalesEntry.Show
End Sub

Under the This workbook tab. The top of the window says general and
auto_open

SalesEntry is the user form name.

I can manually run the macro, but not automatically.

It will not auto open when the workbook is opened. I have to click
enable content. Is there a security issue? Should it auto open after I
click enable content?

--

Dave Peterson

On Oct 22, 10:52*am, Dave Peterson wrote:
I don't know.

Where did you put it?

Did you call it Auto_Open?

If you're new to macros:

Debra Dalgleish has some notes how to implement macros hehttp://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

wx4usawrote:

<<snipped



Hi Dave,

I cannot get the form to open automatically when the workbook is
opened. It will work when I hit run sub with the VB editor window. Did
I put it in the wrong place?

--

Dave Peterson

Hi Dave

Thanks so much for your help.

I pasted the following...

Option Explicit
Sub Auto_Open()
SalesEntry.Show
End Sub

Under the This workbook tab. The top of the window says general and
auto_open

SalesEntry is the user form name.

I can manually run the macro, but not automatically.

It will not auto open when the workbook is opened. I have to click
enable content. Is there a security issue? Should it auto open after I
click enable content?

On Oct 23, 7:53*am, Dave Peterson wrote:
You have two choices.

Move the code to a general module (insert|Module).

Or rename the procedure (and leave it under the ThisWorkbook module).
Option Explicit
Sub Workbook_Open()
* SalesEntry.Show
End Sub



wx4usawrote:

Hi Dave

Thanks so much for your help.

I pasted the following...

Option Explicit
Sub Auto_Open()
SalesEntry.Show
End Sub

Under the This workbook tab. The top of the window says general and
auto_open

SalesEntry is the user form name.

I can manually run the macro, but not automatically.

It will not auto open when the workbook is opened. I have to click
enable content. Is there a security issue? Should it auto open after I
click enable content?

--

Dave Peterson

I am not sure what a general module is. What does that mean Dave?

Inside the VBE:
Insert|Module
will give you that general module

ps.

Those links to instructions that I posted in a previous message may be worth
reviewing.


wx4usa wrote:

<<snipped
I am not sure what a general module is. What does that mean Dave?

--

Dave Peterson

On Oct 23, 8:23*am, Dave Peterson wrote:
Inside the VBE:
Insert|Module
will give you that general module

ps.

Those links to instructions that I posted in a previous message may be worth
reviewing.



wx4usawrote:

<<snipped
I am not sure what a general module is. What does that mean Dave?

--

Dave Peterson

Thanks for your patience and help Dave!