Reading the last 2 letters in a combobox value and enter those 2 letters into column

[emilyloz]

Hello.

below is a list of items that populate a combo box. I need to find a way to read the text at the end of each entry.
For example. if the user selects "packaging line 05A - MV" I want code to recognize that "MV" is at the end and put "MV" in a column by itself when the entry is added to the spreadsheet. This list is going to be added to and deleted from so i'm unable to reference specific values.



74 Slitter - MV
76 Slitter - MV
63 Slitter - MV
38 Slitter - MV
Packaging Line 05A - MV
Packaging Line 05B - MV
30 ton Shawbox (North Bay E) - MV
30 ton Shepard Niles (North Bay W) - MV
30 ton Northern (Middle Bay W) - MV
25 ton Milwaukee (Middle Bay E) - MV
38 Jib Crane (South Bay E) - MV
30 ton Northern (South Bay W) - MV
40 ton Whiting (West Bay N) - MV
40 ton Whiting (West Bay S) - MV
40 ton Morgan (East Bay N) - MV
40 ton Morgan (East Bay S) - MV
72 Slitter - GR
54 Slitter - GR
30 Slitter - GR
Yale Hi-Lo #1 - GR
Yale Hi-Lo #2 - GR
30 ton Shawbox - GR
20 ton Conco - GR
25 ton P&H - GR
10 ton Shawbox - GR
5 ton 30'' crane - GR
77 Slitter - BH
64 Slitter - BH
R&M 25 ton Rail - BH
P&H 25 ton - BH
P&H 30 ton - BH
Abel-Howel 20 ton - BH
Whiting 30 ton - BH
Kone Crane 5 ton - BH
R&M 6 ton - BH
155 Hyster #1 - BH
155 Hyster #2 - BH
Fortif 155 Hyster - BH
Hyster 120 Boxcar #1 - BH
Hyster 120 Boxcar #2 - BH
Hyster 120 #1 - BH
Hyster 120 # 2 - BH

[zbor]

Is Kone Crane 5 ton - BH one word?

[emilyloz]

I'm not sure what you mean. That is all in one cell?

[zbor]

Yes.. You can just use

Please Login or Register  to view this content.

?

[emilyloz]

okay.. im not sure where exactly to put that in my code:

this is what i'm using to add the values to the spreadsheet

Please Login or Register  to view this content.

[emilyloz]

okay.. im not sure where exactly to put that in my code:

this is what i'm using to add the values to the spreadsheet

Please Login or Register  to view this content.

[zbor]

AFAIS, what you looking for is Repairtb1.Text

Or upload example workbook. make sure to remove all private informations.

[emilyloz]

no, I am looking for whats inputing into column D :

'Adds Location
cells(rownum,"D") = (equipmentcb1.value, 2 )


but I have attached the workbook.
its under construction right now because im just now incorporating this into an already finished workbook

the password, whenever prompted, is "steel123"

[zbor]

I'm getting error...

This doesn't work for you?

Please Login or Register  to view this content.

[emilyloz]

oh I forgot the right.
what does the right do? does it mean start from the right side and read left?

[emilyloz]

It works. Thank you!

[zbor]

Yes... Number (2 in your case) of characters on the right...

So Right(emilyloz, 3) will return loz