Editable table popup userform triggered by a hyperlink

[hstef]

Hi,

I need an editable table popup userform to be triggered by a hyperlink (macro).

I have the below table in sheet1 "EW":
-in cell B6 i have "EW 100ml "
-in cell B7 i have "EW 150ml"
-in cell B8 i have "EW 500ml"

I have the below table in sheet2 "CF":
-in cell B6 i have "CF 1000ml P"
-in cell B7 i have "CF 1000ml O"

I need to make an hyperlink for cell B6, another for B7 and another one for cell B8, or whatever cell will have a project, and link it to a macro.

When i click a cell with hyperlink "EX: sheet1/B6", i need a popup userform to show, displaying info for "EW 100ml". Basically, i need this userform to be an editable table. This table should have 3 columns (table head: DATA, OBS1, OBS2). I need to add/fill my data to last row and this to be saved and displayed each time i open the userform along with all previous entries for "EW 100ml".

If i click sheet1/cell B6 then the popup to display the entries for "EW 100ml".
If i click sheet2 cell B7 then the popup to display the entries for "CF 1000ml O".
...etc

All entries to be saved in "sheet DB", for all popup windows (ex:sheet1 B6, Sheet1 B7, Sheet2, B7...etc).
basically will be a timeline status for a project.

The userform should look like this:
...DATA.......OBS1...............OBS2
20.04.2020...project started......3h
21.04.2020....die cut received....1h
22.04.2020...info received.........5h
23.04.2020...first sample ready....3h
..this line should be filled with next entry

'The entries could be long, so i need the cells in userform table to be "wrap text".

Can this be done?
Thank you in advance,
Have a pleasant day.
Stef.

 

[Anthony47]

You can easily develop what you need by linking the Userform Show to the Worksheet_FollowHyperlink event

If you need help on specific area, just post again

Bye