Category Archives: Data Validation

No Thumbnail

Excel VBA Drop Down Lists Using Data Validation

In this article I will explain how you can create drop down lists using data validation.   Jump To: Creating Data Validation (Manually) Creating Data Validation (Using VBA) Selection Change Modifying, Adding, Inserting and Removing Items (Usin VBA)   You can download the file and code related

No Thumbnail

Drop Down List Creator (Sample Code and Download)

The following code is a function I’ve written which creates drop down lists. The drop down lists are created using data validation. It is assumed that there is a column with the drop down list values on one of the sheets. Another feature of this

No Thumbnail

Excel VBA, Currency Exchange (Forex) Sheet, (Sample Code and Download)

In this article explain how you can write an excel application to retrieve currency exchange (forex) rates from the website http://finance.yahoo.com/. This application also allows users to select only the currency exchange (forex) rates he/she needs. You can download the codes and files related to this article