input box prompt

C

Charles

Hi,

Once again I need help. I have an Input Box that I would like to set a
portion of the prompt font to bold.
I've searched the forums and could not find an answer.
This is the code for the Input Box that I'm using

InputBox("Enter Allocation For : " & .lstProddescp.List(i) & vbCrLf &
"Current Qty is : " & MyQty)

You will note "MyQty" this is what I want to make bold. It is a
numeric value.
In my limited knowledge I tried to format "MyQty" to bold, but only to
fail.
Any help would be appreciated.
 
R

Rick Rothstein

You cannot do that with a standard InputBox (nor a MessageBox for that
matter); however, you could create your own "input box" using a UserForm
which would give you more control over what is displayed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top