ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ReSizing InputBox Parameters (https://www.excelbanter.com/excel-programming/431353-resizing-inputbox-parameters.html)

LRay67

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

Linda

ryguy7272

ReSizing InputBox Parameters
 
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---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"LRay67" wrote:

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

Linda


Patrick Molloy

ReSizing InputBox Parameters
 
can't be done. best option is to create a userform for this

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

Linda




All times are GMT +1. The time now is 01:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com