Have a look in vba HELP index for INPUTBOX or MSGBOX

--
Don Guillett
SalesAid Software

"mark" wrote in message
...
Hello.

I would like the user to be able to click on a cell in a sheet to tell the
program where something is.

1) Click a command button to start the program
2) Ask the user where the first sheet to work with is
3) Ask the user where the second sheet to work with is

I'm thinking it would work something like the little ranger finder icon
that
you use to define a consolidation range or a Pivot Table's input... or
something like that. But I don't know how to throw up that dialog box to
let
the user click on a cell or highlight a group of cells, and then continue
on.

Can someone help me with just that piece?

Thanks.
Mark