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:
1) How can I make it bring it up a userform when I click any cell and not A1?![]()
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
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