On my worksheet the userform displays if the user clicks on any cell in the range E3:E56. I would like combobox1 to auto populate on the userform depending on which cell in the range was selected. For example: If the user selected cell E45, the userform displays and combobox1 will auto populate with the value found in cell B45. Is this even possible? Below is the short bit of code I already have that opens the userform if a cell in the range E3:E56 is selected.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Application.Intersect(Target, Range("E3:E56")) Is Nothing Then
UserForm1.Show
End If
End Sub
Bookmarks