selecting cell from another workbook

[xzaqus]

Hi, I am trying to select a cell from another workbook. I have the following code, a new workbook opens but is greyed out and I cannot select the cell. Once I close the inputbox, then i see the target workbook open up. Please suggest

If condition is true Then
Workbooks.Open fileName:=openFilePath & openFileName
Sheets(openSheetName).Activate
Set openCellAddress = Application.InputBox("Select the cell that has the value", "Select cell", Type:=8)
MsgBox openCellAddress.Address
End If

I am attaching the screenshot of the excel file that opens up with the input box.
Image is https://www.dropbox.com/s/hwq98jzqt7kw4ao/Capture.PNG?dl=0

 

[xzaqus]

Bump..

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...book-select-cell-post5042352.html#post5042352

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).