Form Control Combo Box Selection

[wacky_diva]

Hello,
how do you run a macro according to the selection made in a form control combo box?

essentially whatever I have selected in the combo box I want filtered in a table, the cell which is the table header i need the filter on is in A10 and called 'Order No' of the 'Prt2Rec' table

Please help

[philippjb0]

Hi,

You can access the contents of the combo box just like the contents of a normal text box, i.e.

Please Login or Register  to view this content.

will give you the content of the combo box.

[wacky_diva]

Hi Philip,
I'm not sure I understand? The values are from a range of cells on the sheet, but I would like to filter the table below according to the value selected in the form control combo box. eg 3004
*the table column I would like to filter according to the value selected in the combo box is in A:10 [Order No]

[wacky_diva]

ok!! I've worked it out :D

Silly me didn't know where to look to find the form control name :p (top left, where cell reference is)

So... after renaming my combo [cmbPO], I created a macro to filter the table on the Order number field for each value in the drop down:

Please Login or Register  to view this content.

and then associated the following code with the combo box:

Please Login or Register  to view this content.

it might be a little clumsy but it workd :D thankyou for you help