Conditions based on 2 variables

[Jakes]

Hi there again,

I have on a user form, a dropdown ComboBox1 with preset values, A B and C

I also have a TextBox1 for values to be entered.

Now on my command button "Save" I want to have a condition that check that IF ComboBox1 value = B, then Textbox1 nust contain a numerical value, and if not, set the Textbox1 active.

I have the following, but not working :

Please Login or Register  to view this content.

what have I done wrong?

Thanks for all the help!

Jakes

[pike]

Hi Jake

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.