Userform doesnt work suddenly

[jasonxlui]

The situation is that I have a userform namely "accounts". Within it, I have a button"A" to trigger another userform namely "account selection".
In the "account selection", I have the "accountok" button to trigger the following code. Previously, when I click the "accountok", I will only unload my second userform. But under the
situation I didnt change the code, some problems happen. When I am opening the Visual Basic Window, I click the "accountok" button, it will directly close my second and first userform at the same time(i.e
close all things). But if I close the Visual Basic Window, the code funtions properly. (Although I dont think it is related to my code below) Anyone can help? Please



Private Sub accountok_Click()

Dim var As String
var = ""

If Me.CheckBox1.Value = True Then
var = "BY"
End If



If accountform.selectclick = "selectclick1" Then
accountform.TextBox1 = var
ElseIf accountform.selectclick = "selectclick2" Then
accountform.TextBox2 = var
ElseIf accountform.selectclick = "selectclick3" Then
accountform.TextBox3 = var
ElseIf accountform.selectclick = "selectclick4" Then
accountform.TextBox4 = var
ElseIf accountform.selectclick = "selectclick5" Then
accountform.TextBox5 = var


End If
Unload accountselection

End Sub

 

[Peter_SSs]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Userform doesnt work suddenly
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[jasonxlui]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Userform doesnt work suddenly
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Thanks for reminder. Will follow the rule next time.

 

[Peter_SSs]

Cheers.