bold the text in textbox in vba

[sujin_sam]

"Server Response Load Time - 2020 Peak Event Profile (Black Friday):" & vbCr & "As a customer, I want to receive a response within the maximum acceptable wait time throughout the Black Friday peak event period so that I can make timely purchases before stock runs out and I don't get frustrated and find another site." & vbCr & vbCr & "Server Response Load Time - 2020 High, Normal & Low Load Profiles:"


I have this text in textbox in vba, i need to bold "Server Response Load Time - 2020 Peak Event Profile (Black Friday):" value and "Server Response Load Time - 2020 High, Normal & Low Load Profiles:" value,

someone help me with this case?

 

[Norie]

Where is the textbox located and how was it created?

 

[sujin_sam]

Where is the textbox located and how was it created?

i created it using active x controls....

 

[sujin_sam]

its in excel sheet using active x controls

 

[Rick Rothstein]

I have this text in textbox in vba, i need to bold "Server Response Load Time - 2020 Peak Event Profile (Black Friday):" value and "Server Response Load Time - 2020 High, Normal & Low Load Profiles:" value,

As far as I know, all the text within a TextBox must be formatted the same (that is, you cannot format part of the text different from the rest of the text).

 

[sujin_sam]

but rick,,my supervisor said it could be done,,i have seen some other forums too,,they said the same thing u did

 

[Rick Rothstein]

but rick,,my supervisor said it could be done,,i have seen some other forums too,,they said the same thing u did

I honestly do not think your supervisor is correct. In the compiled version of Visual Basic (back in the late 1990's, early 2000's), there was a Rich TextBox control that allowed text to be formatted differently, but I am almost positive that control will not work within the VBA world that Excel uses.

 

[sujin_sam]

oh,,ok. thanks rick