Inputbox from another OPEN workbook

  • Thread starter Thread starter avi
  • Start date Start date
A

avi

Hello,

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

Thanks
Avi
 
avi formulated the question :
Hello,

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

Thanks
Avi
Click to expand...

Activate that workbook before displaying the InputBox, maybe?
 
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.
 
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
 
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
 
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
Click to expand...

Looks promising. Many thanks

Avi
 
Back
Top