MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Input Box Size, (Or how to fit 2 tons of stuff in 1 ton box)

Posted by Joe C on December 12, 2001 8:58 AM

How do Increase the size of acceptable characters in the input area of an inputbox?

Posted by Joe Was on December 12, 2001 9:37 AM

The InputBox has a limit both in size and the number of characters both are about 1/8th of a page. You can change your code from an input box to a custom user form. To do so you can use the Form Wizard in the VB editor to add controls to your for which except user input, check boxes, radio buttons, etc. Then use your form in place of the InputBox. You can increase your form size, like a window. JSW

Posted by Joe c on December 12, 2001 10:46 AM

Joe Was, (and still is the man!!!)

Thanks! Will try.