| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell resizing | Excel Worksheet Functions | |||
| Resizing cells in a selection without resizing entire sheet | Excel Discussion (Misc queries) | |||
| Resizing scroll box | Excel Discussion (Misc queries) | |||
| Inputbox and Application.InputBox | Excel Programming | |||
| Self-Resizing Formulas | Excel Programming | |||
Linear Mode
