如何从VBscript / VBA数组中删除重复元素以在Excel中的下拉框中使用

I'm finding a lot of articles close to mine, but not quite what I'm looking for. I'm working with the IBM Personal Communications emulator to gather patient history data. There can be several pages of claims on the patient history, so the service codes used later in the program need to be gathered and saved in an array. Once duplicates are removed, the remaining codes will be stored in a drop down box.I'm finding a lot of articles close to mine, bu