Form Hiding on own, weird Problem

[Kavy]

Hello, Weird Question
I am useing a user Form

On the Form which I call my main menu, theres a help button, with this code

Private Sub cmdHelp_Click()
MsgBox ("Help file not ready yet, good luck on your own, Have a Nice Day!")
End Sub

For some reason when this is click, and after the user clicks ok on the msgbox, the frmmain, which this command is on, minimizes itself

Anyone know why?

 

[NateO]

Hello, eh.

I can't replicate this in Excel XP simply by calling a MsgBox from a Button-click Event.

Do you possibly have Form Activate or Deactivate Event that could be causing this?

 

[Kavy]

no i don't which is whats confusing me, eh, it weird... makes no sense

But Now i can't replicate the event either, So i guess dead end.... kinda scary though

Anyway thanks for your response!

 

[NateO]

You know what I can replicate?

If you hit the Stop button in the VBE, for some reason, with the Form open, that would kill the form. In this instance you terminated the Form from memory... I wonder if you something along these lines...

 

[Kavy]

hmm i don't know, it seems to happen everytime when i click the command, or none of the times, like when my frmmain loads, either it will happen or it won't, its really weird.
But it doesn't stop, if you hit alt-tab after it happens it goes back to the form and u can hit commands and contine on ur way!
I am lost

 

[Kavy]

I take that back, this last time it only happened till i clicked another command and then it didn't happen anymore. It seems to be almost patternless

 

[NateO]

Hello again,

How do you show/load the Form? Hopefully with both, e.g.,

Sub foo()
Load UserForm1: UserForm1.Show
End Sub

I usually use both, just to be sure... Same deal when I get rid of them.

 

[Kavy]

i only use userform1.show is that a mistake?

 

[NateO]

Try using both.

 

[Kavy]

Sorry late reply, but thanks!