ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Control size of input box (https://www.excelbanter.com/excel-programming/371490-control-size-input-box.html)

Little Penny

Control size of input box
 
Is it possible to control the size of and input box. I would like to
make the box smaller the the default?


strjobnumber = Application.InputBox("Start in Job Number?", " First
Job to Print", 0)
If strjobnumber = False Then Exit Sub
endjobnumber = Application.InputBox("Finish in Job Number?", "
Last Job to Print", 0)
If endjobnumber = False Then Exit Sub

moon[_5_]

Control size of input box
 

"Little Penny" schreef in bericht
...
Is it possible to control the size of and input box. I would like to
make the box smaller the the default?


strjobnumber = Application.InputBox("Start in Job Number?", " First
Job to Print", 0)
If strjobnumber = False Then Exit Sub
endjobnumber = Application.InputBox("Finish in Job Number?", "
Last Job to Print", 0)
If endjobnumber = False Then Exit Sub



You can specify the InputBox position on the screen, but not its size.
Just create your own inputform.




All times are GMT +1. The time now is 05:11 AM.

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