View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Art Art is offline
external usenet poster
 
Posts: 587
Default Live chart in a userform

Sorry I don't know about your primary question. However I do know what
modeless is. If a form is Modal, once it appears the user can't click on
another object until he closes the form. You'll often see this in forms that
pop up in your system. A Modeless form allows the user to click back on the
application with the form still open.

There's benefits to doing it either way, but in my opinion too many forms
tend to be modal.

"pinkfloydfan" wrote:

Hi there

Working with Excel 2003:

Am I correct in thinking that by adding to the userform controls
"Microsoft Office Chart 11.0" you can add a live chart to the
userform?

My immediate project is to create a userform that allows the user to
set the inputs for a class. As the inputs are changed (maybe with a
spinner) the chart on the userform changes to reflect the updated
class inputs. Thus, the user can adjust the inputs until they get the
shape they are looking for.

Am I heading in the right direction here?

Thanks
Lloyd

p.s. what does "modeless" mean?