Use Combo Box Results For AutoFilter

Dec 21, 2005

I want to use the selection from a combobox on a sheet to set the autofilter. I know it is probably very simple but have not been able to find the answer by searching this forum. Below is the code I am using. It sets the filter to blanks for some reason.

Private Sub ComboBox2_Change()

Range("D9").AutoFilter Field:=1, Criteria1:=ComboBox2.Value, visibledropdown:=False

End Sub

View 9 Replies


VBA Autofilter Not Returning Results?

Jul 6, 2013

I have a large table which I am filtering 3 times. There should be results but the final VBA filter does not return them until I manually apply the filter. The custom filter is correctly populated with the criteria. The code that I am using is as follows:

Selection.AutoFilter Field:=9, Criteria1:="<>", Operator:=xlAnd
Selection.AutoFilter Field:=10, Criteria1:="=INV", Operator:=xlOr, Criteria2:="=CRD"
Selection.AutoFilter Field:=21, Criteria1:=">=" & DTPicker1.Value, Operator:=xlAnd

The first two filters work fine. The last does not. Oddly it works on some date picker values and not others, even if there are actual results and as mentioned earlier if I stop the program running and apply the filter (without typing anything else) it works fine.

View 5 Replies View Related

Total AutoFilter Results

Dec 30, 2006

I have a worksheet of data that I have created by combining several other workbooks into one using a macro. On this worksheet I run AutoFilter to select certain rows and then copy these rows to another worksheet, again using a macro. How can I get the macro to generate a total for one of the columns? I would like the Sum to be two rows after the end of the column with some kind of descriptor preceeding it.

View 6 Replies View Related

Calculate Autofilter Results

Feb 19, 2008

I have a list of data in Excel with Autofilters. At the bottom of the data set is a row that totals up many of the columns. Whenever I use the Autofilters, the totals at the bottom still reflect the entire set of data, rather than only the filtered data.

Is there a way (using macros, formulas, or something else) to make the totals automatically update to only reflect the data that is visible when using Autofilters?

View 6 Replies View Related

Use ComboBox For Changing Autofilter Results

Apr 9, 2013

I have a problem very similar to this thread: [URL] .... Therefore I have tried to adapt but so far failed.

My requirement is that a userform pops up with multiple comboboxes (in this scenario 3) and once the results have been selected and the user clicks the button "OK" then the autofilter changes to the same as what the selected ComboBoxes were.

So, there are 3 comboboxes so I have tried the following:

