You would need to add a combobox to the userform to select between 1 and 31 then instead of using the loop to enter the values, use the number (with two added) to give you the row to fill. Thus you can fill any row.

I have modified the document to do that. I have annotated the code so you can see how it works and make your own modifications.

Attached Files

test.docm (50.2 KB, 13 views)

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com