filtering with vba

  1. B

    VBA Filter based on multiple Search Inputs

    Hey All, Im currently looking to Filter data in column H based on the user inputted data, currently I have the bellow code which works for 1 or 2 inputs, but I needed it for more for example 1-15 inputs at time. Sub FilterValues() Dim Area As String Dim Data As Variant Area =...
  2. A

    Using Auto Filter when protected with VBA

    Hello all, I have the code below which captures information inputted onto a user form and pastes it into a spreadsheet which is locked. I have a need to be able to still keep the spreadsheet locked but to allow the use of the autofilter function. I have searched Google but so far have been...
    • alexdurc09
    • Thread
    • autofilter cellsrowselect filtering data filtering with vba vba
    • Replies: 2
    • Forum: Excel Questions
  3. B

    Always select the first row of a Filtered Block

    Greetings 3 events can be triggered (events = 11, 12, 13) all in column “A” Starting at range(“a51”) (the title row) Filtering a block of 4 columns 49 rows, I want to capture to (“C48”) the value in column 3 of the 1st row displayed by the filter, for each event The Macro I recorded works well...
    • bribin
    • Thread
    • =r[10]c block column filtering with vba row
    • Replies: 2
    • Forum: Excel Questions
  4. C

    Filtering with VBA out of user forms.

    Good morning, I'm creating a spreadsheet with a userform to filter data. The afflicted portion of the userform is basically just a bunch of comboboxes stacked on top of each other. The combo boxes are populated from several different tables. After the first combobox is selected, I'm hoping to...
    • cardinalphin
    • Thread
    • advanced filtering filtering with vba parented lists userform combobox
    • Replies: 1
    • Forum: Excel Questions

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
Back
Top