Code not producing a value

I have copied and pasted this code across from somewhere where the If statement is based on cell values so I know it works. Now it is based on userform values and refuses to produce anything.

Mtt_Script = Userform
UoW = Combobox 1
Letter = Combobox 2
Sophistciated refers to a Select case range

Please Login or Register  to view this content.

It must have something to do with the If statement but I have also copied each criteria from elsewhere in the code where it works and I cannot for the life of me work out why it does not work in this one instance. I cannot see the same two cells referenced in this way elsewhere in the code so it can't be ambigious coding.

Please, please, please can someone show me the very simple thing I am doing wrong (it's always something simple that catches me out)????????


' Sophisticated Letter & Sophistication Test UoW

Please Login or Register  to view this content.

Userform is attached

What is MTT_Script.Letter?

Is it some sort of additional control that has a Letter property?

By the way, why aren't you referring to Letter from this piece of code?

Please Login or Register  to view this content.

I've just had a look at the workbook and the first thing I saw in the code was this.

Please Login or Register  to view this content.

UoW and Letter are comboboxes on the userform so you shouldn't have variables with the same name in the code.

Also, you refer to a ComboBox1 when there isn't a ComboBox1.

ComboBox1 should be replaced with the name of the combobox which lists 231, 232 etc followed by .Value.

I think Letter might be the relevant combobox so I've used it in the following code.

Please Login or Register  to view this content.

Did you try the code I posted?

It was to do with categorizing the selection made in the combobox Letter.

I used strLetter as it's a string and so as not to clash with the combobox Letter.

If you look further down the code I've used strLetter in the If/ElseIfs.

I also changed MTT_Script to Me, Me refers to the userform.

PS You should get rid of all that Select/Selection stuff.