I have coded my Userform to dynamically generate labels, textboxes and comboboxes depending on the number of data imported from the spreadsheet. I know i can format the combobox by change event but this does not seem to work on dynamically generated ones. Below is the code i use to generate the combobox:
I was told that as a work around, i can also convert my rowsource first to string though i am not sure how i should go about doing that too.Please Login or Register to view this content.
Bookmarks