See User Form On Open
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? |
See User Form On Open
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? |
See User Form On Open
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 |
See User Form On Open
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 |
See User Form On Open
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 !! |
See User Form On Open
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? |
See User Form On Open
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 |
See User Form On Open
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? |
See User Form On Open
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? |
See User Form On Open
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 |
See User Form On Open
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? |
See User Form On Open
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? |
See User Form On Open
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 |
See User Form On Open
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! |
All times are GMT +1. The time now is 01:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com