Not sure why the code failed but after clicking the command button on the user form that is responsible for inserting the date (value) no value would appear.
The text box remained empty and I receive the same response when I used the cell. Maybe I missed some small character or something...
The problem was simple...Unfortunately it was ALL ME :)
I was using the actual cell E5 instead of (5, 5)
Gerry thank you very much your reply was perfect everything is working as it should.
I really can't thank you enough I spent a lot of time being bull headed yesterday trying to figure it...
Trying to assign a cell reference for the user value selected in DTPicker. The code works when I use Active cell but I want to assign the DTPicker.value to a specific cell or object in my worksheet and I also want to allow the user to manually enter a value should they wish too in that object or...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.