I have a userform with ListBox1 that is populated via looping excluding blanks cells from a column in Sheet1.
The length of the list on Sheet1 will vary.
For example; I may have a list of 100 entries on Sheet1 in columnA but only show 10 entries in ListBox1 if 90 of those entries were blank.
Once ListBox1 opens up and allows the user to select multiple entries and clicks an "OK" command button, I want to be able to flag those entries on the corresponding 100 entry list on Sheet1, "1" if select or "0" is not.
I cannot use the listcount or index b/c the listbox only has 10 items in it and loses it's original item # among the list of 100. In the list of 10 the entry could be the first entry but is the 25 entry in the list of 100.
Any ideas how to accomplish this?
Bookmarks