Hi, I'm new to userforms hence all the questions! I have a userform which pops up when a cell is selected, it then enters the data into the cell selected. I thought I could just copy the userform and modify slightly for the other 200 cells in the column. Doh!
I think a better solution would be to use just one form and pass a variable to it, letting it know which cell to enter the details into.
The code I have for activating the userform is this...
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
If Target.Address = "$E$4" Then Ex1.Show
End Sub
Thanks Audiojoe!
But I need to send that cell to the userform.
Any ideas? Thanks in advance for any help.
I think a better solution would be to use just one form and pass a variable to it, letting it know which cell to enter the details into.
The code I have for activating the userform is this...
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
If Target.Address = "$E$4" Then Ex1.Show
End Sub
Thanks Audiojoe!
But I need to send that cell to the userform.
Any ideas? Thanks in advance for any help.