Inputbox from another OPEN workbook

[avi]

Hello,

Is there a way to return a range with Inputbox from another OPEN
workbook?

Thanks
Avi

 

[GS]

avi formulated the question :

Hello,

Is there a way to return a range with Inputbox from another OPEN
workbook?

Thanks
Avi

Activate that workbook before displaying the InputBox, maybe?

 

[Vacuum Sealed]

Avi

I am not really up to speed with Excel User forms and their functionality or
the scope of what can be done within them.

How about a user form, I have an idea, although it has potential for
pie-in-the-sky as I am not sure if it is fundamentally correct.

When said userform is opened~activated, the attached Listbox / combobox
looks for all opened~active workbooks then compiles and displays a list for
you to select from.

You could then have a series of other boxes to do whatever it is you are
hoping to do, eg insert something into a specific cell or range or something
to that affect.

Something to ponder.

HTH
Mick.

 

[Peter T]

Dim rng As Range
On Error Resume Next
Set rng = Application.InputBox("prompt", "title", Type:=8)
On Error GoTo 0
If rng Is Nothing Then
MsgBox "you didn't select cells or type a valid address"
Else
' if you want to activate the Input range

rng.Parent.Parent.Activate
rng.Parent.Activate
rng.Activate
End If

Regards,
Peter T

 

[Peter T]

PS, forgot to add, with the Inputbox showing to navigate to a different
workbook use the Window menu (2003) or equivalent on the Ribbon.

Peter T

 

[avi]

PS, forgot to add, with the Inputbox showing to navigate to a different
workbook use the Window menu (2003)  or equivalent on the Ribbon.

Peter T

Looks promising. Many thanks

Avi