This error has all of a sudden locked up my macros out of no where. It appears to only have an issue when I call on my form. The form is quite large so I suppose this could be an issue but I am overall guessing I need to make the form small but I am not sure. Any ideas on how to fix this?
When you get the error, click Debug and then hit CTRL+L...
You should now see the Call Stack which will show you a list of all the procedures that have been called that are still 'active'.
That might shed some light on what's causing the problem.
For example, it might show you a procedure that is being called over and over again, perhaps even calling itself.
If posting code please use code tags, see here.
Useful to know. I think I have made the discovery that I just simply have to many controls on the form. I have been trimming ones that are less important and it appears to be as long as I stay below a certain number.
How many controls do you have on the form?
Any chance you could upload a sample workbook?
Click on GO ADVANCED, scroll down and click Manage Attachments.
I had persistent Error 7, always at same VBA line. Turns out I had a typo: I was concatenating cell.values and left out the address: A = Cells(1,1).value & Cell & Cells(2,1).value
I removed the typo, Error 7 disappeared.
Eliot, thanks for the input
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks