Thread: select cell
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tim[_39_] Tim[_39_] is offline
external usenet poster
 
Posts: 71
Default select cell

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