Combine UserForm_Initialize errors

**onmyway** · 07-29-2013, 09:58 AM

Hi All,

I need some help correcting my code. How do I go about combining these 2 parts of script?

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

There is obviously an ambiguity issue with the "Private Sub UserForm_Initialize()", and when I combine it in various ways, I get other errors....

Thanks for the help!

**ragulduy** · 07-29-2013, 10:00 AM

Please Login or Register  to view this content.

You can't have two modules with the same name.

**onmyway** · 07-31-2013, 06:44 AM

Thanks for the help! But I am getting the following error: Run-time error '9': Subscript out of range.

I would appreciate if someone could take a look. I have attached my workbook. The sheet named "DataSheet - Fitness" has the macro button "Capture new record" to open the UserForm. The error only started with the last section of code, I have inserted below:

Please Login or Register  to view this content.

This is for combining the 2 section of code in my first post. The one part of code is to add the sheets to a ListBox, the other is for creating a GUID.

Thanks!