Scroll behind an InputBox

[bw]

FltNum = InputBox("Enter a Flight Number", "Choose Flight", 0, 5700, 4000)

Is there anyway I can scroll the sheet behind the InputBox?

Thanks,
Bernie

 

[Tom Ogilvy]

Not while the inputbox is showing.

if you use application.Inputbox( type:=8)

the user can select a range on the sheet using the mouse which allows the
user to scroll the worksheet. But then you would return a range object
with the range of the selected cell.

Dim rngFltNum as Range
On error Resume Next
set rngFltNum = Application.InputBox("Selected a flight from the sheet",
"Choose flight", type:=8)
On Error goto 0
if not rngFltNum is nothing then
msgbox "You chose flight number " & rngFlgNum.Text
End if

 

[Guest]

No, You can't scroll sheet behind an InputBox, because InputBox is showing in modal mode.

 

[bw]

Tom,

I'm happy with this ability to select the range directly, and be able to scroll through the
sheet to find what I want, but I'm confused about the "need" for the InputBox, since the
Inputbox is not visible at all to tell the user what to do?

In this case, I "should" tell the user to select the range with the mouse, and then press
the enter key.

Got a suggestion for this?

Thanks for your help,
Bernie

 

[bw]

Oh, silly me!

The "pips" I was using before changing to Application.Inputbox was causing the box to
be off the screen.

I've got this working now, and this is just like I had envisioned it to be.

Again, Thanks Tom...

Bernie