input box prompt
in [Programming]
|
From: Charles on 20 Apr 2010 15:10 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.
From: Rick Rothstein on 20 Apr 2010 15:22 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. -- Rick (MVP - Excel) "Charles" <harm.charles(a)gmail.com> wrote in message news:e2c616ba-dff6-4a58-918c-377b5d3a7b2e(a)n3g2000vbl.googlegroups.com... > 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. >
From: CharlesH on 20 Apr 2010 15:34 Rick Rothstein;704374 Wrote: > 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. > > -- > Rick (MVP - Excel) > > > > "Charles" <harm.charles(a)gmail.com> wrote in message > news:e2c616ba-dff6-4a58-918c-377b5d3a7b2e(a)n3g2000vbl.googlegroups.com... > > 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. > > Rick, Thanks for your reply. What you suggested was the direction I going towards. -- CharlesH ------------------------------------------------------------------------ CharlesH's Profile: http://www.thecodecage.com/forumz/member.php?u=1354 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=197085 http://www.thecodecage.com/forumz
|
Pages: 1 Prev: Solver in vba Next: Using VBA to create PDF - setting paper size |