Insert X Rows To Table & Increment Date In Cell

I am currently in the process of trying to customise a Calendar Template (link below).



The workbook has two sheets:

Sheet 1 - Calendar (Front End)

Sheet 2 - Schedule



On Sheet 1 there is an Add Event button which allows users to enter in a Date and Event Name which is then added as a new row to a table on Sheet 2. What I am trying to do is to add the ability to do recurring entries such as Fortnightly and Monthly (possibly through the use of a third field with a drop down list).



Current Add Button Code

Please Login or Register  to view this content.

I found the below thread on this forum which has the same concept that I want but I am unable to get it to work properly. Is there anyone who might know if this is possible and if so what code I would use?


Insert New Row & Increment Number - https://www.ozgrid.com/forum/index.p...rement-number/

Calendar Template - https://www.get-digital-help.com/calendar-monthly-view/

Cross Link - https://www.mrexcel.com/board/thread...-date.1144613/
Cross Link - https://www.ozgrid.com/forum/index.p...l/#post1239167

Thanks in advance,

t0ny84

Update - After learning more about LOOPS I was able to mash together the following code (if it might help someone in the future)



[CODE=vba]Please Login or Register to view this content.[/CODE]