Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
form
Hello,
I created a form that has some buttons. When pressed some code excecutes and creates an excel spreadsheet. However I cannot access/modify the sheet unless I close the form window. Is there any way to keep the from visible/accessible while working with the spreadsheet? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
form
The show method has one optional argument which specifies if the form is
modal or not. Set it to false... UserForm1.Show False -- HTH... Jim Thomlinson "David" wrote: Hello, I created a form that has some buttons. When pressed some code excecutes and creates an excel spreadsheet. However I cannot access/modify the sheet unless I close the form window. Is there any way to keep the from visible/accessible while working with the spreadsheet? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
form
Thanks for the reply,
Where do I insert this command? I inseted it in the main command button that runs my program and got an error. Thanks "Jim Thomlinson" wrote: The show method has one optional argument which specifies if the form is modal or not. Set it to false... UserForm1.Show False -- HTH... Jim Thomlinson "David" wrote: Hello, I created a form that has some buttons. When pressed some code excecutes and creates an excel spreadsheet. However I cannot access/modify the sheet unless I close the form window. Is there any way to keep the from visible/accessible while working with the spreadsheet? Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
form
How do you bring up your form? At some point you have to load the form. It is
at this point that you want to specify it as non-modal. Forms are either modal (have exclusive focus) or non-modal. The code that I posted makes the form non-modal so that you can select outside of the form. -- HTH... Jim Thomlinson "David" wrote: Thanks for the reply, Where do I insert this command? I inseted it in the main command button that runs my program and got an error. Thanks "Jim Thomlinson" wrote: The show method has one optional argument which specifies if the form is modal or not. Set it to false... UserForm1.Show False -- HTH... Jim Thomlinson "David" wrote: Hello, I created a form that has some buttons. When pressed some code excecutes and creates an excel spreadsheet. However I cannot access/modify the sheet unless I close the form window. Is there any way to keep the from visible/accessible while working with the spreadsheet? Thanks |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
form
I am new to VB so please bear with me,
I started Excel, Alt F11, created a form with command buttons. When I click "run" and select "run sub/userForm(F5), the form appears in run mode in the middle of excel spreadsheet. I click one of the command buttons in which I have all my code. After the code finishes excecution, the form is in the middle of spreadsheet 1(which is created by running code from the command button). I can move the from but I cannot do anything in excel unless I click (X button) to close the form. I first inserted you code "UserForm1.Show False" in the command button code then I inseted it in "UserForm_Click()" I got errors both times. Thanks "Jim Thomlinson" wrote: How do you bring up your form? At some point you have to load the form. It is at this point that you want to specify it as non-modal. Forms are either modal (have exclusive focus) or non-modal. The code that I posted makes the form non-modal so that you can select outside of the form. -- HTH... Jim Thomlinson "David" wrote: Thanks for the reply, Where do I insert this command? I inseted it in the main command button that runs my program and got an error. Thanks "Jim Thomlinson" wrote: The show method has one optional argument which specifies if the form is modal or not. Set it to false... UserForm1.Show False -- HTH... Jim Thomlinson "David" wrote: Hello, I created a form that has some buttons. When pressed some code excecutes and creates an excel spreadsheet. However I cannot access/modify the sheet unless I close the form window. Is there any way to keep the from visible/accessible while working with the spreadsheet? Thanks |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
form
Now I see what you are up to. The form that you created has a modal property.
In the VBE click on View - Properties to bring up the properties window if it is not already displayed. Select the form and Scroll down the list to a property called ShowModal. Change it from True to False. Now run the form... -- HTH... Jim Thomlinson "David" wrote: I am new to VB so please bear with me, I started Excel, Alt F11, created a form with command buttons. When I click "run" and select "run sub/userForm(F5), the form appears in run mode in the middle of excel spreadsheet. I click one of the command buttons in which I have all my code. After the code finishes excecution, the form is in the middle of spreadsheet 1(which is created by running code from the command button). I can move the from but I cannot do anything in excel unless I click (X button) to close the form. I first inserted you code "UserForm1.Show False" in the command button code then I inseted it in "UserForm_Click()" I got errors both times. Thanks "Jim Thomlinson" wrote: How do you bring up your form? At some point you have to load the form. It is at this point that you want to specify it as non-modal. Forms are either modal (have exclusive focus) or non-modal. The code that I posted makes the form non-modal so that you can select outside of the form. -- HTH... Jim Thomlinson "David" wrote: Thanks for the reply, Where do I insert this command? I inseted it in the main command button that runs my program and got an error. Thanks "Jim Thomlinson" wrote: The show method has one optional argument which specifies if the form is modal or not. Set it to false... UserForm1.Show False -- HTH... Jim Thomlinson "David" wrote: Hello, I created a form that has some buttons. When pressed some code excecutes and creates an excel spreadsheet. However I cannot access/modify the sheet unless I close the form window. Is there any way to keep the from visible/accessible while working with the spreadsheet? Thanks |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
form
Great, It worked. Thanks man.
"Jim Thomlinson" wrote: Now I see what you are up to. The form that you created has a modal property. In the VBE click on View - Properties to bring up the properties window if it is not already displayed. Select the form and Scroll down the list to a property called ShowModal. Change it from True to False. Now run the form... -- HTH... Jim Thomlinson "David" wrote: I am new to VB so please bear with me, I started Excel, Alt F11, created a form with command buttons. When I click "run" and select "run sub/userForm(F5), the form appears in run mode in the middle of excel spreadsheet. I click one of the command buttons in which I have all my code. After the code finishes excecution, the form is in the middle of spreadsheet 1(which is created by running code from the command button). I can move the from but I cannot do anything in excel unless I click (X button) to close the form. I first inserted you code "UserForm1.Show False" in the command button code then I inseted it in "UserForm_Click()" I got errors both times. Thanks "Jim Thomlinson" wrote: How do you bring up your form? At some point you have to load the form. It is at this point that you want to specify it as non-modal. Forms are either modal (have exclusive focus) or non-modal. The code that I posted makes the form non-modal so that you can select outside of the form. -- HTH... Jim Thomlinson "David" wrote: Thanks for the reply, Where do I insert this command? I inseted it in the main command button that runs my program and got an error. Thanks "Jim Thomlinson" wrote: The show method has one optional argument which specifies if the form is modal or not. Set it to false... UserForm1.Show False -- HTH... Jim Thomlinson "David" wrote: Hello, I created a form that has some buttons. When pressed some code excecutes and creates an excel spreadsheet. However I cannot access/modify the sheet unless I close the form window. Is there any way to keep the from visible/accessible while working with the spreadsheet? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Strange issue freezing parent form when unloading a child form | Excel Programming | |||
Transfer data to form from Excel range upon loading of form. | Excel Programming | |||
how can I make a form number change everytime the form is opened | Excel Worksheet Functions | |||
form in excel to be attached to the emails address in the form upon sumission | Excel Programming | |||
Is it possible to open the VBA form with a link in a sheet and to pass variable from a cell to the VBA form? | Excel Programming |