Hey everyone,
I am trying to build a log that will help my team do their jobs more efficiently.
I've built a UserForm that correctly logs the information entered into it.
I think I've come to my knowledge limit. What i need now, is when the user clicks "add" to submit the data, for excel to capture the image captured by the "PrntScrn" (Print Screen) button, save it to a predetermined folder, and saves a hyperlink on the spreadsheet, getting the title from a TextBox field.
If that wasn't confusing enough, I've created a picture that visualizes the order of operations.
1. User takes a screenshot of online advertisement using Print Screen button.
2. User enters data to be logged.
3. User clicks "Add" to log the information
I would be happy to upload my existing code and/or Excel file if that would help.
If anyone can help me code this i would be so grateful. Thanks!
I am trying to build a log that will help my team do their jobs more efficiently.
I've built a UserForm that correctly logs the information entered into it.
I think I've come to my knowledge limit. What i need now, is when the user clicks "add" to submit the data, for excel to capture the image captured by the "PrntScrn" (Print Screen) button, save it to a predetermined folder, and saves a hyperlink on the spreadsheet, getting the title from a TextBox field.
If that wasn't confusing enough, I've created a picture that visualizes the order of operations.
1. User takes a screenshot of online advertisement using Print Screen button.
2. User enters data to be logged.
3. User clicks "Add" to log the information
(Behind the scenes)
a. Excel saves screenshot image to screenshot file.
b. Excel creates a hyperlink to screenshot in the "Advert Source" cell.
a. Excel saves screenshot image to screenshot file.
b. Excel creates a hyperlink to screenshot in the "Advert Source" cell.
I would be happy to upload my existing code and/or Excel file if that would help.
If anyone can help me code this i would be so grateful. Thanks!
