Hi all -
I have a userform set up with two text boxes and I'd like to be able to double click on any cell, bring up the userform, input two values into the fields, and then have those two values write into that cell as an array string. ={value1, value2}. value 1 is an integer, value 2 is text
I started with:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target(1, 1).Address = "$A$1" Then
Cancel = True
userform1.Show
End If
End Sub
1) How can I make it bring it up a userform when I click any cell and not A1?
I'm lost on the second option. I've looked at the various dimArray options on the forums but didn't find anything specific to both of these combined. Let me know if you have any ideas
Bookmarks