I have created my first userform.  This form will be emailed to users who are
requesting certain reports.  When they return the form filled with data.  I
want the data to be stored and saved in an  Access DB.  I know you can pass
the data from the form to a worksheet.  However, ...

I'm trying to say "Cell 3 = If cell 1 & cell 2 = 0 then "" else (cell 1 -
cell 2) / cell 2.
But I can't get that to work as a fomula.
help!

Hi! I have written several UDFs that other people use. They dont know it is a
UDF they just use it as a normal function in excel. is there any way to add
some help to the udf? they usually use the list of functions (insert
function) and there they have help for all non udf ...

Hi, I'm having trouble trying to create  macro to copy an entire workbook to
another workbook using VB.   Eventually I would like to be able to have one
workbook open and have it copy to multiple workbooks..  Any ideas on how to
do this?

I've got a problem and I think I know the source but I wanted to check in and
see first if I'm alone and second if I'm not, what others have done to solve
it.
Here's the problem: My employer just rolled out installation of the 2007

I'm working on a macro that brings up a userform, gets the info from
the user, then goes back to the General Module to create a new
spreadsheet based on the user's input. I have the userform working
fine, but now I'm getting an "Ambigous Name detected" when I run the

i´d like to know if there´s a way to, programatically or via a formula,
check if the content of a cell changed, without using an auxiliar cell to
compare.
Tks.

I've created a short macro and I've added a button to the excel toolbar (I'm
using excel 2007).  The macro security setting is set to enable all
macros...but when I open up another excel sheet other than the one that the
macro was created in and try to run the macro.. I get the ...

Hello Group,
I try to set Cell Background-Color with
Range("A1").Interior.ColorIndex=xyz
but does not work while I can read out the value

I have a vb script that currently opens another workbook to populate a
summary sheet, then closes that sheet. Currently i am using:
JournalWkbk.Close savechanges:=False
Which works fine except that if the user already had the workbook open

Workbooks.Open ("H:\Checklist 07-23-07.xls")
   Workbooks("CheckList.xls").Activate
What would be the best way to handle the error if the file does not exist?

Hello group,
how can I call statistic funtions from vba (Histogramm)?

Trying to change these rows to green
Rows(Array("10", "16", "26")).Interior.ColorIndex = 4
but this doesnt work!  Grateful for help.

I need to copy all sheets from one work book to a main wookbook. The main
workbook is already open and it will open the 2nd work book with the tabs i
need to copy from.

I have one excel spread sheet with sheet1 and sheet2, they both only have
columnA,
on sheet1 as following:
tony@yahoo.com