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

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

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