Find an unknown method or keyword in VBE

In the code that I did not write, there is this line,
not in the module, but where you can put the code for each sheet (I do not know the name):

ActiveSheet.Sort_Existing.value = True

At first I thought it was the name of the range, but this is not the case, and the variable is not declared everywhere!

So, is this just a variable that you can configure as follows?

+4
source share
2 answers

ActiveSheet points to the current active sheet in the current active book

and Sort_Existingmost likely this is the name of the control ActiveX CheckBoxin this sheet

So:

  • if you want to specify another worksheet in the current active workbook that you can use:

    Worksheets("myOtherWorksheetName").Sort_Existing.value = True
    

    , Sort_Existing - , , ActiveX CheckBox

  • CheckBox , :

    ActiveSheet.MyOtherCheckBoxName.value = True
    

    MyOtherCheckBoxName, ActiveX CheckBox

+3

, - :

  • (Ctrl + F)
  • F2 VBE , , , , ,...

.
.
, ActiveSheet Me ( , )

+3

Source: https://habr.com/ru/post/1668709/


All Articles