Teacher In Urgent Need of Help

[DearAppeciatedHelper]

Hi everyone,

Sorry, with vbna I am only at the search for what I want, find what I can alter and put the pieces together stage of vba i.e. quite a novice. Your help is MUCH appreciated as I am using excel to automatically update a form with every change of lesson to give links focus and time. Considering I will be teaching four subjects at secondary this is a need, not a want.

Image is at:
https://lh5.googleusercontent.com/l...4uZbAorfzxmXt70XdU7SZVYy9WmG09wyaFzu7mY=w1175


It was working perfectly and then all of a sudden I am getting:-

Run time error 4242 Object required, have also had File path error but will come to that later.

Is it simply that I have not declared data type or label1 as string?

Advise me please. Thx

 

[DearAppeciatedHelper]

Image1.Picture = LoadPicture(FullImagePath)

Thanks for you help so far. I am new to posting a thread but is there any way of sending it or is that now allowed on MrExcel.

 

[RoryA]

You can't send the file, though you could upload it to Dropbox/OneDrive or some other sharing site and put a link back here. It shouldn't be necessary at this stage though.

If you type Me. (including the full stop) in front of the word Image1 in that line, does Image1 appear in the list of items that pops up in the editor?

 

[DearAppeciatedHelper]

Compile error:
Method or data member not found

 

[RoryA]

Again, that suggests that your form does not have an Image control on it, or if it does, it's not called Image1.

 

[DearAppeciatedHelper]

The is file is downloadable:-
https://drive.google.com/file/d/1uQR1W95OkiGlYVXZifxwPdwd83t4q5TN/view?usp=sharing


Got any questions please ask. The Image1 was working fine for what it is worth Rory.

 

[Fluff]

As Rory said, you don't have an Image Control on the Userform, nor anything called Image1