$$Excel-Macros$$ Re: saving VBA-created objects

2009-08-25 Thread Jene
Here is the macro attached to the command button that populates the comboboxes: Private Sub CommandButton3_Click() Sheet2.Include1.Value = False Sheet2.Include2.Value = False Sheet2.Include3.Value = False Sheet2.Include4.Value = False Sheet2.Include5.Value = False Sheet2.Include6.Value = False

$$Excel-Macros$$ Re: saving VBA-created objects

2009-08-25 Thread kamal shah
Could you paste your Macro Codes here and probably it will be easy to identify solution. May be your macros are event based. Kamal On Mon, Aug 24, 2009 at 5:09 PM, Joseph Choi wrote: > you may need to save the user input state of your controls (combo box, > listbox) and save it on your workbook

$$Excel-Macros$$ Re: saving VBA-created objects

2009-08-24 Thread Joseph Choi
you may need to save the user input state of your controls (combo box, listbox) and save it on your workbook, into cells. then, at startup (or workbook/sheet load), read these values and reapply them to your controls. of course, someone here may have a solution to actually save the form. On Mon,