spannerj
07-28-2005, 12:32 PM
Hi there,
I have been struggling away with creating a userform.
I have a workbook with a command button which launches a user form. At present I have coded userform.show in the onclick event.
I want to be able to initialize all my combo boxes and list boxes to a value from the workbook and then save any changes back to the workbook when finished. I know should be using the userform.initialize event but I can't seem to get it to work.
Could someone give me some pointers please.
I have attached my sheet so far if someone would be so good as to look at it for me.
I have been struggling away with creating a userform.
I have a workbook with a command button which launches a user form. At present I have coded userform.show in the onclick event.
I want to be able to initialize all my combo boxes and list boxes to a value from the workbook and then save any changes back to the workbook when finished. I know should be using the userform.initialize event but I can't seem to get it to work.
Could someone give me some pointers please.
I have attached my sheet so far if someone would be so good as to look at it for me.