Another question professional excel development chapter 5
In the part of the program where (see below) For Each rngSheet In
rngSheetList and For Each rngName In rngNameList how does the program know to
cycle through each cell in the column and the rows respectively?  

I've created a Combo Box inside a sheet based on data from another sheet.
When an item is selected in this list I would like excel to fill a couple
cells with the data that is correlated to this item from the other sheet.
I've been trying for days now. Reading macro tutorials and ...

I have a dashboard sheet with a series of (camera) images that are a
thumbnail image of a chart or graph in my reports. I have written three
macros that change the size of said image to "Large", "Larger" or
"Minimized".

I want to work with files made from a EPROM programmer. The file types
are binary and ASCII HEX. The HEX file I can import into excel with no
problem. I would like a macro that can convert the binary file to hex
data so I can work with it in excel. I searched the web but did not

I am using an excell document that has various color cells in different
columns. Is there a way to sort these colums by color?

Hi -
 I could not get the app input box to either accept a range,
or let the user click cancel to exit the vba sub of which
the code below is a part, until I used the on error 'method'.

I have the following code block:
For x = 1 To 10
  If RowIsBlank(8) = True Then
       Application.DisplayAlerts = False

Dear Excel Gurus,
In C, one can make convenient definitions like;
#define ABC    242
#define NAME    "James Smith"

I need donor names to change by alphabet each time I put in a new name in
Excel 2003, any ideas?

In various cells on a worksheet, I need to capture the information entered
into the Document Properties fields. i.e. I need to capture Title and used
the formula =DocProps("Title") but this returns the error #NAME?
Any ideas??

I have been going around and around with this.  I have finally isolated my
problem as being the insertion formula.  I suspect my problem is the
formatting of either the Indirect, VLookup or the named range.  Is there
something special I need to do to insert these via code?  ...

Is there any way of using a validation drop down in a cell to trigger the
movement of a row of cells from one sheet to another within a workbook?
For example:
On the "Open!" worksheet, range A1:A20 contains various values (text,

I want to use a MultiPage control on a UserForm but I seem to be at a loss
to get it to do what I want.
If I click on Tab2 (page 2 of the MultiPage control) I want code that
selects cell A1 of the Engraving worksheet. If I then click on Tab5 (page 5

I am working on a reporting dashboard and have created a series of dynamic
charts & graphs with conditional Red/Yellow/Green backgrounds and used the
"camera" feature to capture images which I have reduced to 20% their viewing
size.

Is it possible to build a code to remove excel vb module 1, module 2 and
module 3 that I have in my VBA project?
For instance I'm trying to remove module 1 after I execute the macro, I then
execute the macro in module 2 and remove module 2 ...