manmoncang
New Member
- Joined
- Dec 3, 2008
- Messages
- 32
Dear all,
i have problem when using vbModeless.
The STEP of my program is...
1. Click button A in userform1 then userform2 will show with vbModeless.
2. Terminate userform2 and back to userform1 with vbModal
3. Click button B in userform1 then userform 3 will show with vbModeless.
4. Terminate userform3 and back to userform1 with vbModal
The code
At Step 3, userform3 show for a second but terminate by itself. How to solve it. tq in advance
i have problem when using vbModeless.
The STEP of my program is...
1. Click button A in userform1 then userform2 will show with vbModeless.
2. Terminate userform2 and back to userform1 with vbModal
3. Click button B in userform1 then userform 3 will show with vbModeless.
4. Terminate userform3 and back to userform1 with vbModal
The code
THE PROBLEMAt userform1.
Private Sub CommandButton1_Click()
Unload Me
userform2.show vbModeless
End Sub
Private Sub CommandButton2_Click()
Unload Me
userform3.show vbModeless
End Sub
At userform2.
Private Sub UserForm_Terminate()
Unload Me
userform1.show vbModal
End Sub
At userform3.
Private Sub UserForm_Terminate()
Unload Me
userform1.show vbModal
End Sub
At Step 3, userform3 show for a second but terminate by itself. How to solve it. tq in advance