Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Selecting point from chart while executing macro- is it posible?

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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Selecting point from chart while executing macro- is it posible?


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
------------------------------------------------------------------------
mpeplow's Profile: http://www.excelforum.com/member.php...o&userid=34812
View this thread: http://www.excelforum.com/showthread...hreadid=567064

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Selecting point from chart while executing macro- is it posible?


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
------------------------------------------------------------------------
mpeplow's Profile: http://www.excelforum.com/member.php...o&userid=34812
View this thread: http://www.excelforum.com/showthread...hreadid=567064

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default Selecting point from chart while executing macro- is it posible?

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

NickHK

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Selecting a point on a chart in Excel 2007 on Windows 7 Kirill Charts and Charting in Excel 1 April 17th 10 07:22 PM
Get chart point value macro joecrabtree Charts and Charting in Excel 5 November 23rd 07 04:24 PM
how to turn of a series in data sheet of a power point chart using macro chepyalarr Excel Programming 1 February 2nd 06 07:06 PM
Import chart to Power Point and Macro problem Woody13 Excel Discussion (Misc queries) 1 December 8th 04 05:47 PM
selecting a picture within a chart via a macro Walshy[_3_] Excel Programming 1 October 21st 04 10:32 AM


All times are GMT +1. The time now is 04:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"