killaej6
New Member
- Joined
- May 22, 2021
- Messages
- 7
- Office Version
- 365
- 2016
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
Hi,
I need help.
I am using the following code for my command button ( named Evidence) :
Application.Dialogs(xlDialogInsertHyperlink).Show
I am giving an option to users to select whichever file they want and i want the address of the file to appear in a cell that i have specified.
Cells(emptyrow, 24).Value = Evidence.Value
However, i have 2 problems :
1. On row 24, i get a result of FALSE
2. the link address is being returned to another cell ( i see that the address is being returned to the last clicked cell)
How do i get the address link to appear ( with the ability to function as a link of course) on the cell which i have intended?
Thank you in advance for your inputs.
I need help.
I am using the following code for my command button ( named Evidence) :
Application.Dialogs(xlDialogInsertHyperlink).Show
I am giving an option to users to select whichever file they want and i want the address of the file to appear in a cell that i have specified.
Cells(emptyrow, 24).Value = Evidence.Value
However, i have 2 problems :
1. On row 24, i get a result of FALSE
2. the link address is being returned to another cell ( i see that the address is being returned to the last clicked cell)
How do i get the address link to appear ( with the ability to function as a link of course) on the cell which i have intended?
Thank you in advance for your inputs.