Hi guys,

Thanks for the input. This is definitely a work in progress, but is
developing into a very useful tool for my associates, which is my goal.

I have a list of about 350 accounts. In this spreadsheet, I am comparing
what the account currently looks like to another source that dictates what
the account should look like. The environment is very complex and many times
what-you-want does not match what-you-have for very good reasons. The first
sheet in the workbook shows a brief comparison, kind of a go/no-go test. If
it looks questionable, I would like the user to click on the account number
that brings up a more detailed comparison, showing the actual data that does
not compare. The user can make the decision on the needed action, and then
continue.
I expect that we will get about 30% of the accounts with anomalies. 95% of
these anomalies will end up being easily explainable once all the data for
that client is shown. Because of the high number of "hits", I would like the
interface to be precise and very quick. Typing the account number for each
client you would like more detailed information on, then depressing a
button, seems far more work then simply double clicking on a cell and have
the macro move the account number to the client presentation sheet, where
all the data is shown on a single screen. Then with a "Return" button on
this sheet they can go back to the initial sheet.

Now you know What-I-Want and why. The question is, can I have it, and if so
how.

Thanks for any further assistance. It is very much appreciated.



I started working with spread sheets like this about a year ago and thanks
to the help that I have received at this location I have a number of tools
that both reduce the efforts of others and minimizes mistakes. Both they
and I thank you.



Craig


"Jim Rech" wrote in message
...
ON.DOUBLECLICK is a macro function from the obsolete Excel 4 macro
language
that was superceded by VBA in Excel 5 in late 1993. There are a variety
of
good ways to kick off a macro including a tool bar button, an on-sheet
button and a keyboard shortcut. Double-clicking a cell is probably not
one
of them since it has other purposes in Excel.

--
Jim
"C Brandt" wrote in message
...

I have been seeking a way to transfer control to another worksheet,
Bring
data along and populate that worksheet with a single click of the mouse.
It
appears as though ON.DOUBLECLICK may do the job, albeit with a double
click.

Can someone direct me to more information on how to use the function,
all
my
sources bo not give me sufficient data to use it as I am a beginning
user
of
macros.

Any help or clarification will be appreciated.

Craig