I have a Multipage Userform with four pages that has the same layout and function. My initial goal is that every time I fill the the textbox on each page, it will be posted to a specific range. But then it makes the file size too big, I assume because each page has many CommandButton but I don't want to delete any of the CommandButton.
Screenshot 2023-01-17 082046.jpg
Is it possible that I only use a single page Userform to perform this task? So that the same textbox can be used to fill B or G or L, depending on which starting Cell I choose before opening the Userform? or maybe simplify the code so the file size won't be too big?
Lets say I clik on any Cell on Column A before opening the userform, than Textbox 1 will fill column B and Textbox 2 will fill column C (on the same row) when I save it. But if I click on Cell F before opening up the userform, then Textbox 1 will fill column G and Textbox 2 will fill column H. SO the range changes depending on the starting cell.
Here I attach the Code for the Userform in Ms.Word because my excel file is too big. Thank you so much for your help.
Notes: "Simpan" means "Save"
Bookmarks