Application.InputBox Type:=8 FullPath

[drom]

ref.: Application.InputBox Type:=8 FullPath

hi and Many Thanks in advance!

I have >=2 workbooks open

I am using

Dim AAA as Range
Set AAA = Application.InputBox( Prompt:=tMsg, Title:=tTitle, Type:=8)

to refer to a cell whithin one other workbook different tant the active one.

I can get the value of the selected workbook's range

but how can I know the FullPath of the selected cell whithin that Workbook?

Do I need a UserForm?

Thanks!

 

[xenou]

Can you really select a cell in another workbook with the input box? I didn't think that was possible.

Presumably if you can select a cell, the cell you've selected is already in the activeworkbook...

Msgbox ActiveWorkbook.FullPath

If for some reason that's not true, this would work in a pinch

Dim wb as workbook
Set wb = ActiveWorkbook
AAA.Select
msgbox ActiveWorkbook.FullPath
wb.Select

There's parent properties but I've never had much luck with them. Maybe someone else here can show the way... Regards.

 

[RoryA]

You would need:

Msgbox AAA.Parent.Parent.Fullpath

FWIW.

 

[RoryA]

Though it would be easier to use:

msgbox AAA.Address(external:=true)

rather than fannying about with multiple parent properties!

 

[xenou]

Msgbox AAA.Parent.Parent.Fullpath

Thanks Rorya...I don't think I'd have figured this one out for years...!

Reminds me of:

myRange.Name.Name

AB