Use function from Excel : Excel Buildin Function « Excel « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Excel
  3. Excel Buildin Function

Use function from Excel

 
Sub from()
     MsgBox [MOD(TODAY(),7)]
End Sub








Related examples in the same category

1.Payment Function:Pmt (interest, term, principal, future value, type)
2.Using Excel Application Functions in VBA
3.Cleans up every selected cell: with Proper function
4.Calculate a moving average
5.Sum a Range
6.Call worksheet function directly