Excel VBA in a userform that create a hyperlink into a specific cell location

Thats kinda what I'm struggling with. I have multiple Revs of this database and I've tried a few different things. The GetOpenFilename command works properly inside of Module 3 under Select_A_File, but it doesn't store the path that I've located. So what I would like to do is have it store a specific file path into that userform text box labeled picture link. Then from there it should save into the database. So the coding inside of the command button isn't right. I've been reading through this VBA book, but no luck yet.
Any Ideas?



Thanks,
Mike

I do have a VBAProject (funcres.xlam) but i wasn't aware that it was being used by this. I don't think it should have any impact on the this project. The only thing in that project under Modules which was a labeled RibbonX_Code.

Please Login or Register  to view this content.

To answer your question I would like to address the coding in Forms "viewrecord" on my doc. In the coding there is Sub Select_A_File(). This should be under CommandButton2_Click(). I think on the copy i posted its probably a little messy where I have a few other things entered in there where i was trying to get to work, but unlikely to succeed.

Please Login or Register  to view this content.

My goal is to be able to go back and edit specific cells in the data and add some recent pictures, there file directory (jpg) to correspond to the item. I would like to use CommandButton2_Click to allow me to search for the image (jpeg) and once selected have that directory saved into "txtpic1". But I was wondering if i could make that directory into a Hyperlink. This way if i search for the item on the frmSearchDatabase I could click on the images hyperlink and then i would bring up the picture. I know this is a lot to ask for or maybe not, I've just spent a lot of time finding myself no solutions.

Thanks for the help!

Mike

This copy of the document may be a little better to work with.

I got rid of the reference and I noted on the user form of the issue.

-Mike

I was looking to get the file name placed in the textbox named 'txtpic1'. If you view the userform form 'viewrecord' as an object, there will be a text box next to picture links. The cells are initally locked until the user clicks the edit button. Once the edit button is selected then 3 cells are allowed to be edited. This is where i hope to use that ADD button 'CommandButton2_Click' to initalize the GetFilePath. Once the file path directory is found I hope to copy it into the 'txtpic1' box without finishing the editing. Is it also possible to have that file path then changed into a hyperlink before being copied over?

Below is the part of the code that has txtpic1 during the editing version.

Please Login or Register  to view this content.

You are such a life saver!!!
I was so close, but once reading over your code I realized i was just defining the wrong value.
THANKS SO MUCH!!!!

One other thing tho, I'm trying to play around the hyperlink function. I would like to make that textbox be a hyperlink. Can I do that before it places it into the textbox or is it better to just save the value as a hyperlink once I click the submit button?

Thanks again..
Mike