1. Create a new simple excel file.
To covert time into a serial (numerical) value, enter in cell A1: 2342 (this represents the time 23:42)
Enter the following formula in cell B1: =(LEFT(A1,LEN(A1)-2)&":"&RIGHT(A1,2))+0
Ok. Lets assume we have a variable called MyVariableTest which is of the data type string.
below is the code...
'Code starts below
This is going to be a quick tutorial on how would you go about creating a VBA function.
If you want to use any Excel function in VBA all that you need to is to use "worksheetfunction" statement follwed with the name of the function.
Could't find a solution? Ask the experts in our
excel to pdf .net
excel to pdf C#
Code/Templates/Informaiton provided on this site are without any liabilities. Owner of this website in no event will be held reponsible to damages resulting by using the code/templates/applications/Copyright © 2003 xlMacros.com - Learn Excel VBA Microsoft Excel is a U.S. registered trademark of Microsoft Corporation
Excel for Dummies