View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
phil-rge-ee phil-rge-ee is offline
external usenet poster
 
Posts: 18
Default 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