i'm not very good at these things, but a RefEdit control would work i
think - especially if you need to navigate about the workbook when deciding
which cell needs selecting (which could go onto your userform if you have
one)

"divid wells" wrote in message
...
is there any way i can moniter the next cellwhich is
selected ? It occurs inthe midle of a macro and the user
needs to select a cell by clicking on it, and the value
of that is used in the rest of the macro.

this can either be done with a vba macro or a userform
but im guessing the code will all b the same.

Thank you for youre help