Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling curve-line feature at run time
I want to put a button on a sheet that (a) executes the inbuilt procedure for
drawing a curved line (as on toolbar drawing - autoshapes - line - curve) (b) let the user defire the points for the curve and when finished (c) have the code format the line. I have the code calling the function but I don't know how to tell the procedure to stop and wait for the user to finish drawing the curve before it runs the formatting code. Any ideas how I trap this event? -- Oxfordshire, UK |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling curve-line feature at run time
You would have to do it through the InputBox method where the user enters
their parameters or with a UserForm where the user would select from a set of preset parameters. In either case the parameters can be collected into a variable that can then be used to trigger the funtion for the curve. "Broadband Al" wrote: I want to put a button on a sheet that (a) executes the inbuilt procedure for drawing a curved line (as on toolbar drawing - autoshapes - line - curve) (b) let the user defire the points for the curve and when finished (c) have the code format the line. I have the code calling the function but I don't know how to tell the procedure to stop and wait for the user to finish drawing the curve before it runs the formatting code. Any ideas how I trap this event? -- Oxfordshire, UK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change color of curve line as time changes | Charts and Charting in Excel | |||
Error bars, curve/line of best fit, axis help | Charts and Charting in Excel | |||
What makes a polynomial trend line curve up or down? | Charts and Charting in Excel | |||
Trend Line - Bell Curve | Excel Discussion (Misc queries) | |||
Plot the sin curve along the line y=x | Charts and Charting in Excel |