copy text with formatting

[sandysharma]

Hi Friends,
Is there any way to extract the text from a cell to a userform textbox with formatting?
Thanks and Regards,
Sandeep

 

[YasserKhalil]

Hello
Try using something like that

TextBox1.Text=Range("A1").Text

 

[sandysharma]

nope...not working
extracting only value

 

[YasserKhalil]

Can you provide sample of your workbook?

 

[sandysharma]

this is the code that I am using:

Controls("textbox3").Text = vbNewLine & ThisWorkbook.Worksheets("sheet3").Cells(1, 1).Text

 

[Marc L]

Hi !

Is there any way to extract the text from a cell to a userform textbox with formatting?

As it depends on what you did not ever try to crystal clear explain !
If I was the first to answer, exactly the same than Yasser …
​

 

[sandysharma]

Actually I am completely novice in VBA Coding hence could not try much except the code written above...

 

[YasserKhalil]

No problem at all my bro. It is better to upload sample of your workbook to illustrate your needs better

 

[NARAYANK991]

Hi ,

It is not so straightforward ; see the following link for more details :

https://www.office-forums.com/threads/bold-italic-formatting-in-userform-textbox.1867324/

Narayan