Excel Macros and VBA Tips

Break Excel VBA Password

Submitted by Support on Sat, 07/12/2008 - 20:42

1. Create a new simple excel file.

Submitted by Support on Mon, 06/16/2008 - 15:38

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

Submitted by Support on Fri, 08/14/2009 - 22:06

Ok. Lets assume we have a variable called MyVariableTest which is of the data type string.

below is the code...

--------------
'Code starts below

Sub uBoundVBA()

Submitted by Support on Mon, 01/25/2010 - 23:20

This is going to be a quick tutorial on how would you go about creating a VBA function.

Submitted by Support on Thu, 04/01/2010 - 16:56

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.