Selecting point from chart while executing macro- is it posible?

[peter.jakopic]

I would like to prompt user to select specific point from chart in the
middle of macro execution. Is this posible and how?

 

[mpeplow]

Create a form an run with vbmodeless option this will let the use click
on the excel chart when the form is open. then just refence the
activecell

 

[mpeplow]

Create a form an run with vbmodeless option this will let the use click
on the excel chart when the form is open. then just refence the
activecell

 

[NickHK]

If it is a cell on the WS, then you could use an
Application.Inputbox(Type:=8) .

NickHK