Thread: IF Formula newbie question

Originally Posted by gpcool

hey guys, i have an excell file which i am currently building for a custom computer shop.

my tables are set out like this on my stock sheet:

A-----------------------------B

MOTHERBOARD -------- GRAPHIC CARD TYPE

ASUS HTRRT400 ----- AGP

ASUS Hrttt700 ------ PCI EXPRESS



GRAPHIC CARD ------ GRAPHIC CARD TYPE

RADEON 3000 ---- AGP

RADEON 4000 ---- PCI EXPRESS


there are more values in each table but this is just for example.

I have made an invoice sheet where you click on a combo box and select a motherboard, lets say i clicked on ASUS HTRRT400 which only supports AGP Graphics cards. I then have another combo box for graphics card. I would like the graphics card combo box only to display the graphics cards that are compatible with the motherboard selected. In this case i would like the combo box to show all AGP graphics cards. can anyone tell me how i would go about doing this please?


sorry if i did not set the tables out right or this is in the wrong section

Hi,

Presumably you have the relevant tables of motherboards and the graphics cards supported by them. In which case extend the VBA code for the motherboard ComboBox click event, so that it performs a data filter which extracts the relevant graphics cards for the chosen motherboard and populates an output area. Then simply set the RowSource property of the secons ComboBox to this output area.

This is untested but assuming the Output area top row is named say 'Data_Out' (which you'd need for the Advanced Filter anyway), use

UserForm1.ComboBox2.RowSource=Range("Data_Out").CurrentRegion.Address

HTH

I'm working on this couple weeks -
see "Color in Combo box".
My half-idea: using for second list conditional formatting
to make non active choises grey:
=(a4="abc") - text grey.
This is a half solution - user have to see list to determin
what is unactive.
In my case lists are big and placed on other sheet.
Now I'm waiting for someone to code:
"if line in list is grey - display in combo pull dwn as grey"
second option (better) if line is gray do not display it
Ursus Uziemblo

Originally Posted by Richard Buttrey

Hi,

Presumably you have the relevant tables of motherboards and the graphics cards supported by them. In which case extend the VBA code for the motherboard ComboBox click event, so that it performs a data filter which extracts the relevant graphics cards for the chosen motherboard and populates an output area. Then simply set the RowSource property of the secons ComboBox to this output area.

This is untested but assuming the Output area top row is named say 'Data_Out' (which you'd need for the Advanced Filter anyway), use

UserForm1.ComboBox2.RowSource=Range("Data_Out").CurrentRegion.Address

HTH

thanks for the response but unfortunately i can not use visual basic well and don't really understand it that well. is there anyway i could do this with formulas?

alternatively i could make a box saying whether the system will work...
aka it displays a green ok message if it will work and a red warning if not....i believe it could be done with conditional formatting.....


i would prefer the combo box to only display the correct graphics cards though. if anyone could help me i would appreciate it a lot! thanks

bump for anyone who can help?

thanks... i believe i have found a solution to my problem....will have to experiment.