browse file location in a cell

Hi everyone

I have an image in a userform.
I need to load pictures in the image from file path in cell A1.
I want to print the location of the pictures in cell A1.
Example when I click commandbutton1 I want to browse and choose the location of the pictures (eg. "D:\My data\Pictures") then the file path being copied in cell A1.

So that Cell A1 should read "D:\My data\Pictures"
Hope someone may help me
Thank you

Try this

Please Login or Register  to view this content.