I am trying to create a macro that would change a cell to the current date
and time when any of cells L17:L89 values change.  If they are deleted,
that's fine, just when they change to something else is the key.  The cells
contain yes/no and unsatisfactory/satisfactory answers ...

i need a code wich will change the collour of a cell when the user enter the
word "off".
so when he enter "off" in c5 i need c5 to turn bright yelow..
(will this go in the worksheet change?)

I'm creating a list of notes within excel. Due to it's nature, it will be
very long, and also constantly updated with input from others. What I'd like
to do is this:
Setup Column A so that all cells in Column A become a row #, one after the

I am in need to of worksheet function modification.
I've been using the countifs for a verification process, and it's gotten to
the point where it's more frustrating then it is helpful.
The main problem is that I need to use one column for my criteria range that

Hi
I have three columns (Item, Total, Name), the below code goes to item column
then put autofilter, after that selects Business from the item column , item
column contains Business, Sales, Scrapes etc..., till here its working fine

First off I have run dcomcnf and configured it
Second I have enabled VBA programmatic trust from within XLS.
http://www.codeguru.com/forum/printthread.php?t=383912&page=3&pp=15
http://support.microsoft.com/default.aspx?scid=kb;en-us;282830&Product=xl2003

I am making a user defined function in Excel that takes an unlimited amount
of ranges as input. How shall I do this?
I have figured out that a one range function could be as follows:
Public Function MySum(MyRange As Range) As Double

I am trying to set up a multi-select ListBox on a form that will list all of
the sheets in a workbook. I can get all the sheet names picked up, I just
can't figure out how to place them into the ListBox.

I am making a workbook to track my spending
this work book is comprised of four sheets
"sheet1" is used to enter raw data as money is spent
"sheet2" is a category sheet used to populate a drop down menu in the

I am trying to write code to open a file that has a known password.
Coudl you help me over this hurdle?  Here is the file path and
password.
Name and path = "G:\DPE-IPE\DPE REVISIONS\New Dpe.xls"

I have an excel sheet where column A is numbers and B is text.
Is there a formula I can use to search column B for a specific text
and then return the the number in column A?
Ie, I want to search in all of column B whether any of the cells says

I have several TextBoxes numbered 1 thru 200.  The code in each of
these TextBoxes is the same except for a reference to the TextBox
number.  
Example:

I have a macro that imports data from another application.  I would like to
display the message "Please Wait While Excel Imports Data" instead of just
displaying the hourglass.  Is this possible and if so how?
Thanks in advance.

I have a client that requires that I give data separated by commas all in the
same cell. The problem is that the data is numerical and no matter how I
change the formatting it doesn't hold.
Ex. the data that I need to give the client is 1225,1278,12 just as it is

I have a macro to calculate the time ...
Col A - Start time
Col B - End Time
similarly, I have Col C , Col D , Col E , Col F......... ( Start Time