[PrivateSub CommandButton1_Click()

If Sheets("Data").AutoFilterMode = True Then Range("B3", Range("B600").End(xlUp)).AutoFilter
Range("B3", Range("B600").End(xlUp)).AutoFilter Field:=1, Criteria1:=ComboBox1.Value, visibledropdown:=False

[Code] .....

View 5 Replies View Related

Search Box That Uses Autofilter To Filter Results Down?

May 14, 2012

I want to create a searchbox in Excel which will locate text in a massive amount of data, for example, if a user types into the box....


I want the search box to filter the spreadsheet using the autofilter from cell B3, thus filtering out all results that are NOT "123".

Currently I have a button to press which brings up the CTRL + F screen, but that isn't exactly what is required in this instance.

View 6 Replies View Related

Vba Autofilter Msgbox If No Results Returned

Nov 2, 2008

I want a msgbox to popup if the autofilter returns no records saying "No records found".

Heres a sample of the
Sub cmbFindAll_Click()
Dim strFind As String 'what to find
Dim rfilter As Range 'range to search
Set rfilter = Sheet1.Range("a2", Range("f65536").End(xlUp))
Set rng = Sheet1.Range("a2", Range("a65536").End(xlUp))
strFind = Me.TextBox1.Value
With Sheet1
If Not .AutoFilterMode Then .Range("A2").AutoFilter
rfilter.AutoFilter Field:=1, Criteria1:=strFind & "*"..........

View 9 Replies View Related

Copying Results From An Autofilter To A New Worksheet

Aug 27, 2009

I'm working on a quote template that has 600+ products with descriptions and prices that gets autofiltered down to one product. After it has been filtered down to that one product how do I link that to a new worksheet?

View 9 Replies View Related

AutoFilter Table & Copy Results

Jan 29, 2008

The error above comes up every time I copy filtered data to a new worksheet. It does its work but the said error comes up.

Sub AUTOFILTER_withouthead()

' AUTOFILTER_for_drop Macro
' Macro recorded 1/27/2008 by DD
Dim ws As Worksheet, wd As Variant
Set ws = Worksheets((Worksheets("Destination"). Cells(1, 6).Value))
Set wd = Worksheets("Destination").Range("A1:F65000") ...

View 3 Replies View Related

Assign Autofilter Results To A Range Object

Dec 3, 2008

I have a simple three column range. I Autofilter the range based on one of the values in Column 1. I then want to grab the results into a range object.

I've been trying to use the Specialcells(xlcelltypevisible) route to no avail. It only gets one row when I should have many.

View 14 Replies View Related

Copy And Paste Autofilter Results To Different Sheet?

Jul 1, 2013

I have a sheet that I need to routinely filter for a specific code then paste it into a different sheet in the same workbook. I would love to set up a simple macro that would do this for me, but I can't seem to figure it out.

In the results I would like the header row if at all possible, but I can always just make it part of the macro.

View 2 Replies View Related

AutoFilter Copy Code Producing No Results

Aug 9, 2007

I have created a macro some time ago that is an integrated part of an XLA. The Xla has worked fine but now, for some reason, the macro fails to import the specified text, it doesn't fail but nothing gets imported. I have tried solving this myself, but alas I am not bright enough

The code is:

Sub GetWorksheet()
Dim filetoopen As String
Dim wb As Workbook

filetoopen = Application _
. GetOpenFilename("XL Files (*.xls), *.xls")
On Error Resume Next

View 5 Replies View Related

Use AutoFilter To Filter And Copy Results To Existing Worksheet

Apr 5, 2013

I got the following code from Use AutoFilter to filter and copy the results to a existing worksheet and would like to incorporate this into my VBA project. The problem however is that this code were written to perform on one workbook and this is where my problem is. My project is between two different workbooks and cannot seem to get this code modified to do what it is supposed to do between these two workbooks. Everything I have tried so far failed. In short what this code would do is to check the existing data on the one sheet (the source) and extract only the data which is meeting my set criteria, and copy this data to the destination sheet. This is what I would like to do between two workbooks. With this the sample code as provided by Ron de Bruin. The sample workbook could be accessed trough the following link [URL]..... With this the code for matching and copying on one workbook.

Option Explicit
'This example will copy the filter results below the existing data on the destination sheet.
'Note the sheet "RecordsOfTheNetherlands" must exist in your workbook.
'This example will not copy the header row each time so when you manual add the worksheet
'"RecordsOfTheNetherlands" to your workbook you must add the headers yourself on the first row.

[Code] ............

View 1 Replies View Related

Deleting Hidden Rows Based On Results Of Autofilter

May 23, 2007

I am performing an autofilter within a spreadsheet to display only those lines where a name exists in column A. Then I delete all hidden rows. I am having a problem when the autofilter results in no rows being visible. Here is the code I am using for the delete hidden rows:

On Error Resume Next ' In case there's no hidden cells

With Cells
Set rngHidden = .SpecialCells(xlCellTypeVisible)
.EntireRow.Hidden = False 'Unhide all cells
rngHidden.EntireRow.Hidden = True 'Hide previously visible cells
.SpecialCells(xlCellTypeVisible).EntireRow.Delete 'Delete previously hidden cells
rngHidden.EntireRow.Hidden = False ' Unhide previously visible cells
End With
End Sub

View 9 Replies View Related

To Make A Combo Box In Excel That, If I Select It The Sheet Inside The Combo Box Will Appear

Sep 19, 2009

I want to make a combo box in excel that, if i select it the sheet inside the combo box will appear.


Inside of combox are: Sheet1

If i click combo box and i choose sheet3 the sheet3 will appear.

How can i do this? theirs a macro code to use?

View 9 Replies View Related

Values Of Combo Box Dependent On Selection In Another Combo Box

Oct 9, 2008

The first combo box is on a userform so that a subject can be selected

View 3 Replies View Related

AutoFilter Method Of Range Class Failed - Yet Autofilter Works.

Sep 25, 2009

Im sure this is a very common problem. I tried searching for it but I havent found anything that solves this for me. Here is the code Im using:

View 3 Replies View Related

Combo Box Should Trigger Another Combo Box

Oct 19, 2008

I have to create two combo boxes and when a user selects a value from one combo box, the values should get changed in the other combo box.

For example : if one combo box has values like "c/c++ programming" "java programming" and so on.. ... i would like to display the authors recommended (corresponding to combo box1) in the combo box 2.

View 6 Replies View Related

Copy Top Cell Post Autofilter And Reapply Autofilter Based On Cell Value

Aug 20, 2014

I can select the top cell in column "F" after filtering by multiple columns using VBA and arrays, but now want to I want to use the top cell in column "F" to search for all other equipment that uses this item.

E.g. remove filter, and reapply autofilter to column "F" based on selected cell as per below VBA

Note: Row 1 contains command buttons and row 2 Headers.

View 4 Replies View Related

Results Show Results Of Formula, But Should Be Blank

Jul 27, 2006

I am trying to create formula that will show overtime worked in a given day. The code I am using is a simple one ([ cell - 8], for hours worked). The problem is when the time cells are blank/not used it shows a -8 in the cell. what I need to do to create a code that will eliminate the -8 from showing. The cell its self is taking the result from another cell with a formula and then subtracting 8 from the result of the formula in the other cell.

View 2 Replies View Related

Set Autofilter To All Without Removing The Autofilter

Jan 16, 2007

I can set the autofilter, change it, remove all using Macros. What I need to know how to do is reset a filtered column to ALL while leaving all other filters on.

View 2 Replies View Related

Combo Boxes Based On Other Combo Boxes

Feb 1, 2007

I would like to create a combo box however the contents of the combo box depends on what i have selected in a previous combo box.

View 2 Replies View Related

Change Formula To The Results Of The Formula For Cells That Have Results

May 9, 2006

I have a range that has formulas that are based on other fcells outside the range.

What I want to do is, if the cell has a value to remove the formula and paste the results. If the filed is blank (no results from the formula) to leave the formula in place.

There could be a marco to run when this process is needed.

example attached

View 9 Replies View Related

Let A Combo-box Appear

Oct 15, 2008

I have used and adapted the following code for my sheet:

But this combo-box only appears when I change from and back to the first sheet. I would like to either let the combobox appear

-when I open the file or
-when I click anywhere in the first sheet (can be a specific cell, or not)

Another solution would be to "fix" the combobox to a specific cell, ie not make it pop up anymore but just have it there.

View 5 Replies View Related

VBA Using Combo Box..

Oct 23, 2009

I am having a few problems trying to amend the code so that it only uses the text box and combo box below. Unfortunately I am having a few problems. I am new and have amended this spreadsheet / code from another user on this site.
When I delete the combo box on the right, using developer mode, a run time error occurs.

View 2 Replies View Related

Tab Into And Out Of A Combo Box

Mar 16, 2007

I've got a worksheet which uses comboboxes at certain points for users to input data. At other points in the sheet they are entering directly into cells.

I've got the sheet protected, with the input cells unlocked so that it is possible to jump to them using the tab key.

However, I can't seem to make the tab key jump to any of the comboboxes. Ideally I'd like to set the full order for the tab key so that it jumps between input cells and comboboxes at the required stage.

View 13 Replies View Related

Combo Box

Jul 9, 2009

I am trying to set-up a database where a list of people are trained on different items of equipment.

Is there anyway of doing this example please?

John is selected from a drop down box.

If he is trained on certain equipment, the box will turn green automatically. If he is not, the box will be red.

I am assuming, I will have a separate sheet housing all the names and what areas they are trained in.

View 9 Replies View Related

Combo Box Won't Populate

Dec 13, 2012

I have a problem where a combo box in a form won't populate from the VBA code in the initialise routine. I've tried a couple of difference methods for populating the combo box without success. The code I have is:

Option Explicit
Sub NewTender()
Application.ScreenUpdating = False


I tried the excel file uploaded by Norie but it only displayed "Is". Are there any settings I need to modify to allow the add item property to work?

View 2 Replies View Related

Cannot Remove A Combo Box

Jun 4, 2009

I added a combo box to a worksheet and closed and saved it. But I don't want it amymore. I cannot delete it. I try right clicking it but nothing. The worksheet,(workbook) isn't protected.

View 2 Replies View Related

Combo Box Formatting

Sep 22, 2009

-To have the text alignment as centered; and

-Have a shading in it (as per the row)

I have attached a spreadsheet so you know what I mean.

For instance the row in which the combo exists, is shaded blue, is there a way to make the box the same shading too?

View 3 Replies View Related

Copyrights 2005-15, All rights reserved