Task 2 – Recording adding another period

Actuary Forums › Forums › Learnings › Softwares › Excel VBA › Task › Macros › Recording macros and buttons › Task 2 – Recording adding another period

  • This topic is empty.
Viewing 1 post (of 1 total)
  • Author
    Posts
  • October 10, 2017 at 1:28 pm #22709
    Mayank Goyal
    Keymaster

       You keep your budget in Excel, and wants to be able to click on a button to add another period each month:

      fulfil your wishes by:

    • Recording a macro to accomplish the task shown, using a suitable combination of absolute and relative recording (and indeed the hint below)

    • Adding a button as shown and attaching this macro to it

      • Note that you are allowed to edit the macro after you’ve recorded it.

      Download the zip file [attachment=1]Task 2 – Recording adding another period.zip[/attachment]

      Download the answer [attachment=0]Task 2 answer – Recording adding another period.zip[/attachment]

      Login[/url] [/color]Register

      References : https://www.extendoffice.com/documents/excel/3866-excel-move-to-end-of-column-or-row.html” class=”bbcode_url”>https://www.extendoffice.com/documents/excel/3866-excel-move-to-end-of-column-or-row.html

  • Author
    Posts
    • Viewing 1 post (of 1 total)
    • You must be logged in to reply to this topic.

    Actuary Forums › Forums › Learnings › Softwares › Excel VBA › Task › Macros › Recording macros and buttons › Task 2 – Recording adding another period