Hi
I am new to Excel VBA so be patient with me.
I have a simple form that I want to create different document hyperlinks for a particular Organization. What I am trying to do is add data to a table that contains:
- in column 1 the organization id
- in column 2 a brief description of the document
- in column 3 a Hyperlink to that document.
The user will enter the brief description and then click on a button to find the file.
The code then places the hyperlink into cell C1, it's this hyperlink I want in column 3 of a new row in the table row.
The form will contain a listbox which will show all entries in the table for the selected Organization, my idea is the user will then select an entry in the listbox which will then open the document.
Whatever I try replaces all cells in the column of the table with the last hyperlink.
My last attempt was to do a simple copy and paste and even that put the last hyperlink in all the cells of my table column.
The frustration thing is, if I do a copy and paste manually it works, but the user will not have access to the sheet outside of the form.
Can anybody help me please?
My code so far:
Bookmarks