Got it Dave, and it does me fine...........thank you most kindly.......

BTW.......what does the Type:=8 mean, and are there other choices?

Vaya con Dios,
Chuck, CABGx3



"Dave Peterson" wrote in message
...
Dim myCell as range
set mycell = nothing
on error resume next 'cancel will cause an error
set mycell = application.inputbox(Prompt:="select a cell",
type:=8).cells(1)
on error goto 0

if mycell is nothing then
msgbox "You didn't select a cell!"
else
msgbox "You selected: " & mycell.address(external:=true)
end if



CLR wrote:

Hi all.........

I would like to select a sheet (no problem there),............ then I
would
like a msgbox to pop up telling the user to select a cell (no problem
there),.......... then I would like for the macro to pause until the
user to
selects a cell.......and then for the macro to continue to run using
that
cell as the selection.

TIA
Vaya con Dios,
Chuck, CABGx3

--

Dave Peterson