I'm a newbie in VBA and this is my first post in this excellent
group...
I already saw Chip's explanation about events - http://www.cpearson.com/excel/events.htm
- as well as many posts concerning this subject but haven´t yet

I was wondering if anyone new a way to create a user prompt that would ask
for user initials when the user opened the workbook.  Then save that
information along with the date if they make changes.  If they don't make
changes then there's no reason to save that they logged in.  I ...

I want to identify duplicate values in column K.  I then want to compare cell
differences on each column/row between the first occurence of a value to
subsequent occurences of the same value.  I want to have a list showing what
the value was in row K, the row numbers they occur ...

I'm registering a UDF function in Excel via Excel4(xlfRegister, ...).
I want to register a simple fonction that just returns a string value
(no need to pass parameters to the function)
The problem is that the function paste dialog always ask for one

I oftern encounter  Alt + F9 , at an end of sub. What does it mean?
Clara

i have a table with some values in a column as follow:
column A  |  column B
---------------------------
text 1       |

I have an userform that I would like to show and be visible for 5 seconds
when opening an Excel file.
I would just like to show the userform for a certain length of time and
would like it to close without any interaction from the user.

I am trying to achieve the following with a vba macro:
Add the values of Rng1 on top of the existing values in Rng2. Rng1 &
Rng2 are the same dimensions. It can be done by copying Rng1 and doing
a PasteSpecial values add command to Rng2. However, it is a

I made the following function from code in John Walkenbach's Excel
2003 Power Programming with VBA.
The problem I am having is when I use this function with an array
formula it returns a #VALUE! error.  I've copied the formula below its

http://office.microsoft.com/en-us/excel/HA102063961033.aspx
Exporting XML data
You export XML data by exporting the contents of mapped cells on the
worksheet. When you export data, Excel applies the following rules to

I have a spreadsheet that I would like an message to appear that says 'Have
you completed the forward cover form' if the value in the cell equals more
than $50,000.  Is there some code for this?
Thanks

I really like the arrow symbols found in the font "WP IconicSymbolsA", say
char(177) to char(191). The thing is they are all horizontal.
Is there an easy way (not computationally intensive) to rotate them so they
point up or down or the opposite direction?

Only at www.medicalschoolloans.com, do candidates get flexible payment
opportunities, low monthly payments, and reduced interest rates.  No
other lender can be as flexible.  Best of all, there are no
consolidation fees.  There is no reason not to consolidate now.  Sign

This maybe a very simple code and I should know this but I am out of
practise as I haven't used code for over a year and a little out of touch.
I have designed a UserForm with lots of Textboxes and I want to drop each
textbox text into various cells on a spreadsheet (mailshot - ...

How would you code a macro in VBA to toggle hide/unhide a serie and its
relative legend in a chart.
I already use spreadsheet tricks to make it, but I need a better solution
(no column hide or #N/A stuff ! lol)