I made this great UDF and it works fine but, I can't work out how to get the
tooltip to work. Example if you type  =IF(  into a cell, tooltip comes up
with,  logical test, value if true,value if false. How do you make a custom
tooltip for a  UDF?

I have the following ...
.Offset(3, 0).Value = "For " & P & " numbers there are " & Format(tly,
"###,###,##0") & " x different values of " & cmb & " numbers. "
... which includes figures upto and including millions.

How do I Remove/Delete duplicate rows based on row value not column value?  I
can't base it on Column value because some cells in the column might be the
same value but the over record may be different.  I need to be able to delete
actual duplicate rows.

Good morning.  A couple of weeks ago, someone from this forum, was very
helpful in my question on how to unprotect protected worksheets, with similar
passwords, with a macro.  Below is a copy of the VB script I was given.  It
worked but then I realized, the password "hi" is now ...

Say I have this in column a starting at row 1:
12
34
14

As I said before, I left my VBA programming book at home.  So I'm
flying blind.  Sorry for the rudimentary questions.
How do I display the cell name with Msgbox?
For example (pseudocode):

Am I correct in thinking that I can't do a data validation list, where I use
Indirect to refer to a cell that contains the name of a dynamic range in
another sheet?
Thanks in advance,

For example , there is two textbox and one command button.
If i press the command button the text entered in the first textbox
will find in xlworkbook and shown in second textbox with a msgbox ?
All sugestions are welcomed.

Can't seem to get a handle on this.  How would I test, in VBA, if the
toolbar "My Tools" exists?  Any help appreciated, in the meantime I'm going
to keep hammering away.
-gk-

I have a template I have used for years but the problem is everytime you fill
the cell up you have to stop, go down to the next cell and continue. Is there
a way to make it auto enter to the next cell when the range you are typing in
is full?

I have a 3 column list box.  Columns 1 and 2 are very small, 3 or 5
characters only.  The 3 column is much longer.  Is there a way I can adjust
the first two columns so I don't have all this dead space?
Thanks,

Excel 2003
On either a weekly or fortnightly cycle, I have to check against a
master register of file names, files that may or may not exist in two
separate locations on a shared drive, and flag up files that should be

Sheets("sheet1").Copy
This line of code copies the sheet1 to a new workbook useing the
default template. Is there a way to put into the code and tell excel
which template to use.

In calculus, we were discussing the simpsons rule.  Can you please explain to
me how you would set it up for use using excel spreadsheet program.

I am trying to set up a command box that will do two things conditionally if
clicked.  First, I want to run script that will validate that text is
present in a range of cells (all cells must have text values, although the
text values may vary).  If all of the cells in the range ...