Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
stringed userforms won't hide
I have about 15 userforms stringed together. On these userforms are various
combo boxes, text boxes, options buttons, text boxes etc. Each has a "continue" button and a "back" button. If the "continue" button is clicked, then the values from all the boxes and buttons are transferred to a sheet. The last 3 lines of code a application. screenupdating = true userform"next".show userform"current".hide When the next userform activates, the last line of vba in the activate procedure is: application.screenupdating= false. The back button has similar code as well. Again, these userforms are all stringed together. About half way through, the userforms stop hiding. I have pulled my hair out but can't resolve this????? -- Thanks Shawn |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
stringed userforms won't hide
Try the hide before the show.
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Shawn" wrote in message ... I have about 15 userforms stringed together. On these userforms are various combo boxes, text boxes, options buttons, text boxes etc. Each has a "continue" button and a "back" button. If the "continue" button is clicked, then the values from all the boxes and buttons are transferred to a sheet. The last 3 lines of code a application. screenupdating = true userform"next".show userform"current".hide When the next userform activates, the last line of vba in the activate procedure is: application.screenupdating= false. The back button has similar code as well. Again, these userforms are all stringed together. About half way through, the userforms stop hiding. I have pulled my hair out but can't resolve this????? -- Thanks Shawn |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
stringed userforms won't hide
I have tried that as well as "unload" instead of hide.
-- Thanks Shawn "Bob Phillips" wrote: Try the hide before the show. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Shawn" wrote in message ... I have about 15 userforms stringed together. On these userforms are various combo boxes, text boxes, options buttons, text boxes etc. Each has a "continue" button and a "back" button. If the "continue" button is clicked, then the values from all the boxes and buttons are transferred to a sheet. The last 3 lines of code a application. screenupdating = true userform"next".show userform"current".hide When the next userform activates, the last line of vba in the activate procedure is: application.screenupdating= false. The back button has similar code as well. Again, these userforms are all stringed together. About half way through, the userforms stop hiding. I have pulled my hair out but can't resolve this????? -- Thanks Shawn |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
stringed userforms won't hide
Are you using Me.Show and Me.Hide? Are you opening modal or modeless?
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Shawn" wrote in message ... I have tried that as well as "unload" instead of hide. -- Thanks Shawn "Bob Phillips" wrote: Try the hide before the show. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Shawn" wrote in message ... I have about 15 userforms stringed together. On these userforms are various combo boxes, text boxes, options buttons, text boxes etc. Each has a "continue" button and a "back" button. If the "continue" button is clicked, then the values from all the boxes and buttons are transferred to a sheet. The last 3 lines of code a application. screenupdating = true userform"next".show userform"current".hide When the next userform activates, the last line of vba in the activate procedure is: application.screenupdating= false. The back button has similar code as well. Again, these userforms are all stringed together. About half way through, the userforms stop hiding. I have pulled my hair out but can't resolve this????? -- Thanks Shawn |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
stringed userforms won't hide
I am not using Me.Show or Me.Hide.
I don't know the difference between modal and modeless. -- Thanks Shawn "Bob Phillips" wrote: Are you using Me.Show and Me.Hide? Are you opening modal or modeless? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Shawn" wrote in message ... I have tried that as well as "unload" instead of hide. -- Thanks Shawn "Bob Phillips" wrote: Try the hide before the show. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Shawn" wrote in message ... I have about 15 userforms stringed together. On these userforms are various combo boxes, text boxes, options buttons, text boxes etc. Each has a "continue" button and a "back" button. If the "continue" button is clicked, then the values from all the boxes and buttons are transferred to a sheet. The last 3 lines of code a application. screenupdating = true userform"next".show userform"current".hide When the next userform activates, the last line of vba in the activate procedure is: application.screenupdating= false. The back button has similar code as well. Again, these userforms are all stringed together. About half way through, the userforms stop hiding. I have pulled my hair out but can't resolve this????? -- Thanks Shawn |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
stringed userforms won't hide
I found my problem and resolved it, though I don't understand what the real
problem was. All the sheets in my file are hidden save one. In the activate procedure of userform 5 there was a line of code that "sheet.active" a hidden sheet. I didn't need that line of code, so when I removed it, the issue went away. -- Thanks Shawn "Bob Phillips" wrote: Are you using Me.Show and Me.Hide? Are you opening modal or modeless? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Shawn" wrote in message ... I have tried that as well as "unload" instead of hide. -- Thanks Shawn "Bob Phillips" wrote: Try the hide before the show. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Shawn" wrote in message ... I have about 15 userforms stringed together. On these userforms are various combo boxes, text boxes, options buttons, text boxes etc. Each has a "continue" button and a "back" button. If the "continue" button is clicked, then the values from all the boxes and buttons are transferred to a sheet. The last 3 lines of code a application. screenupdating = true userform"next".show userform"current".hide When the next userform activates, the last line of vba in the activate procedure is: application.screenupdating= false. The back button has similar code as well. Again, these userforms are all stringed together. About half way through, the userforms stop hiding. I have pulled my hair out but can't resolve this????? -- Thanks Shawn |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
stringed userforms won't hide
15 userforms is an awful lot! could you consolidate them into, say,
3, using multipages? would be easier to figure out where problems are. just a design comment. :) susan On Jun 15, 7:10 am, Shawn wrote: I am not using Me.Show or Me.Hide. I don't know the difference between modal and modeless. -- Thanks Shawn "Bob Phillips" wrote: Are you using Me.Show and Me.Hide? Are you opening modal or modeless? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Shawn" wrote in message ... I have tried that as well as "unload" instead of hide. -- Thanks Shawn "Bob Phillips" wrote: Try the hide before the show. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Shawn" wrote in message ... I have about 15 userforms stringed together. On these userforms are various combo boxes, text boxes, options buttons, text boxes etc. Each has a "continue" button and a "back" button. If the "continue" button is clicked, then the values from all the boxes and buttons are transferred to a sheet. The last 3 lines of code a application. screenupdating = true userform"next".show userform"current".hide When the next userform activates, the last line of vba in the activate procedure is: application.screenupdating= false. The back button has similar code as well. Again, these userforms are all stringed together. About half way through, the userforms stop hiding. I have pulled my hair out but can't resolve this????? -- Thanks Shawn- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want to Hide columns in spreadsheet but NOT hide data in chart. | Charts and Charting in Excel | |||
Specify which rows to NOT hide, and have excel hide the rest | Excel Programming | |||
Esc out of userforms | Excel Programming | |||
How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) | |||
Userforms | Excel Programming |