Hi All,
I have a userform with a number of controls on it, one of which is a DTpicker.
I'm trying to automate things so that the date selected on the DTpicker is pasted into a particular cell on a hidden worksheet.
After searching through the various Excel vba forums, the only way I can get the date pasted into the cell involves the hidden worksheet
firstly being unhidden and the particular cell then being selected before the paste action occurs.
I really need this to happen with the hidden worksheet staying hidden - does anyone have any suggestions?
Any help appreciated.
Cheers
Bookmarks