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 -
|