Hyperlink to Folder Location

[Eurekaonide]

Hi All

I have a form which the user inputs data into and then the data gets fed into the set relevant cells on a worksheet.

One of the boxes they need to fill in is a Hyperlink to a folder location.

What I guess i would liek to happen is that when they click (or in deed Tab) to this cell that the normal dialogue box pops up to select the path to the document location and then show this path. in the corresponding cell (say Cell AJ)
does anyone have any code that i could try for this please, tried searching but cannot find what I'm after.

 

[Eurekaonide]

I'm getting an error code of 1004
"Application-defined or object-defined error"

Should I be declaring something?

my code;

Range("AJ" & iRow).Formula = "=Hyperlink(" & TextBox34.Text & ")"

 

[RSXchin]

forgot the double quotes, sorry

Range("AJ" & iRow).Formula = "=Hyperlink(""" & TextBox34.Text & """)"

 

[Eurekaonide]

Fantastic - thank you so much you have saved me so much work trying to locate or remember where over 200 files are kept

 

[RSXchin]

Always here to help