ReSizing InputBox Parameters

  • Thread starter Thread starter LRay67
  • Start date Start date
L

LRay67

Is there a way to resize the InputBox when it prompts user for input? Any
help would be greatly appreciated. Thanks

Linda
 
AFAIK, You can't change the format and/or size etc of an InputBox. To alter
their appearance you need to use the Windows API. It's fairly complex. An
easy solution would be to create a UserForm and use it for input. You can
pretty much do whatever you want, in terms of format and/or size, with a
UserForm.

HTH,
Ryan---
 

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

Similar Threads

Validation on InputBox() 5
Somewhat complex code to copy data from one sheet to another 9
If ActiveCell has a comment then exit sub 22
Loop thru xx No. of sheets until the four strValue combo's are found 6
Restrict Input of InputBox to numeric values between 1 and 10 4
help with array 5
Combine three InputBoxes into one? 7
Macro Help 6

Back
Top