I cant recognise a specific letter in order to activate 2 combo boxes

[bralew]

Hi,

I need to introduce a new Textbox7 which will carry a 20 digit code. Of that code, I need the code to recognise the 3rd letter. If the letter is "A" then
this would activate combobox1 and combobox2 "C03000"
The "B" would do the same but equal - "BRCKT016"
The "C" would do the same but equal - "C05001"
The "D" would do the same but equal - "BRCKT044"

Any ideas???????

[xlnitwit]

You may use a Select Case clause

Please Login or Register  to view this content.

[bralew]

thanks, I'll give it a whirl

[bralew]

mismatch error, give it a whirl

[xlnitwit]

That is due to the change event of Combobox1. When it attempts to run this line

Please Login or Register  to view this content.

textbox1 is empty.

I do not know what the workflow is intended to be so I cannot suggest the best resolution, but your change event should be testing for an empty or non-numeric value in that textbox at the very least.

[bralew]

ah yes, fill in OHF, MBC and beam length and it works fine , thank you