I have a user form, that keeps giving me errors, run time '1004
I am not sure why, it has been working fine for a few months, now its acting up. Any suggestions, I have read several threads, but I don't see the problem.
I have a user form, that keeps giving me errors, run time '1004
I am not sure why, it has been working fine for a few months, now its acting up. Any suggestions, I have read several threads, but I don't see the problem.
Providing Problems for Your Solutions
STARS are my Punching Bag, You will be rewarded.
In the rare event that I may help you, feel free to make me see STARS
Hi 00Able
Your sample file contains no data so it's difficult to troubleshoot. The procedure is choking at this lineThe named range "LineList" contains no records so I'd assume this could be causing the error.Please Login or Register to view this content.
How/where does named range "LineList" get populated?
John
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
It pulls the dynamic name ranges from the worksheet, LookUpLists, the Line list is column L, but note previous to deleting this information, it was still giving the error, I put random letters in, and it still returns the same error. I am perplexed. This issue is happeneing in multiple userforms, and I have no idea why. Yesterday all was fine, today crapoli...deep sighs....
Having said that all the named ranges are in the lookuplists, named after the column header. so Name would be NameList, Line=LineList, SKU=SKUList, so forth ...
The problem appears to be caused by empty named ranges. Also you don't need False after .Show
Please Login or Register to view this content.
Last edited by royUK; 01-14-2011 at 03:57 AM.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Setfocus isn't necessary if you set the tabindices correctly:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks