Search:

» Home » Business » Applications » Excel VBA and Excel UserForms Training 1

Company:	OzGrid Business Applications
License:	Feature-limited trial
Version:	1
System:	Win 95/98/ME/2000
Size:	11KB
Date Released:	November 11, 2002
Price:	$75.00
Screenshot:	No Screenshot
Downloads:	23
Homepage:	http://www.ozgrid.com/
Date added:	Sep 19, 2005
Click here to Download

No special software is needed to use - just download, run ,and open Excel. Access from the Excel Tools menu by clicking on the new menu item. Time savings Excel solutions are always just a click away - you even save time by avoiding fruitless Internet searches!

BASIC COURSE OUTLINE:
The Fundamentals of Excel VBA, The Visual Basic Editor, Objects and Properties, Excel Objects , Object Hierarchy, Application, Workbook, Worksheet, Range, CommandBars, Variables and Constants, Data types, Variable Levels, Declaring Variables, Constants, Loops, Types of Loops, Loop Pitfalls, Effective Decision Making, If/And/Or, Select Case, Dates and Times, Workbook and Worksheet Events, Debugging and Error Handling, Prevention, Good Habits, Runtime Errors, Excel WorksheetFunctions in VBA, Specific Examples, Excels Built-In Features, User Defined Functions, Good vs Bad, Arguments, Calculation, Controls, ActiveX, Control Toolbox, Control Properties, Control Parent.

UserForms Introduction, Filling UserForm Controls, Putting Data into our Controls, When to put Data into our Control, Filling a ListBox and/or ComboBox using Loops, Multi-Page Control, Creating a wizard using the Multi-Page Control, Validating the User Inputs, Some Useful Methods and Functions, When to apply Validation, Control Events, Which Controls to use and When, Parsing Control Values back to a Spreadsheet, Parsing range values to the UserForm Controls, Option Buttons and Checkboxes in Detail, True or False, Creating Template Controls, Using the RefEdit Control, Finding the Active Control, Creating Controls at Runtime.

WHY USE US FOR EXCEL TRAINING?
Like all our products and services, OzGrid training will cater to your specific needs. OzGrid specializes in Microsoft Excel, this is all we do! Over time we have focused our business directly towards Excel. Other training companies will offer training in many different Applications, and while they may supply information from good trainers it is very unlikely the trainers will know Excel to the extent we do! Remember we develop Excel spreadsheets in our day-to-day business so we know what you will encounter in your day-to-day use of Excel. We are not just Excel teachers, but also Excel developers!

NEWS

So far, nothing for that!

RECOMMENDED DOWNLOADS IN THIS CATEGORY

» Home » Business » Applications (2278)

Select page: [1] 2 3 4 5 6...

» ProCetus Lite to Professional Upgrade 2

ProCetus is a general purpose 3D FEA (Finite Element Analysis) Structural Design, Analysis and Optimization application software. ProCetus will handle the vast majority of your Structural Civil Engineering Projects in an easy, fast and very competit ...

Procetus.com | 0 | Win 95/NT/2000/XP/98/ME | $2635 | Downloads: 31

Date added: Sep 20, 2005 | » Details

» Canadian Company Search Engine 1.0.1

Gernerate your own sales leads or maillinging list in 1 minutes! CCSE is a powerful search engine of Canadian company information and capable of searching out relevant companies and their contacts instantly in accordance with your enquiry configuration. ...

Bizdbbank Information, Inc. | 1002KB | Win 98/2000/XP | $99 | Downloads: 23

Date added: Sep 20, 2005 | » Details

» Smart Address 2000 4.6

Smart Address 2000 provides powerful Contact Management for single or multiple users across both local and wide area networks. Contact tracking, calendars, personalized mail-shots and e-mails, task management, custom report designer for listings, labels o ...

Oakley Data Services | 6146KB | Win 95/98/ME/NT/2000/XP | $29.00 | Downloads: 24

Date added: Sep 20, 2005 | » Details

» fax@NET Personal 2.5

You only need one ISDN card and fax@NET Personal receives and sends your faxes. The received faxes are received and saved as pictures. You can define unlimited direct call numbers (MSNs) and unlimited email addresses. The pictures can be saved in differen ...

ppedv AG | 4190KB | Win 2000/XP | 0 | Downloads: 34

Date added: Sep 19, 2005 | » Details

» PhoneWorks 2002 - Try&Buy 6.00.71.7

PhoneWorks 2002 is an easy-to-use and powerful telephone, voice mail answering system, and fax messaging solution for your PC. PhoneWorks solves your messaging problems by dramatically simplifying how you read, listen to, and manage your daily info ...

Element5.com | 0 | Win 95/2000/XP/98/ME | $99.95 | Downloads: 34

Date added: Sep 19, 2005 | » Details

» Modem Spy (German Edition) 2.3

Modem spy is handy utility for phone calls recording. Features: 1) records phone conversations. 2) records from microphone. 3) plays back recorded mesages via phone line. 4) Plays back recorded mesages via sound card. 5) Can record ALL incomming phone cal ...

Modemspy.com | 0 | Win 95/NT/2000/XP/98/ME | $24.95 | Downloads: 29

Date added: Sep 19, 2005 | » Details

» EngCalc(Pipe Flow) - Palm Calculator 1.2

