Pass data from active row to an Active TextBox

[john55]

Hi,

I try to send the data from the current row to an Active TextBox having a "specific" format.
Actually it's a sort of preview email body. If I am happy with the collected data, I just click and send the email without .display.
I tried with the UserForm or other ways, unsuccessful!
I attached a sample.

Could you help me, please?

Thank you.
Cheers

[TMS]

Something like:

Please Login or Register  to view this content.

[TMS]

You could just put it in a cell with an equals sign:

Please Login or Register  to view this content.

[john55]

Hello TMS!!!
Long time no see!
Thanks a lot for your support, I add into L10 and it doesn't "display" anything in my TextBox!
...the formula can be seen in cell L10 and nothing else!

Thank you.
Cheers

[TMS]

Hi John, that's just the formula to collate the components in the correct format. You'd need to adjust your code to copy the value in L10 (or the Active Cell) into your Text Box.

I'm just playing with this on an iPad at the moment and don't have access to a computer so I can't test putting it in the Text Box.

[john55]

Hi TMS,
I think I can have something...but the Date is causing me troubles, I mean it's not "copied" into TextBox, what is wrong, please?
If I click in column M, the data is copied into TextBox without the Date. The Date should be as 11NOV22, with caps!

Please Login or Register  to view this content.

Not sure how to do it.
Thank you

[TMS]

If you are going to loop through cells like this:

Please Login or Register  to view this content.

you should be referring to i in the code, not Target.Row