How to use UserForm to run the VBA code?

Question

Hi,

I use VBA to format my worksheet, but it is easy to get error. I want to use UserForm to run the VBA code. I made some adjustments also added some new features. The UserForm UI preview and relevant remarks as show below:

Instructions

BUTTONS

There are 3 buttons in total.

Clear button: click to clear all values for currently displayed page where in FRAME

Preview button: click to create a new sheet and then name as Preview, layout the format by the values from Textbox; if the Preview worksheet is existed, then to update the format if there are changed.

Apply to worksheet button: save first to avoid errors, then format the layout for the worksheet(s) if the name that contained with (FM) characters, such as sheet1(FM), (FM)sheet1 and sheet(FM)1; If the worksheet(s) is protected, then pop up MsgBox “please unprotect the worksheet(s) before you run this application. “

FRAME

Require to enter the values to the Textboxs (as shown above - Red Notes). Depending on the content of the labels, the related properties are also different (as shown above - Green Notes)

Optional checkboxes – to make changes according to the content if it is clicked, as shown below:

MULTI PAGE

There are 4 pages in total, each page contains Textbox. Depending on the content of the title, the related properties are also different.

• If the Textbox is blank, the corresponding command does not make any changes
• If there are two or more Textbox with values in the same group (as shown above - Purple Notes: Group 1, Group2 and Group3), then make changes based by values

Sample text checkboxes

Click to use cell style name to be a sample text and enter to the relevant cell (as shown above - Blue Notes))

Here is my file for reference。
https://1drv.ms/x/s!AibaAz5STOvFiCLC5f9nMMdZvtAc?e=h9dUTS

How can I use VBA code to achieve the above functions please?

Many Thanks

J.