Hi, i'm calling a userform that is being populated with data from another workbook. The code opens the sourcebook and keeps it in read-only modus until i close the userform which is fine. However it seems that this prevents me from setting my userform to vbmodeless! I tried false true app.enableevents but to no avail.. Below is the Initialize event of the form. Does anybody have any idea to fix this? Thank you very much!
![]()
Private Sub UserForm_Initialize() Dim ListItems As Variant, i As Integer Application.EnableEvents = False Application.ScreenUpdating = False With Me.ComboBox1 Application.ScreenUpdating = False Set SourceWB = Workbooks.Open("E:\Hangar\Sheet2.xlsm", _ False, True) ListItems = SourceWB.Worksheets("Parts").Range("A2:A10000") ListItems = Application.WorksheetFunction.Transpose(ListItems) For i = 1 To UBound(ListItems) .AddItem ListItems(i) Next i .ListIndex = 0 End With Application.EnableEvents = True Exit Sub End Sub
Bookmarks