View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default 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 -