I'm trying to combine two worksheet event changes or at least get both to work somehow....

Hi krosenest and welcome to the forum,

Try changing the ByVal to ByRef and see what happens.

Ok - On Change is different than On Selection Change.
To trigger an On Selection Change you simply need to click in that cell... I'd suggest your DTPicker code look like...

Please Login or Register  to view this content.

Change my MsgBox with your picker code.

Having multiple Events for the same sheet isn't a problem if your code is correct.

In looking at your top code I don't see why you want "multiple items in the same cell". Are you doing the multiple items from a list control?

In short, I guess I need to see a sample of the worksheet to understand the problem and then I can step through the code with the sheet and try to help more.

I don't have DTPicker on my machine but you should only need to have a single one of them open up. When you close DTPicker you will put the selected date back in the Target cell. This will reduce your long second sub of code.

Selection_Change is triggered when you click or move to a new cell. Change is triggered when a value is changed in a cell on the entire worksheet.

You can use the Change trigger and test to see if it is in either range like:

Please Login or Register  to view this content.

The above tests two different ranges for a single Worksheet_Change event. Does this help?

As for multiple DTPickers, I remember building a single UserForm and putting a single DTPicker on it. The code would open that Userform which would open the DTPicker. When the Userform is closed the value of the DTPicker is put back in the Target Cell. I don't think you need multiple DTPickers on your sheet and can reduce your code using a single one on a UserForm.

OF COURSE, all this takes some VBA user knowledge/experience (which you are gaining).
See if this helps http://www.office-forums.com/dtpicker-t1984552.html

So here is the deal. Because the Event is a Worksheet_Change, you need to change something for it to trigger. If you put your cursor in one of the cells defined for the DTPicker (Try C2) and type a simple space and then hit enter, you should see the DTPicker message box.

In the code before I had the DTPicker tied to a Worksheet_SelectionChange event which triggers whenever you simply click on a different cell on that worksheet.

Here is the bible on Events http://www.cpearson.com/excel/Events.aspx (Microsoft Sites are more exact but this is a great start)

Do you want the code to be run when you click on a cell (Worksheet_SelectionChange) or when the data in a cell is changed (Worksheet_Change)?