How to display active cell contents in text box

Hi all--

I've been trying to teach myself vba just so I can make this enormous database easier to read. Basically, I want a textbox that will show the contents of whatever the active cell is. Ideally, I click on a cell and the contents show up in textbox1, and when I click another cell, the textbox clears and shows the newly selected cell.

Sorry if this is a request that's been addressed already. My search turned up a ton of irrelevant results.

I'm using Excel 2013.

Thanks in advance

Wow, this is perfect! Thanks so much. I signed up here a long time ago just to lurk, so I never really entered any user info.

Now that this is working so well (thanks again to mehmetcik !), I wonder if it's possible to take the text that appears in that textbox that was created above, make changes to the text, and have the changes save to the cell. The idea is that I'm comparing two columns of text and will want to keep one or the other, but sometimes I need to make a change before I keep it.

Here is a version of what was provided to me that I made a few changes to

Please Login or Register  to view this content.

Apologies for non-standard formatting. Still trying to figure that out.

Then on the user form, I have buttons that will accept one or the other column of text before moving to the next column or row.

Am I making any sense?

Nice, that last bit of code did it, although I changed the cell reference—I probably wasn't clear about what I was trying to do. So much to know!

Please Login or Register  to view this content.

You're right, I did want to show two columns of text, but only if one of those two columns is selected. But now the whole thing works like a charm. Thanks again for your help.