Use address of cell found with index/match as range location

Hello,

I'm having trouble using a cell address found with index match as my range. Here is what I'm currently doing:

Please Login or Register  to view this content.

Right now I'm just dumping that into a user form text box to make sure it's returning what I want, and it is. Now I'd like the user to be able to change the text in that box and overwrite the cell I just pulled that info from. I have it working on the option button click to populate say range("A1") but for the life of me I can't figure out how to get it to populate the range returned by the index match. What am I doing wrong?

Thanks in advance!

Two comments and some input:

First comment: have a look near the top of the page on a yellow banner. If you'd attach file, one would know where the new content is taken from.

A merit input: If your solution works returning proper address of the cell then such approach:

Please Login or Register  to view this content.

shall do the job.

and second comment: Note that the code above is embedded between CODE tags - please edit your post to comply with one of the forum rules. See:

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. As you are new here, I have done it for you today.)