drom
Well-known Member
- Joined
- Mar 20, 2005
- Messages
- 528
- Office Version
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
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!
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!