I wonder if someone can help me out, I am looping through a range o
cells using the code below. My question is, when the loop identifies
particular cell in the range that doesnt meet the criteria set out i
my code, how do I go about identifying the cell and for example shadin

I am using the Worksheet_Change event to trigger a macro to run which
performs a calculation.  The calculation of the macro performs immediately,
but it takes about 10 seconds before anything else can be typed on the sheet.

I found this code to search a Work Sheet. I also need a text box and the code
for this box to work. What am I missing?
Sub Find_First()
   Dim FindString As String

I have a textbox that shows a number. I need another text box on the same
sheet to lookup that number and show the corresponding description that
relates to that number.
EX:

How do you create the description of an add-in as it appears from the
popupmenu?  I can create the project name within vbe and add a description
there.  But only the Project name appears in the dialog box, the description
remains mysteriously blank.

Could someone please give a quick definition of the differences between
Get, Set and Let for Class Object properties.
Thanks,
-Abe

I have a worksheet, depending on different choice in a dropdown list,
corresponding range which including a couple of option buttons should
be filled.
Here is an code sample:

To start with, I am creating a string, based on concatenating a large
number of attributes(cells).
Essentially using this formula for that:
=IF(ISBLANK(A2),"",A2&" ")&IF(ISBLANK(B2),"",B2&" ")...

Ah, the fun continues. I really ought to buy the VBA  power programming
book or something.
So here's the current issue. I have a sub in a module that is public
and a command button in a user form that is private, as below.

Hi. I have a makro that displays a userform that can generate a report. The
report is to be created when the user presses a button on the user form. The
report is to be shown in a new worksheet that the program creates. I want the
new worksheet to have certain settings (e.g. no ...

I'm using Excel 10 SP3 on WIN XP Prof. 5.1 SP1
I know how to increase the width of the name box by using
Chip Pearson's "Increasing The Size Of The Name Box",
but I can't find a way to increase the hight.

Hi members,
I am not able to get the values corresponding to selection made i
combo box in excel sheet.
In macro , i am not able to retrieve corresponding values of combo bo

Please help: How can i programmatically lookup the cell adress for nex
non-blank cell in a range?
Toreador
--

I have a workbook with alot of macros. Sometimes (not always) I have
formulas (not always the same formulas) that will not calculate even
though they appear OK. I have to rebuild the dependancy tree
(ctrl+alt+shift+F9) to get them to calculate.

(Using Excel 2000 under Windows 98)
I have created a 1-cell named range by selecting cell A1 on Sheet1 and then
typing the name "MyCell" (without the quotes) in the names Litsbox.
Thereafter, I have typed this code in the click event of a command button