xluser2007
12-06-2008, 09:48 PM
Hi All,
Based on Ken Puls' superb KB entry (http://www.vbaexpress.com/kb/getarticle.php?kb_id=284) 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,
Based on Ken Puls' superb KB entry (http://www.vbaexpress.com/kb/getarticle.php?kb_id=284) 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,