Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
7 Day Automatic Imput | Excel Discussion (Misc queries) | |||
Autocorrecting my Number imput | Excel Discussion (Misc queries) | |||
Automated imput partly | Excel Worksheet Functions | |||
two-imput data table | Excel Worksheet Functions | |||
Imput box - Multiple Lines (\n) | Excel Programming |