I've got a userform where the user can select an option(checkbox) to
make a chart.
This can only be done after the macro has put al de data in rows.

My problem is that when I activate the checkbox, and not the macro start
button, it begins to make a chart.

Can somebody tell me how to make the macro so that it will make the
chart after all the data is selected.  

thanks in advance,
matthijs
-------------------------------------------------------------
Dinkelaar, M.                  Philips Research Laboratories Eindhoven
Building:                      Prof. Holstlaan 4
Phone: +31 40 27               5656 AA  Eindhoven
Fax:   +31 40 274....          The Netherlands

You provide very little detail on this, but from what I manage to read,
I suggest You assign a macro to the data selection object (whatever it
is) that enables the checkbox if the data input is a valid range, else
disables it. Default value before .show is disabled.

Best wishes Harald