Drop Down with condition

[Kmahraz]

Hi.
Looking for some help, unfortunately I don't have much experience with multi-pages in VBA and condition in drop down.

I was able to program the first page and it work as intended,

For the second tab from the user-form I would like some assistance, all the information from the second tab will need to be saved in sheet "Data". Please reference the attached file

Additionally, I would like to be able to select A or B from the drop-down titled (OPTION) and depending on my selection I will receive a different category in Material drop-down list (A1,A2, A3) or (B1,B2,B3).

Finally, I would like the customer ID generated in the customer info tab to be added in sheet "Data" as shown in the attached file.

List sheet contain all the lists needed for this example.

I know this is too much asking; but any help/ assistance will be much appreciated.

Regards,

K

 

[vletm]

@Kmahraz
You'll get an answer for Your dropdown (6 levels) from this file.
Instructions:
activate any row, Lv1 => make selection => moving to Lv2 ... and so on

Ideas?

 

[Kmahraz]

Hi Vletm,
Again thank you for your help and support, I am familiar with the example you sent me but not in doing so with VBA, unless I am missing something.
Can you please help with my request?
Best,
K

 

[vletm]

@Kmahraz
This time, You asked about 'DropDown with conditions'.
I sent a sample. You would get many kind of possibles, not only one.
There is no matter that maybe You need 'ComboBox with conditions'.
You can edit this and it'll match with 'ComboBox' too.
'CustomerID's value would 'move' to another page same as other values,
like '.page2.cuID.value = .page1.cuID.value' (use correct object names).

 

[Kmahraz]

Hi Vletm,
You are correct, what I need is a comboBox with condition, unfortunately I can't edit the thread at this time since we had several responses.
For the customer ID it will be same value, if you take a look at my sample file sheet "Data" has a sample of how i would like the data to be saved from the userform.
Thanks Again for your help!
K

 

[Kmahraz]

Hello Everyone,
Any help with my request please , I should said that it's a Combobox vs dropdown.
Regards,
K

 

[Kmahraz]

Updated file....

 

[vletm]

@Kmahraz
Question:
You can save MAX two rows in one time (by pressing Add).
Your sample DATA shows three rows per saving, how to make that possible?
There are max four Part Numbers to use, You have saved more PNs in time.
Ideas? How to make this mission possible

 

[Kmahraz]

Hello vletm,
You are correct, it's my mistake, I was creating a sample file to share with you, for this sample it's only two. I updated the file accordingly.
Again thank you so much for the help

 

[Kmahraz]

Hello Ninjas,
Any help with my request please
Regards,
Karim

 

[vletm]

@Kmahraz ... more Qs:
Can every user use their own 'cost'-value?
What is QYT's function?
Is somewhere the great idea of connetions of
'option - material - category - part number'?
How do You take care that nobody cannot sort You Data-sheet?
Why there are two 'Frames'?
I would say that: something is missing...?

 

[Kmahraz]

@vletm

Can every user use their own 'cost'-value?
I'am afraid i don't understand your question, please elaborate
What is QYT's function?
It's only used to capture the number of components in the part number box
Is somewhere the great idea of connetions of
'option - material - category - part number'?
Not sure if i did understand your question?
How do You take care that nobody cannot sort You Data-sheet?
The data won't need to be sorted, it will be used for calculation purpose only in a separate sheet
Why there are two 'Frames'?
The two frames are for different kind of systems, my intention are to capture data related to each system.

Please see picture and attached file :


Thank you
K

 

[vletm]

@Kmahraz
1) Cost ~money? if [cost] is free to write, maybe then everybody has right to write own value.
2) Sorry, QTY. If purpose is 'buy' then it's okay, but if 'sell' then there should something more.
3) 'option - material - category - part number'
If all of those are free to select, many possibilities, interesting.
Or would this be like: ( not necessary connect with You 'things' )
A - A1 - ABC1 - 123-123 - 100£
A - A1 - ABC2 - 234-234 - 125£
A - A2 - ABC3 - 111-222 - 150£
A - A2 - ABC4 - 111-121 - 175£
B - B1 - BCD1 - 121-212 - 333£
B - B1 - BCD2 - 212-222 - 375£
B - B2 - BCD3 - 322-231 - 432£
B - B2 - BCD4 - 222-243 - 477£
4) sort - dangerous layout - there could be one 'link' between one form saving.
or nobody knows which rows belongs to any 'Customer ID' / one saving
... so far, I haven't seen this kind of layout -
there will be challenges to work with this,
or You have done really new type of system, hope so.

 

[Kmahraz]

@vletm

1. Cost is free to write
2. QTY, is only to indicate how many they will be using, this user form is not intended for purchasing... its only to capture information.
3. "Option - material - category - part number- price-Qty"

Note: The customer ID and or Option and Or material can be duplicated, similar to what you had in your sample:

A - A1 - ABC1 - 123-123 - 100£-2
A - A1 - ABC2 - 234-234 - 125£-1
A - A2 - ABC3 - 111-222 - 150£-3
A - A2 - ABC4 - 111-121 - 175£-8
B - B1 - BCD1 - 121-212 - 333£-7
B - B1 - BCD2 - 212-222 - 375£-3
B - B2 - BCD3 - 322-231 - 432£-7
B - B2 - BCD4 - 222-243 - 477£-2

4. No sorting needed

 

[vletm]

@Kmahraz ...
Where do You need 'drop down with condition'?
You just told that 'everything can mixed and every value can be a random'!
If You really need any kind of 'drop down with condition',
this should need information like file with #2 Reply; clear rules.
Try to check one more time that file.
If there are not clear rules, then no need combo boxes, this needs just labels!

 

[Kmahraz]

@vletm, The comboBox with condition needs to be in the "Data" tab from the userform (Frame6 and Frame7) please open the user form



The only Values that can be typed by the user in the userform are
The part number
The cost
QTY

The rest of the information will be done using the combobox
Option
Material
Category

I really hope I did explain my needs appropriately

Again I apology if i didn't explain my need accordingly.

Regards,

K

 

[vletm]

@Kmahraz
1) I tried to start to write code,
but I noticed that even 'Customer Info' didn't work!
For some reason, many codes are missing?
'My made code' are missing as well as 'second time saving Customer Info'.
There should make some settings before open the Form.
If no settings nor code then the Form won't work.
2) I didn't found rules for 'Category'.
Of course, I could copy something back and checking... checking,
but that isn't right way to do!
Something gotta do, that something could get.

 

[Kmahraz]

@vletm, the customer info is working for me, Please use the file attached below.
Thank you!
K

 

[vletm]

@Kmahraz
The Form will open and that do not mean working.
If You say that it works, then fill the form and 'save it'.

 

[Kmahraz]

@vletm
I apology for the delay, here the latest file with most of the changes,

First request:
For the second Tab titled "Data" the data will need to be saved under a sheet titled "Data" as shown in my sample file, as you will notice I would like to use the same customer ID generated in the customer info tab...

Second request:
For the tab titled reporting looking for some ideas or help to come up with a search method that will enable the user to search for a customer ID and or even a customer name if possible and retrieve the data from the workbook into the userform.
Regards,
K

 

[p45cal]

cross posted
http://www.excelguru.ca/forums/showthread.php?5290-Help-Suggestion-with-userform

 

[Kmahraz]

@p45cal
I was able to find a solution.... Since I didn't get any response on the other site.
Let me know if you need the solution and I will posted