Filtering entries




With this dialog you can select entries to move into the other list.

Action

create new selection: creates a new selection
add to selection: adds entries to an existing selection
filter within existing selection: filters out entries within an existing selection
remove from selection: delete entries from an existing selection


Filter

Filter conditions for the actions described above:

Mode

With this switch you specify how the following filter terms
are combined (AND / OR).


Source lines

Filtering with the help of the source–code lines.

[line contains] / [line does NOT contain]

Enter text
which is contained or NOT contained in a line of source–code.

Hint: Press of Ctrl+Tab to insert the selected
code line into the list.

No distinction is made between upper case and lower case.
Wildcards (such as "*" or "?") are ineffective.

[in module] / [NOT in module]

Select a module
which contains or does NOT contain a source–code line.


Identifier

Filtering based on the identifier whose name appears
in the source–code lines within strings.

[name contains] / [name contains NOT]

Enter a string,
which is contained or is NOT contained in the name of an identifier.

No distinction is made between upper case and lower case.
Wildcards (such as "*" or "?") are ineffective

Hint: Pressing Ctrl+Tab inserts the name
of the currently selected identifier.

Should ONLY be filtered by a specific identifier,
then sort the list by the identifier name,
select an entry with this name, and press Ctrl + Space.

[from module] / [NOT form module]

Select a module
in which the identifier should be declared or should not be declared.


Module, in which the identifier is declared ("from module")

Filters all entries in which the origin–module of the identifier
is contained in the source code line or the displayed string.
(you find the origin module in the column "from module").


Line and identifier

Filtering with the help of the modules, in which source program line or identifier are localised.

Entries are only selected if the source–code line
and the identifier, whose name appears in a character string,
occur in the same or NOT in the same module.

This filter is helpful if for example, several worksheets or UserForms contain
control elements with the same name,
but they are only used locally in the respective modules:

Sheet 1: contains button "Print"
VBA modul: contains code Shapes("Print").Visible = True

Sheet 2: contains button "Print"
VBA modul: contains code Shapes("Print").Visible = False

CrunchCode is not a compiler and cannot recognise
whether 'Shapes("Print")' refer to the local
or to the other worksheet.

Therefore, ALL positions are first listed
in combination with ALL possible identifiers:

in module string         is REFERENCE to from module
ŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻ
Sheet 1 Shapes("Print").Visible = True Button Print Sheet 1
Sheet 1 Shapes("Print").Visible = True Button Print Sheet 2
Sheet 2 Shapes("Print").Visible = False Button Print Sheet 1
Sheet 2 Shapes("Print").Visible = False Button Print Sheet 2


The filter option "[NOT in same module]" then selects only the entries
that represent NOT a real reference to the LOCAL control element
(source–code line and identifier [button] are not in the same module).
The so selected lines can then e.g. be moved into the lower list.

in module string         is REFERENCE to from module
ŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻŻ
Sheet 1 Shapes("Print").Visible = True Button Print Sheet 1
       ğğ Sheet 1 Shapes("Print").Visible = True Button Print Sheet 2 ĞĞ
       ğğ Sheet 2 Shapes("Print").Visible = False Button Print Sheet 1 ĞĞ
Sheet 2 Shapes("Print").Visible = False Button Print Sheet 2


Status

Filtering with the help of the information in the column "Status".

# Entries that are new or changed compared to a previous program run.

~ Entries that that have been hidden in the CURRENT program run. (*)

= Entries that that have been hidden in the PREVIOUS program run. (*)

(*) therewith you can repeat previous actions quickly