XyoTech's instructor team is the most experienced in the business. Each instructor is an expert in their field, having taught in both industry and academia for many years. All XyoTech Spreadsheet & VBA courses are available in both Excel 2003 & 2007.

Engineering Analysis and Automation using Excel & VBA shows you how to use Excel & VBA to increase your performance & productivity, saving your company time & money. You gain valuable knowledge & your company will be light years ahead of the competition. Download Brochure

XyoTech is an engineering training, consulting, and application development company dedicated to providing your organization with the training and tools you need to stay competitive.

Engineering Analysis and Automation using Excel & VBA shows you how to use Excel & VBA to increase your performance & productivity, saving your company time & money.
 
VBA Tips PDF Print E-mail

Each month, you will receive a new VBA tip. You will also receive updates on our courses and have the option to contact our instructor team with questions about your projects.

 

Learn many great time and money saving tips about VBA and Excel. Here is an exerpt from our tip on Circling Invalid Data:

 

It is frequently desired to visually indicate that the value of a cell is outside the anticipated or normal range established for that cell, without restricting its value. There are several methods to accomplish this; however, one unique way is to have Excel automatically draw a red circle around the cell if it contains an “invalid” value (as defined by the user). This method requires some Visual Basic for Applications (VBA) programming, as well as some familiarity with the Data Validation feature of the worksheet.

 

Each tip comes in pdf format with step-by-step graphics showing you how to make it work for you. You can save the pdf to your computer for future reference and share it with your colleagues.

 

Sign-Up for XyoTech Engineering Associates' VBA Tips today!

 

We will not sell, share, or rent your e-mail address. Please see our Privacy Policy for details.

 
 
Next >
[ Back ]
Excel Tips & VBA Tips

Receive Free Excel & VBA Tips Each Month by Joining our Excel Tips & VBA Tips Newsletters! CLICK HERE to Sign-Up Today.
Contact XyoTech

(949) 340-0608 Telephone

(877) 234-7586 Toll Free

(949) 625-7623 Fax

 
Instructors: List Your Courses

All engineering experts with developed short courses are encouraged to list their courses on a non-exclusive basis with XyoTech Engineering Associates. We regularly advertise our courses to a wide range of engineers giving you great exposure at no cost to you. Call us today for more information at 1 (877) 234-7586.