1

Topic: Whether is from VBA access to ListBox falling out under the autofilter button? - VBA

At autofilter button click there is a list of unique values. How to address to this list (array) from VBA?
Very much it would be desirable to see the decision.

2

Re: Whether is from VBA access to ListBox falling out under the autofilter button? - VBA

It would be desirable to place this list in  on the form.

3

Re: Whether is from VBA access to ListBox falling out under the autofilter button? - VBA

Valll wrote:

How to address to this list (array) from VBA?

such possibility is not present. It is necessary to select in the program unique of visible cells of this column of a range of the autofilter.

4

Re: Whether is from VBA access to ListBox falling out under the autofilter button? - VBA

Valll wrote:

It would be desirable to place this list in  on the form.

Range ("A1:A6").AdvancedFilter Action: = xlFilterCopy, CopyToRange: = Range ("B1"), Unique: = True

Therefore to specify target Range, as data source on  through ComboBox1.List

5

Re: Whether is from VBA access to ListBox falling out under the autofilter button? - VBA

big-dag
Something is impossible as you offered. At start of a macro with your line all list is deleted, and in "1" the column heading is interposed. Thus "1" the name to "Derive" is appropriated... Also the macro error is produced.

6

Re: Whether is from VBA access to ListBox falling out under the autofilter button? - VBA

Valll;
Only a macrorecorder

Sub Macro2 ()
'
' Macro2 Macro
'
Range ("Table1 [×èñëî]").Select
Application. CutCopyMode = False
Application. CutCopyMode = False
Range ("Table1 [[#All], [×èñëî]]").AdvancedFilter Action: = xlFilterCopy, _
CopyToRange: = Range ("C2"), Unique: = True
End Sub