Solved: Call Folder Picker from Cell

[xluser2007]

Hi All,

Based on Ken Puls' superb KB entry for picking a folder via a Userform, I would like to call this from a named range called "folder_picker".

I have the sample attached workbook, and am not sure why the event driven code to call the routine, when the user double-clicks "folder_picker" is not working.

Could any please explain how to make the above code work.

regards,

[GTO]

Hey xlUser,
I think you mis-named the event. For:
[vba]Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)[/vba]
substitute:
[vba]Private Sub Worksheet_DoubleClick(ByVal Target As Range, Cancel As Boolean)[/vba]

Hope this helps,

Mark

Edit: or better yet, do just backwards of what I said...

[xluser2007]

Hey xlUser,
I think you mis-named the event. For:
[vba]Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)[/vba] substitute:
[vba]Private Sub Worksheet_DoubleClick(ByVal Target As Range, Cancel As Boolean)[/vba]
Hope this helps,

Mark

Edit: or better yet, do just backwards of what I said...

Thanks Mark, good pickup - works a treat now.

I realised that there is a drop down in the VBE for Event Driven Code, which would prevent such errors from popping up.

regards,