I have a MultiPage item on my UserForm. It has several pages, each page requires information from and submits information to different worksheets in my workbook. Additionally there are checkboxes on each page that I want to write to cells in each worksheet.
E.G. CheckBox1.Value = True Then
Sheet?.Cells("1", "A") = "Y"
CheckBox2.Value = True Then
Sheet?.Cells("1", "B") = "Y"
These Y's add figures to a total amount, and where the ? I want it to be the relevant worksheet number for the page selected.
How can I make it that when I select a page, the focus is changed to the specific worksheet.