My project utilizes a VBA ComboBox that is used to open another workbook (choice of Workbooks). It is using a VLookUp to get the workbook location. The code works as intended but after the selected workbook opens, I'm not able to enter any data in the newly opened workbook. If I go back to the workbook with the combobox and close the combobox, I am able to enter data in the newly opened workbook. The combobox appears to remain active and not allow me to do anything until it is closed manually.
How do I halt the combobox?
Below is my code:
Private Sub CommandButton_Click()
Dim w As String
Dim s As String
w = cboProperty.Text
Set myrange = Range("a1:b8")
s = Application.WorksheetFunction.VLookup(w, myrange, 2, False)
Workbooks.Open s
End Sub.
How do I halt the combobox?
Below is my code:
Private Sub CommandButton_Click()
Dim w As String
Dim s As String
w = cboProperty.Text
Set myrange = Range("a1:b8")
s = Application.WorksheetFunction.VLookup(w, myrange, 2, False)
Workbooks.Open s
End Sub.