User login

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.

Bookmark/Search this post with:

How to do vlookup Using VBA?

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.

Bookmark/Search this post with:

VBA function?

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.

Bookmark/Search this post with:

Learn How to use VBA uBound in Excel

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()

Bookmark/Search this post with:

Convert time to a serial value in Microsoft Excel

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

Bookmark/Search this post with:

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
Spreadsheets for Dummies