Getting compile error 438 object doesn’t support this property or method

Hi all,

I want to insert a picture of a particular student after entering a roll no. of him in cell ‘g7’ automatically. If I enter a roll no. in cell ‘g7’ and hid enter key then the photograph of that particular student should insert in cell ‘e2’ automatically.

I want to delete a picture from ‘e2’ first and then want to insert a picture in it.
The code for inserting picture is working fine but the code for deleting the picture first is not working. I am getting compile error ‘438 object doesn’t support this property or method’

Please Login or Register  to view this content.

Any help will be appreciated.

Thanking you,

Hi all,
Now I have made a amendment in the code and getting compile error 'syntax error'.

Please see the following code and suggest me a correction.

Please Login or Register  to view this content.

Any help will be appreciated.

Thanking you.

Hi Lewis,
Excellent! It's working fine.

The second part:

If I enter a roll number of a student in 'g7' Register sheet then the code should run.

Please suggest me a sheet code for it positively.

Thank you.

Thanks for the rep points. Try the following which is also included in the attached file.

Sheet Module Code:

Please Login or Register  to view this content.

Ordinary Module Code such as Module1:

Please Login or Register  to view this content.

Lewis

Hi Lewis,
Excellent! It's perfect as per my requirement now.
'range("b20").select is only for testing purpose and no any effect. I have deleted it now.

Really, I appreciate you for the same.

Thank you and have a nice day.