Hi All
Im getting a run time error onIt seemed to happen after i added this bit of code in....
Please Login or Register to view this content.
Would anyone know where the error is coming from?, it only highlghts the userform1.show bit on the debug and my code to show the userform is thisPlease Login or Register to view this content.
Any solution or advice would be great, as this is getting rather annoyign nowPlease Login or Register to view this content.
thanks Dan
Did you mean to use a userform then maybe change the typo.Please Login or Register to view this content.
Please Login or Register to view this content.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Haha, sorry that was me just typing the code down, rather than copying, my mistake
That isnt how it is spelt in vb
You can set a breakpoint in the routine in order to aid debugging.
I would guess, whithout seeing all your code, that the variable mChartNum is zero.
hi Andy
It is, this is what you helped me out with the other day when it just wouldnt add the gif to the userform, i have built on that to add 8 gif's and it was workign fine, then when i reopened the book it now has this error,
Chartnum = 1
thenPlease Login or Register to view this content.
The module is what you gave mePlease Login or Register to view this content.
Please Login or Register to view this content.
Try adding a breakpoint in the routine and step through the code and see if you can isolate the line that errors.
The error code would suggest you are try in reference a sheet or chartobject that does not exsist.
Right ive managed to get rid of the runtime error 1004, now im getting run time error 481, but there are no invalid pictures! theres 8 charts all reference by mchartnum then + by num to get what chart i want in what image control
But its still on the same line, which i changed to create userform 2 snip.PNG
Surely theres a simple solution to this as it was working fine yesterday
Press SHIFT+F8 to step into the initialize event.
also I assume vb modeless is a typo. vbModeless
right here is the example file.
I have run through the first code workbook_open and its definately on the userform2.show, there is a slight issue i have just noticed and dont know if it is affecting this workbook
I have two xlam projects which i have no idea what they are, or where they come from, they are password protected to so i cant open or delete!
These are the ATPVBAEN and EUROTOOL....
yep its a typo haha, sorry
Ok so i change userform_initialize to userform1_initalize and it opens up the form but adds non of the text or images
Those are MS addins for Analysis toolspak and Eurotool, red herrings I think.
Can you check the file size of the temp.gif file. I get Invalid picture type when the file is zero bytes small.
Ok so nothing to worry about then
You are right it is 0kb, would it help to change them to jpeg or PNG?
I refactored the code and it appears to be working now.
Please Login or Register to view this content.
Weird, im still getting errors on your sheet and on mine, yours is telling me that the activate method failed, on activate charts, and mine is still telling me invalid picture, when i use your example above
Restart excel and delete all those temp gif files and try again
Right i restated excel, then restarted the laptop, then wanted to kick the laptop, then ive fixed it
i changed chartnum = 1 to chartnum = 0
the on the workbook_open sequence i added code to select all charts (activate) before the userform1.show command.
it works!may not be the right way to do it, but it works again, thanks for helping again and trying to explain to me the procedures in fixing the issue
Dan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks