Bring up userform when doubleclicking on activated cell, then populate array from inputs

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:

Please Login or Register  to view this content.

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

You can determine what range you want the double click to work on.
This example will only work in a specified range....

Please Login or Register  to view this content.