I HAVE AN ACCOUNTS PAYABLE WORK SHEET.
IN COLUMN G ARE THE DATES THAT A PARTICULAR PAYABLE IS DUE, i.e. 30-APR.
IN COLUMN H ARE THE AMOUNTS DUE FOR A PARTICULAR ACCOUNT, i.e. $1000.00.
IN CELL F62, I NEED A FORMULA THAT WILL SUM UP THE TOTAL AMOUNT DUE ON

I have a table1 on one sheet such as this
1   Text1   0.10   0.30   0.50
2   Text2   0.20   0.40   0.60
etc

At http://www.excel-vba.com/v-forms-controls.htm
I have followed instructions... my code on the form is below but it won't
run... I've marked the error...
Can anybody give me any help with this?

Good afternoon everyone,
Using Windows & Excel XP
I'm having a problem with the =VLOOKUP function.  In the help section it
says that it searches for a value in the leftmost column of a table.  What I

I'm trying to conditional format some cells. I want to change the color of
the font after a certain amount of days. The cell is a date I need it to
change after it is >4 but <6 and to change again when it >6. If someone
could helpit would I would be greatfull.

Need to calculate the difference between two cells in a column. Exemple
    A                  B                             C
Start 1          date/time                  
open            date/time              

Hi to All,
Hi,
I want to do a double vlookup, where I want to bring back
cost_of_sales to sheet 1, if the location and item# from sheet 2

I have a problem with a formula in wich I like to add up an amount of
hours to a date/time value.
Please find below an example of what I am trying to do.
Value A1: 15/03/2005 22:00 (dd/mm/yyyy hh:mm)

I would like to build a sort macro that allows a user to click on the
column header(like a hyperlink) and have the excel spread sheet update
to that sort.  Instead of the user going up and using the tool sort
function.  Similar to how microsoft outlook would update the sort when

I'm a new user and need help.  I have a column with dates of birth (xx/xx/xx)
and want to know the age (in years only) that each person will be by the end
of 2010.  Then I want to indicate "yes" if they will be 65 or older by that
time.  Thanks!

I know that in Excel 2003, it is possible to protect a worksheet making it
possible for a user to change FORMATTING but NOT CONTENT.  Is this a new
feature to Excel, Starting with 2003?  I just tried to do the same thing in
Excel 2000 and I don't even see the option .  Is it "ALL ...

I have been presented with 13 numbers and  given a total for the sum of
5 of these numbers. Will excel allow me to find which 5 of the given
numbers add up to my known total.

Column J contains dates in some cells, and text in others.  I need to count
the number of cells in this one column that contains dates.  How can I do
this?

When I click Ctrl+End,  Excel takes me to row 8000+.   The actual end of my
worksheet is AN381.
How do I reset the worksheet so that all the 'empty' rows no longer show up
as part of the worksheet - so that when I click Ctrl+End, it takes me to the

Const Value1 as long = 5
Const Value2 as long = 12
Const Value3 as long = 7
For i = 1 to 3