ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   input box text formatting (https://www.excelbanter.com/excel-programming/353271-input-box-text-formatting.html)

phil-rge-ee

input box text formatting
 
When using VB code for an input box to come up on a button click is there a
way to code the formatting of the text in the input box? Like making the text
arial, 12 pt or similiar.

Below shows a sniplet of my code how I'm using the input box code right now:

Do
iStart = InputBox("Input first week (1-9)")
Loop Until iStart = "" Or (iStart 0 And iStart < 10)

How can I format the "Input first week (1-9)" text that comes up with the
input box?

Thanks,
Phil

Norman Jones

input box text formatting
 
Hi Phil,

I do not think tht you can.

Try, instead using a custom designed userform.


---
Regards,
Norman



"phil-rge-ee" wrote in message
...
When using VB code for an input box to come up on a button click is there
a
way to code the formatting of the text in the input box? Like making the
text
arial, 12 pt or similiar.

Below shows a sniplet of my code how I'm using the input box code right
now:

Do
iStart = InputBox("Input first week (1-9)")
Loop Until iStart = "" Or (iStart 0 And iStart < 10)

How can I format the "Input first week (1-9)" text that comes up with the
input box?

Thanks,
Phil




phil-rge-ee

input box text formatting
 
Thanks Norman.......back to the drawing board. ;o)
Phil

"Norman Jones" wrote:

Hi Phil,

I do not think tht you can.

Try, instead using a custom designed userform.


---
Regards,
Norman



"phil-rge-ee" wrote in message
...
When using VB code for an input box to come up on a button click is there
a
way to code the formatting of the text in the input box? Like making the
text
arial, 12 pt or similiar.

Below shows a sniplet of my code how I'm using the input box code right
now:

Do
iStart = InputBox("Input first week (1-9)")
Loop Until iStart = "" Or (iStart 0 And iStart < 10)

How can I format the "Input first week (1-9)" text that comes up with the
input box?

Thanks,
Phil






All times are GMT +1. The time now is 01:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com