Rest button to clear a changing image (which is dependent on a drop down selection)

Hello again,

I have a Userform with a clear button I am trying to code to clear all of the contents entered on the form (which has yet to be be submitted to the spreadsheet).

The clear button is circled in orange.

Form - clear.JPG


It all works with the exception of clearing the conditional photo (the photo changes according to the employee selected in the drop down combobox on the form).

Here is my code- can someone help me get the button to clear the photo too?..

Within the form code is:

The code changes the image of the employee depending on the employee selected on the drop down (I have a list of JPGs in the same folder with the same employee names).

Please Login or Register  to view this content.

Please Login or Register  to view this content.

End Sub


And within the module the function is:

Please Login or Register  to view this content.

The code above clears everything with the exception of the photo if an employee is selected in the form. Can someone provide me with the code to clear the photo alone- without causing errors - and where to place within the existing function?...

Maybe something like?...


Image2.Picture = Nothing

'WorkSchedule.Image2.Picture = LoadPicture("")

Originally Posted by cytop

Yours probably find your second guess would work if you tried it.

Ok, but how does that fit into the code exactly? I have tried but it is not working for me...

Ok, problem resolved. Thank you all for your input!