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

Activate that workbook before displaying the InputBox, maybe?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

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


"avi" wrote in message
...
Hello,

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

Thanks
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

On 5 juil, 17:09, "Peter T" wrote:
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