hi all,
is there a way to use wrokday function in my worksheet controls.?
i have a date time picker in my worksheet and a text box and a button.
on click of this button i should get next desired date.
like when i select a date from the calendar and click on button there is onclick function in my macro.
this onclick should calculate next desired date(assume if i choose 10/11/2005 and add 2 to this date i should get 12/11/2005)
i know how to use workday function using a cell reference. but................
i don't know how to put this into a vba code.
if i use workday("10/11/2005", 2) i get sub or function not found error message.
Please Please help me out to solve this problem.
Bookmarks