Input box size

[Guest]

When using an input box the default window is always the same size. How do you change the size? Also the default allows for 1 line of input. How do you change that so that the size is now say 2 lines

TIA

 

[Tom Ogilvy]

Easiest fix would be to use a useform. Otherwise, I suspect you would have
to use the windows API.

--
Regards,
Tom Ogilvy

When using an input box the default window is always the same size. How do

you change the size? Also the default allows for 1 line of input. How do you
change that so that the size is now say 2 lines?

 

[Guest]

Thats what I thought and I do not know API
Thank
To

----- Tom Ogilvy wrote: ----

Easiest fix would be to use a useform. Otherwise, I suspect you would hav
to use the windows API

--
Regards
Tom Ogilv

When using an input box the default window is always the same size. How d

you change the size? Also the default allows for 1 line of input. How do yo
change that so that the size is now say 2 lines

 

[Gord Dibben]

GM

You can have line feeds in an InputBox

pickone = InputBox("0 To Delete Rows" & vbCrLf _
& "1 To Select Cells" & vbCrLf _
& "2 To Hide Rows" & vbCrLf _
& "3 To Select Entire Rows")

Gord Dibben Excel MVP