Thread: Format prompt in VB InputBox

I have been using VB to automate (and make somewhat chimpanzee proof) some
Excel spreadsheets that I use to track info at the RV Dealership I work for.

I would like to change (make larger) the font characters used to print the
prompt in the InputBox which is displayed for the user to enter data.

So far I have not been smart enough to discover a way to do this. Can
anyone help?

--
Pat...........................

No can do . Try a userform instead

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Patrick14" <Patrick14@discussions.microsoft.com> wrote in message
news:C98DBF99-6E43-4554-9B91-CD3219F8979C@microsoft.com...
>I have been using VB to automate (and make somewhat chimpanzee proof) some
> Excel spreadsheets that I use to track info at the RV Dealership I work
> for.
>
> I would like to change (make larger) the font characters used to print the
> prompt in the InputBox which is displayed for the user to enter data.
>
> So far I have not been smart enough to discover a way to do this. Can
> anyone help?
>
> --
> Pat...........................

If you want a custom msgbox and inputbox with lots of powerful options then
here is one I uploaded some weeks ago:
http://www.planet-source-code.com/vb...65065&lngWId=1

RBS

"Patrick14" <Patrick14@discussions.microsoft.com> wrote in message
news:C98DBF99-6E43-4554-9B91-CD3219F8979C@microsoft.com...
>I have been using VB to automate (and make somewhat chimpanzee proof) some
> Excel spreadsheets that I use to track info at the RV Dealership I work
> for.
>
> I would like to change (make larger) the font characters used to print the
> prompt in the InputBox which is displayed for the user to enter data.
>
> So far I have not been smart enough to discover a way to do this. Can
> anyone help?
>
> --
> Pat...........................