I have an Image control in my my excel worksheet.
I load pictures into the image ActiveX in the worksheet and add comments to a array of cells A4:D5.
Whenever the workbook is closed and opened the last picture loaded in the image control and the previous riddles (comments) appear, but i don't want it to be so.
When the worksheet is opened the riddles must appear only after the start button is pressed (The previous comments must be cleared when the worksheet is opened)
the pictures must load only after the user enters the answer and clicks the submit button.
I have been trying to work on a mouse move even that will read the comments when the user moves the mouse over the cell to reveal the comment.
below is what i put down but i don't know how to connect it with the comments for them to be read.
Private Sub Cells_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
Application.Speech.Speak "" & Selection.Comment.Text & "", True