Runtime error 1004 when selecting row numbers

Hey there!
I'm trying to make an issue log for emails which is as efficient to complete as possible.
I've now created combo boxes to auto fill for 3 data validation lists and have inserted a date picker into the first column.
I was originally having an ambiguous name errors until I sandwiched the code from one action into the other.

It's now working as intended except for 2 issues:
1. When I try to select the row numbers I get "runtime error 1004 - application defined error or object defined error." When I attempt to debug it highlights text in the VBA related to the visibility of the date picker.
2. It is creating some memory issue after being used for a while which makes it take some time for the drop downs to function.

I am very much a newbie to this world though I suspect it might be something to do with the worksheet not being well defined.
Any help identifying how I can fix my code would be wonderful!

Please Login or Register  to view this content.

- PLR

Hi, newbie or not, welcome.
The code tells many things but not what you have, I would suggest to attach the file with non-sensitive data , a small sample is enough WITH the macros and explain clearly which date picker you're using.
It's probably something you need to check, if the cell value is not a date or so. This version 2008? MAC?

Hi there, sorry for the late reply, this project became a bit sidetracked, but it is important so we're picking it back up.
I'd appreciate any help I can get on this one.
I've attached a version of this spreadsheet with non-sensitive information.
I'm unsure where the date picker came from unfortunately as it's been some time.
It is also the 2008 version of excel.

Doesn't work here either, missing ocx control and I'm not adding datepickers to my system.
Maybe it's on your system in an addin or what ever.
Sorry