question about VB & filtering

VTTW

New Member
Joined
Mar 24, 2002
Messages
26
First, I have a userform that has three different comboboxes, with the names of cbjob, cbdwg & cbrev. There are other textboxes on the userform that provide descriptions & weights of the entries.

second, I have a sheet (dwglog) that has six columns of data. The three of importance are columns A, B & C. The other two (D & E) columns contain the descriptions & weights as mentioned above

cbjob is bound to column A
cbdwg is bound to column B
cbrev is bound to column C

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

here's a sample of the worksheet data:

A B C
16702 R1 1
16702 R1 2
15205 A1 1
16702 R1 3
16702 R2 1
15205 A1 2
15205 A2 1
16702 R3 1
16702 R2 2
15205 A2 2

(the entries are far greater in number, but I think that this should be enough to understand my situation without being confusing)

Here's the desired results. When 16702 is selected with the cbjob combobox, a filter is applied and only "R1", "R2" & "R3" populate the cbdwg combobox. Next, when "R3" is selected, only "1" populates the the cbrev combobox. From there, the other textboxes are populated by the row that contains "16702, R3, 1" in rows A, B & C.

I asked some questions similar to this about 6 months ago, and Damon O gave some advice to use Autofilter, but I couldn't get it to work (I've tried several times, I'm not asking just to ask. I'm stuck in the worst way).

Any ideas?? Please?
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Forum statistics

Threads
1,144,127
Messages
5,722,634
Members
422,450
Latest member
Springbok

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top