home | about me | vba tips | downloads | cell masters | help forum | links | consulting | Japanese

automate your work using Excel - JMT Excel Consulting  

VBA Tips

    you can read the new tips with this RSS feed.  -   last updated: Sat, Feb 03, 2007
 
 speeding up your macrothis icon stands for a tip for speeding up your macro!


Arrays

AutoFilter

Class modules

CommandBars

Controling other Office applications from Excel

Data Validation

Files / Network

Format

Formulas Tips

Range

Userforms

Visual Basic Editor

Web

Window

Workbooks

Worksheets

ETC


JavaScript for VBA coders

This page assumes you've some basic background, such as A general understanding of WWW and good working knowledge of HTML. Some programming experience with Excel VBA(Visual Basic Applications).
JavaScript is a vary compact scripting language(object-based) for developing client and server Internet applications. If you've already know Excel VBA, learning JavaScript is NOT so hard.
The objects between XL and Web browser are different, but basic syntax and statements are very similar. From the following table, you will learn how to write JavaScripts code like writing VBA code. :)
Please Note: To send the VBA code in to your VBE, please change your Security settings about ActiveX controls. On main menu bar of IE, select Tools > Internet Options > Security Tab > Custom Level > Download Unsigned Active X controls > Enable


 Comment out This sample code is an example how to comment out.
* Excel VBA  * JavaScript 

 Variables This sample code is an example how to declares a variable, assigns a value to it.
* Excel VBA  * JavaScript 

 If...else statement If...else statement sample code.
* Excel VBA  * JavaScript 

 IIf Function IIf Function sample code.
* Excel VBA  * JavaScript 

 For Next statement For Next statement sample code.
* Excel VBA  * JavaScript 

 While...Wend Statement This is a sample about how to write While...Wend Statement
* Excel VBA  * JavaScript 

 Exit Statement This is a sample about how to write Exit Statement (EG.Exit For)
* Excel VBA  * JavaScript 

 Function This is a sample about how to write Function and the argument.
* Excel VBA  * JavaScript 

 With Statement This is a sample about how to write With Statement.
* Excel VBA  * JavaScript 

 Array This is a sample about how to make array.
* Excel VBA  * JavaScript 
 To be continued...
  All contents Copyright ©,Colo's Excel Junk Room  Reloaded  counter  times since June.1st.2002