I am sure this is a simple problem for the experts out there.  
I have a workbook with x number of worksheets.  All of the sheets hav
data.  One of the sheets is called summary.  When the user has update
anyone of the sheets (other than the summary sheet) and then saves an

I thought this would be in the old posts but I am running out of time to look so...sorry if this is already posted somewhere.  I have cell A1 with my start time, B1 has my finish time.  Both are formatted in military time.  I want cell C1 to show how many hours I worked.  What ...

I use a userform to add new rows in a table but I get an error:
"User-defined type not defined" and I can not figure out the problem. I?m
using the following code and the error row is marked *.
Private Sub CommandButton1_Click()

=IF((A2-A1)>1,"Missed " & TEXT(A1+1,"mm/dd/yy") & IF((A2-A1)>2," - " &
TEXT(A2-1,"mm/dd/yy"),""),"")
I tried that, but it didn't work...:( ...If you have tried and tested
this formula, could you please email me a have a sample book? Thx

I would like to colour a cell based on 4 different
criteria. eg: if cell A1=1 then red, A1=2 then green, A1=3
then blue, A1=4 then purple and of A1 is blank then no
formatting. Can anyone help?

Worksheet_Change(ByVal Target As Range)
Worksheet_SelectionChange(ByVal Target As Range)
I want to trigger code if a single cell changes, which is the best event?
I would also like to read more on these or similar sheet events but really

I have seen Excel sheets with hidden rows where there are +/- buttons in the
left column that allows you to easily hide/unhide the rows (columns).
How is this done?

i am suppose to read a value from an Excel Spreadsheet then print th
value in Citect page.
whenever i try to print the value in Citect, it appear to be blank.
i believe Citect is not reading from the Excel spreadsheet.

Hola Amigos:
Tengo un problema al querer sacar promedio ponterado con numero de cursos
distintos y para lo cual te adjunto el modelo.
Pero quiero con formulas REDONDEDAR - SUMA - DIVIDIR - CONTAR U OTRAS MAS

Did a spreadsheet on my palm.  Hot sync'ed to desk top and can't open the
document on the desk top.  Am very much the novice/rookie at this.  Any help
would be welcomed.

Is there a formula that will display the Sheet name in a cell?
Thanks
Ruan

Can i put in a formula to subtract one date from another and show the period
between in days, weekks or whatever.  It is to calculate someones service
with the company.  It is many different periods spanning 30 years.
thanks

SORRY FOR THE LENGTH OF THIS POST!
I am having a problem that I hope I can get resolved here.
I created a file that the user fills out and enters the information.
This file is saved in a folder named for example 091604.

Someone once showed my how to do this but I can't remember
the shortcut. It shows formulas on the screen instead of
having to go to the formula bar and look at each cell.
THanks

I am use to add a two dimensional array to a combobox to
populate it, like this combobox.list=array(). In Excel I
couldn't do that, the combobox only has the ListFillRange
property.  Is there a way of doing this without using the