I am learning VBA, and am currently working on making a unit converter.
I have 2 sets of three list boxes, and for each set the selection in the first list box determined what populates the other two. Everything is working perfectly, but when I open the excel file I get two run time errors, saying "Object Required".
Here's what the code looks like for one set:
The red is where I get the error. It happens for each set of three, so I get an error in ListBox2, and ListBox5 (the sets being Boxes 1, 2, 3 and Boxes 4, 5, 6). I don't get errors for ListBox3 of ListBox6, even though the command in the same.Please Login or Register to view this content.
If I hit "end" for each of the errors, I can use the workbook without issue. Unit Converter.xlsm
What am I doing wrong?
Bookmarks