Hi

I am relatively new to excel vba programming and slowly getting the hang of it, learning as I go

I have a macro that uses a userform with a listbox using fmMultiSelectMulti the macro all runs fine and does what I want.

Due to nature of the project I have written (an estimating package) the macro may be run more than once and on the second and subsequent times i would like previously selected items to be shown as selected when the userform / listbox is re-initialized. Is this possible? has anyone any pointers?

I am recording the original inputs on a spreadsheet .offset(0,8) from the source for the list box items.

I guess what I am looking for is there a way to add a listitem with selected set to true if the value of .offset(0,8) meets a set criteria

I have not attempted any code of this yet as I am really not sure where to start, any help suggetions gratefully received