Momentous Pipe Flow Calculator. Features..NEW Constant Values.NEW New look Sceintifc Evaluator.NEW Material properties. Mechanical, Physical and Thermal.NEW Periodic chart of Elements.NEW Inplace unit conversion to switch between US and Metric units.FREE ...

3GR Technologies | 1110KB | Palm OS | $14.99 | Downloads: 25

Date added: Sep 20, 2005 | » Details

» OOBOX NEWS HEADLINES 1.02

OoBox News Headlines Web based news dispatches and press releases, brought to you in real time. OoBox News Headlines, ( News Finder) allows you to receive instantly the main headers of : International, National, Economy, Finance, Stock-exchange, Sport, ...

OOBOX | 991KB | Win 95/98/ME/NT/2000/XP/CE | | Downloads: 24

Date added: Sep 20, 2005 | » Details

» 123- Fahrtenbuch (KFZ-Auswertung) 1.5 1.5

With the program, you have travel book the possibility in a simple manner your vehicle specifications, like too according to KFZ flags, manufacturers and model verwa With the program, you have travel book the possibility in a simple manner your vehicle sp ...

T-online.de | 0 | Win 3.1/95Win CE / Pocket PC / | E19.9 | Downloads: 28

Date added: Sep 19, 2005 | » Details

» DBF to CSV 1.30

The DBF to CSV program allows you to convert your dbf files to csv (comma-separated value) format. Generally, you can use any delimiter, such as TAB, semicolon etc. The program supports dBase III, dBase IV, FoxPro, VFP and dBase Level 7 formats. You can ...

WhiteTown Software | 279KB | Win 95/98/ME/NT/2000/XP | $19.95 | Downloads: 45

Date added: Sep 20, 2005 | » Details

» PLUS 2D - Nesting Software [Standard] 2.40

Nesting software for reducing scrap, and generating optimum layouts for cutting in sheet metal layout, fabrication, glass, building panel, woodworking industries. ...

Nirvanatec.com | 0 | | $800 | Downloads: 23

Date added: Sep 19, 2005 | » Details

» Go4Customer Call Recording Machine 1.1

Go4Customer Call Recording Machine records all the important calls to your Hard Disk manually with a push of button. It stores the files in .wav format with time and date and can be renamed by user, it needs is Voice Modem. It can record phone conversat ...

Cyber Futuristics India Pvt.Ltd. | 2662KB | Win 2000 | $14.95 | Downloads: 27

Date added: Sep 20, 2005 | » Details

» PLUS 2D - Nesting Software [Light] 2.40

Nesting software for reducing scrap, and generating optimum layouts for cutting in sheet metal layout, fabrication, glass, building panel, woodworking industries. ...

Nirvanatec.com | 0 | Win NT/2000/XP/98/ME | $400 | Downloads: 32

Date added: Sep 19, 2005 | » Details

» NVN (for Outlook) 2

        NVN for Outlook Version 1.23 Somebytes Developement   ...

Somebytes.de | 0 | Win 2000/XP | $15 | Downloads: 32

Date added: Sep 20, 2005 | » Details

» Eurorechner V1.3 N für Excel 97 / 2000 / XP 1.3 N

Jan 01, 1970 ...

Onlinehome.de | E24.83 | Win 3.1/95Win CE / Pocket PC / | E24.83 | Downloads: 17

Date added: Sep 19, 2005 | » Details

» EZ-Forms ULTRA Filler 5.50.ec.220

- EZ-Forms Filler for eforms (visual electronic forms)- Fillout, Save, Modify, Print, Email, FAX(driver required), DataBase, etc. eforms created with EZ-Forms ULTRA, EZ-Forms PRO Designer. - Network and internet compliant. - Encryption enabled. (user pw r ...

the EZ-Forms Company (EZX Corporation) | 9404KB | Win 98/ME/NT/2000/XP | $149 | Downloads: 21

Date added: Sep 20, 2005 | » Details

» OptiHypo, Der Hypotheken Darlehen Optimierer 1.0.1.2

The program is a comfortable tool to the calculation of a loan and mortgage and offers a simple possibility to the alteration of individual parameters like for example amount of loan, interest, repayment, interest-deduction... In addition, it offers also ...

Epoth.de | 0 | Win 95/NT/2000/98/ME | E15 | Downloads: 18

Date added: Sep 19, 2005 | » Details

» Cub Editor for MS Access 97 97.20

Cub Editor is an MS Access Report formatting wizard that allows MS Access developers, or end-users to easily create or modify attractive report layouts based on existing tables or queries. Cub Editor looks and behaves like the MS Access report wizard, onl ...

Peter`s Software | 595KB | Windows 95/98/NT/2000 | $35.95 | Downloads: 25

Date added: Sep 20, 2005 | » Details

» Proton Barcode Wizard 3.5

No matter what type of printer you use (matrix, laser, inkjet) you can print any number of label for requested barcode. Besides that if your printer is a color one you can have a better visual arrangements like font, barcode and background. You may also ...

Proton Software | 2900KB | Win 98/ME/2000/XP | $25 | Downloads: 34

Date added: Sep 20, 2005 | » Details

» Tiff Compression & Rotation Utility 1.4

Compress tif images with group iv compression and apply rotation to each image if required. Rotate right, left and flip. Excellent utility. ...

Tiff-tools.com | 0 | Win 95/NT/2000/98/ME | $143 | Downloads: 20

Date added: Sep 19, 2005 | » Details

go to top

Select page: [1] 2 3 4 5 6...