![]() |
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 |
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 |
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