format text in imput box
is their a way to format text in a input box , or even better format just
certain parts of the text reg = InputBox("" & Range(locatetrunk) & " Reg = " & Range(locatereg) & Chr$(13) & Chr$(13) & "Time Is " & Format(Now(), "hh:mm") & Format(" Trunk Due :-" & Format(Range(timedue).Value, "hh:mm")) & Chr$(13), "Confirm Trunk Name And Registration Number ", Range(locatereg)) i would like to get the times to be in bold or another colour - |
format text in imput box
Rich,
Not built-in. If you need that functionally, build yourself a userform and then you can do whatever you want. NickHK "Rich" wrote in message ... is their a way to format text in a input box , or even better format just certain parts of the text reg = InputBox("" & Range(locatetrunk) & " Reg = " & Range(locatereg) & Chr$(13) & Chr$(13) & "Time Is " & Format(Now(), "hh:mm") & Format(" Trunk Due :-" & Format(Range(timedue).Value, "hh:mm")) & Chr$(13), "Confirm Trunk Name And Registration Number ", Range(locatereg)) i would like to get the times to be in bold or another colour - |
format text in imput box
Just to add:
to the best of my knowledge, the standard userform controls don't support rich text formatting -- Regards, Tom Ogilvy "NickHK" wrote: Rich, Not built-in. If you need that functionally, build yourself a userform and then you can do whatever you want. NickHK "Rich" wrote in message ... is their a way to format text in a input box , or even better format just certain parts of the text reg = InputBox("" & Range(locatetrunk) & " Reg = " & Range(locatereg) & Chr$(13) & Chr$(13) & "Time Is " & Format(Now(), "hh:mm") & Format(" Trunk Due :-" & Format(Range(timedue).Value, "hh:mm")) & Chr$(13), "Confirm Trunk Name And Registration Number ", Range(locatereg)) i would like to get the times to be in bold or another colour - |
All times are GMT +1. The time now is 11:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com