I have created a form to enter data into a worksheet.  Colum 'F' & Column 'H'
are formatted in custom h:mm.  In column 'I', I want to put this formula "
=SUM((F2+H2)*1440)/60" (I think.) for every record added through the form.  
Column 'I' is not on the form because columns F & H ...

I have a textbox on a userform and I want to be able to display text in the
textbox in different formats.  (ex. The first word is red, the second word is
Bold black, and the trid word is blue)  Is this possible?
I am working on a translator program that need to 'mark' certain ...

I hope this message finds you enjoying your day.  I'm having some trouble
comparing time with the now() function.
Normally, if I type in
=9:00 AM > 10:00 AM

I need to create a conditional lookup depending on what is put in a cell. I
have managed to solve this with an array, however this needs to happen for
more than one cell so is there anyway to know which the last updated cell in
a column is? As this will allow me to change the ...

Quck question I hope.  Using Excel 2007 - Is there code to process a Save as?
I need to include the statement to save a file as the valus contained in
cell AE2 (This is a constant).  I copied and pasted while recording - however
now it saves all files as the value that was in ...

Running 2000 - here's what I'm trying to do.  I want an input box to appear
when the file is opened, prompting user for a date.  Once they enter a date I
to search column A for the matching date then set the active cell to that
cell.  I also want it to make sure they enter a ...

I have a huge data in my excel I need to delete, I have an identify
formula, countif, for the data in column B. I wish to delete the
repeat one, and the result in countif would be larger than 0. How I
can write a vba code to delete the result in column A large than 0?

What am I doing wrong?
For lfor = LBound(Merch(lfor, 0)) To UBound(Merch(lfor, 1))
   Merch(lfor, 0) = Cells(lfor, 1)
   Merch(lfor, 1) = Cells(lfor, 2)

I have a column of data and each one of these email address in this column
has a space at the end of it.  I have used the "Clean" and "Trim" functions
to eliminate the space at the end.  I am at whits end with this one.  I have
even done a find and replace to find " " with "".  ...

I was wondering if anyone could point me in the right direction on a few
questions I have. I would like to evaluate the value in a cell in a
column and if it is within a certain range write a value to a new
column. I would like to do this for and entire column? Meaning write the

I have hundreds of formulas on multiple spreadsheets and each has the
possibiltity of dividing by zero and creating an error in the cell. Is there
code or a function to eliminate all of the error messages in all cells
without having to change each cell's formula?

I created the following module by doing a macro record.  It works by running
it within the module but when I put in a project, I get a 1004 error on the
range select.  The xls file is visable while I am stepping (F8). I even did
a call statement and get the same error and change ...

Good day all;
I am not sure if conditional formatting can do this but I want to select my
entire sheet and state that;
IF any cell in Column X is >=30 then highlight corresponding Row (yellow)

I was checking the web (and found nothing) for a macro that would allow me
to print multiple workbooks, a bit like with the "right-click/print"
function in MS Explorer. This function has however two drawbacks:
- prints only the first worksheet (and not the total workbook)

I created a file a few days ago using excel 2003 and had formatted
some cells for percentage.  When I typed .5 the cell would display
0.5%.  I emailed the file to myself to edit on another computer also
using excel 2003 and today when I type .5 the cell now shows 50%.