VBA to pick and omit

[wilster98]

Hello All
I am making a user form that will choose a data set that has an identifier that begins with a number between 01 and 24 (Example 01-BLB) based electrical resistance measurements for that data set. Once a number has been used, it has to be omitted from future selections. Is there a command or function that will disregard all data sets based past selections? The identifiers will be written to a second sheet as they are selected, so there will be a record to refer to for numbers to omit (see below).

01-BLA
09-TRA
06-TRA
15-TRA
21-TRA

Thanks in advance
Willy

[PCI]

How to you want to track items already selected ?
It can be done by updating a list in memory but when the file is closed this list will disappear.
Or it can be recorded somewhere in Excel file and review when the file is open
How do you see the story?

[Sintek]

a user form that will choose a data set that has an identifier that begins with a number between 01 and 24

Is this selection made via a Combobox that is populated from a range...
If so, perhaps you could run a check to see if the selection is found in the secondary sheet before proceeding!