Run-time error '1004' - Method 'Range' of object '_Worksheet' failed

Hi,
I'm new here on the forum and new to VBA, this is my first attempt to create a Userform. I have the problem stated within the title of this post and I would really appreciate any help. Below is the code:

Please Login or Register  to view this content.

I deleted then retyped this line of code and the error went away.

Please Login or Register  to view this content.

Sometimes the gremlins get in there and retyping is the way to get them out.

I don't see any ranges named SHIFTList, AUDITORList, etc. I see ranges named SHIFT, AUDITOR, ...

Originally Posted by shg

I don't see any ranges named SHIFTList, AUDITORList, etc. I see ranges named SHIFT, AUDITOR, ...

Hah! Didn't even check the name manager. That will sure cause some grief.

"I don't see any ranges named SHIFTList, AUDITORList, etc. I see ranges named SHIFT, AUDITOR, ... "

Hi and thank you for your suggestion. As I said I'm new to this, as self-learner and not very sure of what I'm doing. I this what I should do?
Dim cSHIFTList As Range
Dim cAUDITORList As Range
Dim cMODELList As Range
Dim cSTEPList As Range

Because I did it and now I have the following issue:

Compile error: variable not defined

For Each cSHIFT In ws.Range("SHIFTList")

Please add Code Tags to your opening post as per Forum Rule #2.


Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

You have set the RowSource for every Combobox-object so you don't have access through your Initialize-Code.

Originally Posted by bakerman2

You have set the RowSource for every Combobox-object so you don't have access through your Initialize-Code.

Thank you very much for your help and I want to thank everyone for their support and the learning opportunity I had.
I also want to wish everyone (where applicable, of course) happy Christmas!
And last but not least I have some more questions/issues (that's what happens when you're looking for answers and find out that are some other things you could do to make things even more efficient) and I don't know how I should proceed - do I have to open new thread(s)? Please advise.

My questions/issues are:
1. I would like to make the Userform from my DCLP-PV-FORM workbook to open the DCLP-PV-REP workbook, feed data onto it, save and close it. The reason behind this is that the form has to be filled in by certain people and after that other people will process the information from the collecting data base and it is more than desirable for the first category of people not to be able to access the target data base.
2. Is it possible to set the form in such a way that will unable the user to close/submit the form unless EVERY field is completed? We have a major problem with incomplete information being submitted.
3. Is it possible to set the form in such a way that the user can't fill in in the Combo Boxes other information than the information established within the LookupLists? The aim is to standardise the data entry content in order to ease the final reporting process from the collecting data base.
4. Looking for information how to achieve the above I couldn't get to a working result but I found out that is possible to create interactive Userforms which I tried and now I'm completely lost.

Again, I would appreciate any help if anyone is willing to clean up the mess I did and you have my thanks in advance.
If not, until I'll learn some more and be able to do it myself, I'm declaring myself happy anyway with the help I received already and I'll mark the thread as solved since my initial request for help has been answered and solved.