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
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 |
#4
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 |
#5
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 !! |
#6
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? |
#7
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 |
#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
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 |
#11
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? |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
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) |