Initialise List Box

[simonhall]

Hi,

On my worksheet I have data in 2 columns. The first column is reserved for a Yes/No entry. The second contains the corresponding data - ie a list of names.

When initialising a list box on a user form, I wish the code to sort through the list and only add those values that have a corresponding "Yes" value.

How would I do this??

Thanks, Simon

[Mallycat]

Why don't you load the names into an array using the Yes/No column to determine if it makes the array or not. Then load the listbox based on the array.

edit: I thought you were talking about VBA. This probably wont work if you are talking about a simple imbedded list box.

[simonhall]

Thanks, Mallycat,

I am doing this in VBA and I have the code working now.
Thanks for your reply.

Simon

[Myles]

For the sake of a fitting closure to the thread:

Please Login or Register  to view this content.