The problem I am having is that I currently have a Table of Contents Page that has a listbox of all the current worksheets in the workbook. I am creating a "New" worksheet function that inserts a new worksheet.
I have some knowledge but very little. I have the Userform_Activate() downpat but I am not sure how to reactivate the userform with its new index that has been inserted.