Hi
Im getting an error on the UserForm1.show vbModeless line
it works fine on my desktop, but as soon as it is opened somewhere else it wont work and highlights this specific line, anyone have any idea why this is?
Please Login or Register to view this content.
Dan
There is probably an error on the userform, maybe in the userform initialize code
Hi I think it could be something in the userform code, and most probably this?
Can I change this so that it will save the temp file to a users desktop?Please Login or Register to view this content.
Dan
I don't think the error is with that specific line of code, all it does is assign a value to the variable FName.
If there's subsequent code that uses that variable that might be where the error lies.
To actually find which line, if any, in the userform code causes the problem open the form design mode, put the cursor in the Initialize/Activate event and start stepping through with F8.
Or goto Tools>Options... and set Error Trapping to either Break on All Errors or Break in Class Module.
PS You could change that line to point to the user's desktop.
If posting code please use code tags, see here.
Hi
I am going to give that a go now thanks
Im getting errors on two parts of the code, but run fine when I run it from my computer
Both highlighted in red, I have placed this document onto a sharepoint where users can access it, and this seems to be where the problems are occurring nowPlease Login or Register to view this content.
With reference to the desktop location, my desktop path is "company.co.uk\dfs\users\DanielS\Desktop"
So my name is within the file location, and im not sure how to change that to pick up the users name?
If you are getting an error here it means there is an error in the userform code.
To find out what line in the userform code is causing the error try what I suggeeted in my previous post.Please Login or Register to view this content.
As for the other error, do you actually need to activate the sheet/charts when the workbook opens?
If you wanted a particular sheet to be activate when the workbook is opened make it the active workbook before you close and save the workbook.
the userform displays charts based on textbox values in the form, so every time the userform is called or modified, I make the code refresh the charts, otherwise it doesn't seem to display correctly
Sorry I'm confused, the code you posted isn't being called from the userform it's called when the workbook open and the code itself opens the workbook.
If you are having an error on this line it usually means there's an error somewhere in the userform code, most likely in the Initialize/Activate event.
Have you looked at that code?Please Login or Register to view this content.
Yes it is called when the workbook opens, and the error occurs on the userfrom1.show vbmodeless line,
Within the user form initialize event it refresh's the charts there too
Please Login or Register to view this content.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks