Need help with VLOOKUP and Condition Setting

[WILLUS]

Ok so here is what I am trying to do. I have a form that has many comboboxes on it. I have made the default visibility on most of these false so that they are only seen when I want them to be. Now then, I have tried to trigger a change to the visibility with a Vlookup result. So I have cmb_mod1 which is my value that I want to use a arg1. The range will be worksheet("compressors").range(A1:b1000). Column that the expected result is located in is 2.

So if cmb_mod1.value = Jge_4 The lookup should search the compressors worksheet column a for the value of JGE_4. Then return a result of "4" for this particular choice from the dropdown. Finally the If condition. Now If ans = "4" then cmb_1cyl1.visible=true and cmb2cyl1.visible=true and cmb_3cyl1.visible=true and cmb_4cyl1.visible=true. However, I cannot get the visibility to change.

Hoping for any help is what may be causing my condition change. Code below:

Please Login or Register  to view this content.

[WILLUS]

Nevermind I found my brain under the table and put it back in. I have it working now with the exception of a null value return. Have that fixed up in a jiffy.

[Kaper]

Good to hear that.

Please select Thread Tools from the menu link above and mark this thread as SOLVED.

Thanks.