When you right-click a .jpg file, select Properties and then click the Details tab you see a Description section that contains Rating (five star selector) and an editable Comments field. I would like to use VBA to prompt the user to enter a comment and click the appropriate star (and maybe enter a tag) before the image is saved into another folder.

The spreadsheet will contain a list of images that the user will view and then make a decision about whether the image is of acceptable quality to be saved into a new folder for the marketing department. The user will select the row that contains the image and then click a button to send it to the new folder (using filecopy....the path to the original file is also in the spreadsheet). Optimally, I would like the properties dialog to pop up for the image so the user can add a comment and a rating directly to the details tab after making the decision to save it to the new folder. When the comments and ratings are complete, the user is returned to the table to make the next decision.

Thanks!


Capture.PNG