Categories Corporate
Professional eBook

Excel VBA: Working with Excel Elements

Excel VBA programming - Part 2

76
Language :  English
This VBA book series has been developed in the past eight years. They contain many practical explanations and examples. They can also be viewed as a collection of daily routines.
Professional Plus subscription free for the first 30 days, then $6.99/mo
Få åtkomst till boken på vår läsplatta. Ingen reklam i boken.
Description
Content

The VBA book series

  • Part 1: Introduction to VBA,
  • Part 2: Beginning / entry to VBA,
  • Part 3: VBA Programming,
  • Part 4: VBA object-oriented

This VBA book series has been developed in the past eight years. They contain many practical explanations and examples. They can also be viewed as a collection of daily routines.The first part describes the VBA environment as well as calls, operations, handling.The second part describes the recording and writing of smaller procedures.The third part describes how to deal with cells, columns, rows, tables, diagrams, and files partially with external files.The fourth part discusses the object-oriented programming with control elements, as well as describing the handling of User Form.

About the author

Harun Kaplan was born on 25 March 1964 in Ankara, Turkey. There he spent his childhood and attended primary and secondary school. He lived with his mother, grandfather and four siblings. During his free-time he earned pocket money at stations and stops by selling water or polishing shoes.He wanted to be an officer. However, he failed at the second entrance exam in Istanbul. He then moved to Germany and reunited with his father. Given that his schooling was not recognized in Germany, he decided to repeat his secondary education while also learning the German language. During this time, he began working at Daimler AG in Stuttgart as a dishwasher. At the same time, he helped a friend sell produce at a local market. One year later, he passed the entrance examinations for a training center as a locksmith, now an industrial mechanic, at Daimler AG.

  • Introduction
  1. Programming
    1. Event Procedure
    2. Handling Workbooks 
    3. Worksheets
    4. Handling with “Range“ and “Cells“
    5. Handling “SpecialCells“ 
    6. Handling Comments
    7. Setting of cell
    8. Offset (new position) of cursor
    9. Created a link
    10. Setting the best rows wide and best column height
    11. Defining a print area, header, and footer
    12. Automatic filtering
  • Bibliography 
About the Author

Harun Kaplan