Message Box twice pop-up between user frames...

[keromero]

I have three (3) different frames in same user form. I can successfully run below message box within the same frame.

However If I skip to other frames and click a text box, then message box appears twice?


*************************
Private Sub TextBox1_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)

If Len(TextBox1) > 0 And IsNumeric(TextBox1) And TextBox1.Value > 0 Then
ComboBox6.Clear
Me.ComboBox6.Enabled = True
ComboBox6.AddItem "Option01"
ComboBox6.AddItem "Option02"
ComboBox6.AddItem "Option03"

Else

MsgBox "Enter a numeric value or a value greater than zero...", vbInformation, "MyBrand"
Cancel = True
TextBox1.Text = ""
Me.ComboBox6.Enabled = False

End If

End Sub
*************************

Note: ComboBox6 will be conditionally available when text box providing correct entry.

Thanks for help

 

[Micron]

Put a break point on the first line, then do whatever you do that triggers this, then step through the code (F8) and follow the execution. I suspect that setting the control to "" is causing the event to run again. On the 2nd pass it's length will be 0. I'd remove the Len test because you don't need it. If the value is numeric and is greater than 0 then it stands to reason that it's length is >0 also.

 

[keromero]

Hİ Micron, code is working very fine as long as the code is running in the "same frame" loop. The issue when we switch from one frame to other in user form.

So I feel, what causes this "frame switching"

We better need to know whats behind "frame switching" cause twive message pop up.

Best Regards,