The first time the button is clicked, the user form shows. I have a listbox come up and they click the item they want, then click the OK button, which goes through the list box and returns the selected value to the current worksheet.
Private Sub cmdOK_Click() On Error GoTo ErrHandler Dim lngItem As Long Dim I As Long Dim msg As String If ListBox1.ListIndex <> -1 Then For I = 0 To ListBox1.ColumnCount - 1 msg = msg & ListBox1.Column(I) & vbCrLf Next I End If For lngItem = 0 To ListBox1.ListCount - 1 If ListBox1.Selected(lngItem) Then With Sheets("Sheet1") '< qualify sheet here .Range("B2").Value = ListBox1.List(lngItem, 0) End With End If Next lngItem Unload MeExitHandler: Unload Me Exit SubErrHandler: MsgBox "Error: " & Err.Number & " " & Err.Description & " :ListBox1_DblClick" GoTo ExitHandler ResumeEnd Sub
I am then back at Sheet1 and see my value in cell B2. Then the problem occurs. I click on the button to show the form again and I get the Microsoft Visual Basic Error dialog box with the error:
Code execution has been interruped
If I click continue, everything is fine.
Why am I getting this?
How do I prevent this from happening?
Microsoft ExcelVisual Basic ClassicMicrosoft Applications
Last Comment
[ fanpages ]
8/22/2022 - Mon
Roy Cox
I can't see anything in the code, can you attach the workbook.
Saurabh Singh Teotia
Did you try re-booting your system?? That should take care of the same...
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
Press "Debug" button in the popup.
Press Ctrl+Pause|Break twice.
Hit the play button to continue. Save the file after completion.
[ fanpages ]
Thanks for taking the time to post that approach, jeffreywsmith.
I have had mixed results with that in the past, & often found the issue reoccurs; most often within the intended run-time environment when a user cannot use the "Debug" option (due to the VB[A]Project environment being password protected).
Useful to bypass the issue for the short term, though.