Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking for a better way - Serial to local machine number
I have a list of machine serial numbers from a national database that I want
to change to a local number in a UDF. Right now I am using a Select Case statement to do that. This works fine for the small set I'm using right now. However, I would like to expand this to a larger set of numbers. What would be the best way to do this? Thanks - Mike Select Case vDecSerial Case 53: vLocal = 1 Case 72: vLocal = 2 Case 95: vLocal = 3 Case 114: vLocal = 4 Case 162: vLocal = 5 Case 2044: vLocal = 6 Case 2068: vLocal = 7 Case 2346: vLocal = 8 End Select |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks do not work on local machine. | Links and Linking in Excel | |||
Counting&Sorting multiple serial numbers per machine type | Excel Discussion (Misc queries) | |||
Reference & update destin. cells on 1st machine from source workbook on 2nd machine. | Excel Discussion (Misc queries) | |||
How to access a database on a server from a local machine using od | Excel Discussion (Misc queries) | |||
Move Folders on the Server vs. Local Machine | Excel Programming |