LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 271
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Want to Hide columns in spreadsheet but NOT hide data in chart. KrispyData Charts and Charting in Excel 1 March 20th 09 04:45 PM
Specify which rows to NOT hide, and have excel hide the rest Mo2 Excel Programming 0 April 25th 07 03:44 AM
Esc out of userforms Mark \(InWales\)[_23_] Excel Programming 2 February 2nd 05 10:08 PM
How do I hide a worksheet in Excel and use a password to un-hide . Dchung Excel Discussion (Misc queries) 3 December 2nd 04 06:24 AM
Userforms nath Excel Programming 1 May 20th 04 04:53 PM


All times are GMT +1. The time now is 02:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"