View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
moon[_5_] moon[_5_] is offline
external usenet poster
 
Posts: 40
Default 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.