Chart Events...
 

I'm writting a code to import data from a data file and insert the data into
a new worksheet in one specific workbook... The data is then formated... The
worksheet is then named according to selections made on a userform... That
worksheet is then copied and calculations are performed on the data... At
this point, I want a chart to pop up with a yes or no message box, and
depending on the selection, the code should exectute one set of code or the
other...

The chart is already created and is located as a seperate sheet in the
workbook. I activate the chart in my code. The message box command is placed
in the "ChartObject's" event "Activate."

The problem that I'm having is that the message box appears, but the chart
cannot be seen until after the code is finished running. I need the chart to
appear with the message box so that the user can look at the chart and make
the decision yes or no...

Please Help!

Chart Events...
 

try adding a Doevents between the command to activate the chart and the
showing of the box. Make sure screenupdating is not set to false.

--
Regards,
Tom Ogilvy


"JayWes" wrote:

I'm writting a code to import data from a data file and insert the data into
a new worksheet in one specific workbook... The data is then formated... The
worksheet is then named according to selections made on a userform... That
worksheet is then copied and calculations are performed on the data... At
this point, I want a chart to pop up with a yes or no message box, and
depending on the selection, the code should exectute one set of code or the
other...

The chart is already created and is located as a seperate sheet in the
workbook. I activate the chart in my code. The message box command is placed
in the "ChartObject's" event "Activate."

The problem that I'm having is that the message box appears, but the chart
cannot be seen until after the code is finished running. I need the chart to
appear with the message box so that the user can look at the chart and make
the decision yes or no...

Please Help!