Userform Combobox Additem Only Accepts Numbers from Cells

[lsteinbach]

I have the very simple code below to populate the comboboxes in a userform. I have 3 iterations of the code for 3 different comboboxes. For some reason, I get a mismatch error when I have any values in those cells other than a number. Am I missing something in the combobox properties? Very perplexed by this... Also, you may wonder why I have the exit statement: the combobox was listing a bunch of blanks so the scroll bar was really small. Thanks for any advice!

Please Login or Register  to view this content.

[lsteinbach]

Aww man. I'm so sorry for being a buffoon and wasting anyones time reading this. It should be to lr, not to the range which fixed both those problems.

Please Login or Register  to view this content.