Make userform open at specific cell

[lockarde]

Good morning all,

I have a macro that runs when a user double-clicks a cell. Among other things, this macro opens a userform. Is there a way to make the user form open to the right of the double-clicked cell every time? The location of this cell moves down the sheet as the user activates the macro (macro inserts 4 rows below, so for example: First double click, the cell is A6, rows are inserted, and next double click location would be A10, and so on. I thought I might be able to tie the userform location to Selection, but that doesn't seem to be supported?

 

[Sharid]

Have a look here, I'm not 100% sure, is this what you are after Link or this link2

 

[lockarde]

Have a look here, I'm not 100% sure, is this what you are after Link or this link2

Thanks for your response! I'll take a look at those links and see what I can find!

 

[lockarde]

In case anyone else has this question - I was able to get the behavior I wanted with the post found here on SO. I had to adjust the userform left justification slightly, but it works great! Thanks @Sharid for posting the link