Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How keep user form constant
Hi I recently posted a question about a user form and got it working
and figured out how to get it into excel...however, the only problem is it only runs as soon as excel starts up and then waits for the user to exit out of the box. Also, while it is up, it restricts the spread sheet from being edited. Is there a way I could have the box always be there and be able to simultaneously edit the spreadsheet? Sorry if it is a bit unclear. thank you! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How keep user form constant
On Apr 17, 7:51 pm, wrote:
Hi I recently posted a question about a user form and got it working and figured out how to get it into excel...however, the only problem is it only runs as soon as excel starts up and then waits for the user to exit out of the box. Also, while it is up, it restricts the spread sheet from being edited. Is there a way I could have the box always be there and be able to simultaneously edit the spreadsheet? Sorry if it is a bit unclear. thank you! You should be able to make the form Modeless and it will "float" in the foreground until you unload or hide the form. It will allow you to interact with Excel while the form is open. Sub CommandButton1_Click() frmExample.Show vbModeless End Sub Matt |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How keep user form constant
the userform seems to be in modal.
you can get the userform show modal or modeless. how about using "userform.show vbModeless" when you write userform.show without vbModeless, it shows in modal(vbModal is defalut) msn --------------------------------------------- the best time to plant a tree was twenty years ago. the second best time, is today - Chinese proverb " wrote: Hi I recently posted a question about a user form and got it working and figured out how to get it into excel...however, the only problem is it only runs as soon as excel starts up and then waits for the user to exit out of the box. Also, while it is up, it restricts the spread sheet from being edited. Is there a way I could have the box always be there and be able to simultaneously edit the spreadsheet? Sorry if it is a bit unclear. thank you! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How keep user form constant
On Apr 17, 9:51 pm, wrote:
Hi I recently posted a question about a user form and got it working and figured out how to get it into excel...however, the only problem is it only runs as soon as excel starts up and then waits for the user to exit out of the box. Also, while it is up, it restricts the spread sheet from being edited. Is there a way I could have the box always be there and be able to simultaneously edit the spreadsheet? Sorry if it is a bit unclear. thank you! Thank you for your response! I have one more question...is there a way I could either make the box stay on just one worksheet (say one called rev and exp) rather than having it stay open while looking at other worksheets? Or could I directly embed it into a worksheet? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How keep user form constant
Hi Alex -
One way would be to hide the form when the worksheet of interest is deactivated and show the form when it is activated. Here's some code to do that. 1. Procedure to load the form (copy to standard module): Sub alex() If ActiveSheet.Name = "YourWorksheetNameHere" Then frmAlex.Show vbModeless Else Load frmYourForm End If End Sub 2. Procedures to automatically show or hide the form (copy to the worksheet module): Private Sub Worksheet_Activate() frmYourForm.Show vbModeless End Sub Private Sub Worksheet_Deactivate() frmYourForm.Hide End Sub --- Jay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically add a textbox to a user form based on user requireme | Excel Programming | |||
User form ComboBox Items: Remember user entries? | Excel Programming | |||
get some user info and store as constant | Excel Programming | |||
How to: User Form to assign a user defined range to a macro variab | Excel Programming |