| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 !! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a template form, advance a form number everytime you open | Excel Discussion (Misc queries) | |||
| Open Specific Form by User Login | Excel Discussion (Misc queries) | |||
| Open a user form | Excel Discussion (Misc queries) | |||
| How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
| use a button to open a user form? | Excel Discussion (Misc queries) | |||
Hybrid Mode
