VBA range not populating correctly

[Squirrel]

Please Login or Register  to view this content.

The code is above. For whatever reason it comes up with an error for the workbook when trying to check this function. Workbook is included. This code can be found in form "ShiftPop"

I used it exactly like I use range every time, although normally I don't have a for...next and if in the middle of it.

I can change the name range just keep in mind it is dynamic. The pivot table range I use for a sheet I didn't attach. I was just borrowing since it should be essentially the same range. I tried naming a new range and it didn't fix anything.


The function of it should be:

Any number of events, volunteers, and shifts have been entered using the forms. The "Populated Shifts" sheet is basically a large raw data sheet that other things are calculated based on. When using ShiftPop it will enter the data on a new row for every person. The problem trying to be solved is that sometimes you forget what data you have entered and not entered. So it should check that the exact shift you have entered with each volunteer is not in the "Populated Shifts" already. It should check for each volunteer listed in the combo boxes.

If anything is unclear let me know.

Thanks

[Mordred]

Hi Squirrel, it seems (to me at least) that

Please Login or Register  to view this content.

is where the error is being thrown. Where is

Please Login or Register  to view this content.

I see the worksheet named event but no range named event.

EDIT: The error gets thrown in the initialization of the userform.

[Squirrel]

That error is because there is no data in the form. Add a dummy event and volunteer for it to work correctly.

The range formulas can be found when you look for the Names box in excel.

[Squirrel]

I have added a test event and volunteer. Populate Shift is the button in question. Any help is appreciated. Same code and problem.

[Kelshaer]

Hi,
Please find the attached workbook it is working good.
I have commented the old code lines that were replaced and prefixed them with "Kelshaer" so they will be easy to search for them.
Please let me know how it works and mark the thread as "SOLVED" if it was

[Squirrel]

Thanks.

The error isn't showing up but the code itself doesn't work. In the block of code from above, the point would be that any time you tried to input the exact same data.. IE Same event, Same person, and same times (and only when all 3 conditions are met) then it will kick back with a MsgBox and not add the info.

Could you take a look?

[Kelshaer]

please find the attached.
the duplicate test wasnt working on the original file

[Squirrel]

Great it looks like it will work. Thanks.