Error 400: Adding days of the year to a userform

[Jake_C1]

Hi so I'm trying to make a userform for a person to add data to a spreadsheet without them having to go in and actually touch the spreadsheet itself, but I've encountered a bit of an odd problem.

If I run my code (userform) in sheet3, there isn't an issue. It works exactly as it should. However, I'd like for the people doing the entry to see the numbers entered in after they've finished. The problem comes when you try to run the userform in any other sheet (it gives error 400)

Note that sheet3 is holding the days of the year in the first column (They would pick a day, and do the data entry for that day only)

I did a bit of digging into this and I know its stemming from the combo box add in part of the code but I can't figure out why.

I know I could just lock the users to the sheet that does work so that there are no problems but I'd like to avoid that

The errorcatching part of the code tells me (if not on sheet3) "Application-defined or object-defined error"

Please Login or Register  to view this content.

[AlphaFrog]

Qualify each Cells reference with the worksheet.

Please Login or Register  to view this content.

Or just this...

Please Login or Register  to view this content.

[Jake_C1]

That did the trick.

Thanks!