Give Choices based upon Userform Entry

**00Able** · 01-29-2011, 02:02 PM

In my workbook, I have a "LookUpLists" sheet that has all kinds of data relating to different fields in the userform, (most of which are dynamically named to go into the userform). What I am curious about is this:
The user must input a SKU # and a Storage # in the userform (located on the front page) I would like the userform to be a little smarter and give the user an option based upon what SKU is put in, so in my example you can see that SKU 12032, has 2 Storage #'s;N34-33-A, and N51-33-A, this is based upon information in the "LookUpLists" sheet column S "StorageList" is its dynamic named range, (column T "SKU (Storage #)" is directly related to Column S the "Storage #".

Hopefully that explains well enough, so is it possible for a userform, to have a pop-up, or another option after you put in a SKU, asking which storage location it came from?

If it is and you don't know how to do it, please let me know, if you know it is not please tell me that to, any feedback is appreciated.

**mrice** · 01-29-2011, 02:27 PM

You could populate cboStorage with code run as part of the cboSKU_Change event which appears to be currently unused.

**00Able** · 01-29-2011, 02:35 PM

I dont understand, can you provide any other information, referencing, research that I can do?

**jaslake** · 01-29-2011, 03:57 PM

Hi 00Able

If I understand your issue, try this approach (see attached).

**00Able** · 01-29-2011, 04:23 PM

That approach will work, it appears to be somewhat "volatile" for a lack of a better word. I do not understand the code, so I am not sure how to disect it.
I keep getting a code error "run time error 1004, no cells found"after I hit submit, when I debug it this is highlighted

Please Login or Register  to view this content.

Also, when I initially pick a SKU, it returns the Column name "Storage #",no matter what, so I have to go back up and click the sku field and re-enter the data

so I am not sure?

**jaslake** · 01-29-2011, 04:53 PM

Hi 00Able

Sorry 'bout that...I didn't test the "Submit" button. Basically, what needed to be done is to set "Events" off. Application.EnableEvents doesn't work in UserForms. So, you'll see I added "Flag" as Boolean to the code. When "Flag" is set to false, the new code I gave you won't run.

See if it works for you; let me know what you don't understand...be glad to explain if I can.