How to Create A Linkable Hot Image
You might have noticed that some Web sites feature an hot image map to help navigate the site. An image map is a single image, but it’s sensitive to the location at which you click it on hot area. This tip demonstrates how to create a linkable hot image.
Get A Specific Element In The Text String With VBA
Often, data is stored in a single worksheet cell consisting of several values, separated by some delimiter. For example, a cell may contain Abby,Barb,Carrie,Dawn, a list of names separated by commas. How should we get a specific element in the text string?
Free Excel Tool – XLLoop
XLLoop is an open source framework for implementing Excel user-defined functions (UDFs) on a centralised server (a function server).
Excel Tools
Free Excel Tool – XLLoop
XLLoop is an open source framework for implementing Excel user-defined functions (UDFs) on a centralised server (a function server).
Free Excel Tool – VB Template Engine
A compact template engine which written in VB, it uses a simple syntax for template variables and blocks, supports nested blocks and is implemented as a single code module.
Excel Articles
How to Create A Linkable Hot Image
You might have noticed that some Web sites feature an hot image map to help navigate the site. An image map is a single image, but it’s sensitive to the location at which you click it on hot area. This tip demonstrates how to create a linkable hot image.
How To Highlight Entire Current Row And Column In Excel
This article describes how to highlight entire current row and column in Excel, also you can customize the highlighting color.
Getting Coefficients Of Chart Trendline
This article describes how to create formulas that generate the trendline coefficients in Excel’s Chart. You can then use these formulas to calculate predicted y values for give values of x.
How To Create A Splash Screen For An Excel Workbook
This article describes how to create a splash screen for a Excel workbook. A splash screen appears when the workbook is opened and disappears automatically after a specific time has elapsed.
VBA Functions
Get A Specific Element In The Text String With VBA
Often, data is stored in a single worksheet cell consisting of several values, separated by some delimiter. For example, a cell may contain Abby,Barb,Carrie,Dawn, a list of names separated by commas. How should we get a specific element in the text string?
How To Get The Data Type Of A Cell In Excel
In some situations you may need to determine the type of data in a cell. Excel provides a number of built-in functions that can help. These include ISTEXT, ISLOGICAL, and ISERROR. In addition, VBA includes functions such as IsEmpty, IsDate, and IsNumeric.
How to Determine The Type Of A Particular Drive Using VBA
This article contains a VBA function that uses the Windows GetDriveType API function to determine the type of a particular drive.
How To Get The Computer Name Or Logged-in User Name Using VBA
This article uses two Windows API functions to return the name of the computer, and the name of the user who is currently logged in. These functions can be used in a worksheet formula, or called from a VBA procedure.