$$Excel-Macros$$ follow-up: saving macro-created objects

2009-08-27 Thread Jene
One of you requested that I post my macro code, so here it is. What this macro is supposed to be doing is populating comboboxes on another worksheet. It does that, but when I save and reopen the workbook they are no longer populated. I think I need to be doing something on a more global level, but

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

2009-08-25 Thread Jene
t4_6.AddItem x Sheet2.segment1.Caption = Range("e37") Sheet2.segment2.Caption = Range("e38") Sheet2.segment3.Caption = Range("e39") End Sub On Aug 25, 5:21 am, kamal shah wrote: > Could you paste your Macro Codes here and probably it will be easy to > identify

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

2009-08-24 Thread Jene
Hi all, I'm new to your board and hope you might be able to help me out. I've been searching for an answer to this problem and coming up empty - maybe I'm not using the correct terms. I have a set of macros that create combo and list boxes on a worksheet in my workbook. When you click on a command