Program kursa

5 Chapters · 26 Lessons

  1. 1

    UVOD U VBA

    1. (Included in full purchase)

      Snimanje macroa

    2. (Included in full purchase)

      Posebne ćelije

    3. (Included in full purchase)

      Apsolutne vs relativne reference

    4. (Included in full purchase)

      7 načina za pokretanje koda

    5. (Included in full purchase)

      Visual basic editor i prečice

  2. 2

    RANGE, SHEET I WORKBOOK

    1. (Included in full purchase)

      Pozivanje ćelija u VBA

    2. (Included in full purchase)

      Svojstva i metode za range

    3. (Included in full purchase)

      Pronalaženje poslednjeg reda

    4. (Included in full purchase)

      Kopiranje

    5. (Included in full purchase)

      Referenciranje sheet-a

    6. (Included in full purchase)

      Referenciranje workbook-a

    7. (Included in full purchase)

      Čuvanje hard-coded verzije bez macroa

  3. 3

    VARIJABLE

    1. (Included in full purchase)

      Tipovi varijabli

    2. (Included in full purchase)

      Definisanje varijabli, nizova i konstanti

    3. (Included in full purchase)

      Object varijable

    4. (Included in full purchase)

      Gde čuvamo varijablu?

  4. 4

    PETLJE

    1. (Included in full purchase)

      With petlja

    2. (Included in full purchase)

      For Each petlja

    3. (Included in full purchase)

      If ... Then, Else, ElseIf

    4. (Included in full purchase)

      Select Case, GoTo

    5. (Included in full purchase)

      Broj formula u sheet-u

  5. 5

    FUNKCIJE

    1. (Included in full purchase)

      VBA vs Excel funkcije

    2. (Included in full purchase)

      Tekstualne funkcije

    3. (Included in full purchase)

      Datumske funkcije

    4. (Included in full purchase)

      Message Box

    5. (Included in full purchase)

      Input Box