is there a shortway to use the workday (excel)function i a userform?? based on textboxes??
Jack
is there a shortway to use the workday (excel)function i a userform?? based on textboxes??
Jack
Set a reference to the ATPVBAEN project, and then just call it as a normal VBA function.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
im not familiar with this, how does it work??
In the VBIDE, go to Tools>Refernces.
Scroll down the list until you find atpvbaen.xls and check it.
Then in the code use something like
[vba]
MsgBox Format(workday(Date, 12), "dd mmm yyyy")
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber