Hi board members.

I'm coding a spreadsheet index to the vid files on my hds.

Each row represents a video file, with hyperlinks to the video; folder; url; and an associated image. I have also included a checkbox for "viewed" and a star rating.

Now, what I want to do is include a category for each row (file)

Is there a way of clicking on a cell within that row which will provide a list of rating/descriptions which when clicked will return a "single" letter representing that selection. And then when I have left the cell - only that letter remains and the list of rating/descriptions closes?

I would use a Form List Box but in a vacant cell and then use a "if" statement to return the specific "single letter" selection, but I don't want the Form List Box to be visible on screen once used.

Got any ideas?

Happy Holiday Season

Mal from Cessnock AU