View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Post Tenebras Lux Post Tenebras Lux is offline
external usenet poster
 
Posts: 41
Default Saving MSForm.Control (s) created at Runtime?

I have a CreateControl procedure behind a command button on an Excel
MSForms.Userform.

It creates various controls (combobox, textbox, checkbox, etc) in a row on
the form. This allows the user to add or delete and set any number of new
rows of control values.

I would like to be able to allow the user to Save the controls and all of
the properties (control.width; control.value; control.listrow, etc) that s/he
has created.

This way the next time the form is opened, the controls and their settings
don't have to be recreated - but can be added or substracted depending on
that session's requirements and usage of the form and it's underlying
procedures.

Is this possible and, if so, how?

Thanks.