Tag Archives: VBA For Excel

No Thumbnail

VBA Excel Working With Protected Sheets

Jump To: Unprotecting and Protecting the Worksheets Unprotecting and Protecting Workbooks Unprotecting and Protecting the Worksheets: As a VBA programmer you will often have protected sheets where you would like your program to be able to modify but still remain protected from the users. There

No Thumbnail

Searching Data In Excel Sheets

One of the main tasks an Excel VBA programmer encounters is  searching excel sheets for a specific value. While there are many different methods for doing a search, in this article I will only cover the basic method of using a For Next loop. In

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

Referencing Ranges In Excel Using VBA

In this article I will explain how to work with the Range and Cell objects. While the terms range and cells may be used interchangeably, they are two different objects, and have different functions and properties. There are two main notations for referencing ranges: Range(“A1:B1”) notation Range( Cells(1,

No Thumbnail

File and Folder Dialoges VBA

You have probably worked with file and folder dialogues before. Selecting a file to open choosing a path to save the current file choosing a directory path Although it would seem that the dialog itself does the saving and opening, but most dialogues actually don’t do any of that.