Hello can someone help me with this?
When I use the VBA code below, the macro will run when I update the
contents in cell "G28" manually however "G28" is a formula so I want
the macro to run when "G28" is updated automatically due to its

Can I populate my list box with the files named in a sub-directory on my
hard drive, and if yes, when I click on one of these file names can I
open the file programmatically directly from the on click event of the
listbox?

I just instaled excel 2007 and the arrow keys aren't working to move around
the cells. I can only do so by using the mouse. Also, the enter key doesn't
take me to the cell bellow.
Please help me!

I am using a formula to bring back some text about some data.  I am using the
following formula:
=IF(N12>M12,"is larger for girls","is larger for boys"), so that if the data
in cell N12 is greater than the data in cell M12 then it says "is larger for

In meteorology it is the custom to round decimal numbers ending in .5  to the odd. For instance 2.55 becomes 2.3, while 2.35 also becomes 2.3. In Excel they are always rounded up, does anyone know a formulae that will correct this so that they are 'thrown' to the odd.
TIA
Lonnie

I have created a form using vba in excel to input data into the database.
I have also managed to delete, using the multi-list form to select and
delete a database.
Using VBA:

I have a large amount of data on a worksheet.. basically I want to record a
macro so that each time I open the workbook it will filter out what info I
need and perform a basic count of the rows of info there.

I have a sheet with raw records from a telkom company that lists the
SIM card phone numbers, name of the user, SMS usage etc.
Like this:
Record#  SIM#   User   SMSusage etc.

I am trying to do the following:
There are two sets of supplier lists - A List and B List. I need to
compare the two lists. Source A is my master. Source B is a subset of
that but has contact information for all the suppliers. Hence, my goal

I have sheet with 2 columns and 1200 rows.
Column A is numbers 1 to 1200
Column B is varying length text strings.
I wish to paste different longer text strings into column C and then

I want to create a time clock in excel, så my employees can punch in
and out.
Any suggestions on how to do this?
There must be password protected cells (so another employee cant punch

I have been using the Form in Excel for sometime.  Today, I have a new
problem I have never seen before.
When I try to add a new record by using the form function (Data - Form), it
has an error message that "Cannot extend list or database".  But the

How can I insert an array or range of variables (e.g. .042 to .168) into a
formula? Alternatively, can I define variables (e.g. x, y) without having to
use Visual Basic?
I'm trying to create a chart which outputs values based on constants and a

Group'
I am using excel 2003 and when I make a new workbook, I typically make a
spreadsheet then copy it, rename it and continue this several times. The
spreadsheet is used to track data from laboratory experiment results. The

I am using Excel 2003 and would like to do the following:
I have one file that I’d like to use as a list that all other files within
this project would refer to; this file is simply a list of billing reasons.
Within the multiple (~30) other files I would like to be able to use a ...