Userform/Command Button to Appear in New Worksheet

Hi everyone! I made a userform that collects and transfers data to a certain worksheet. I assigned a button to open the worksheet in that specific page. How can I get that userform or command b...

excel

Macros and VBA

Haytham Amairah
Feb 21, 2020
Mr_Buttons

Hi,

Instead of the embedded button on the worksheet, you can create a macro in the https://support.office.com/en-us/article/create-and-save-all-your-macros-in-a-single-workbook-66c97ab3-11c2-44db-b021-ae005a9bc790 to open the UserForm and add this macro to the Quick Access Toolbar or in a new custom ribbon tab by following the steps in the link below:
https://support.office.com/en-us/article/assign-a-macro-to-a-button-728c83ec-61d0-40bd-b6ba-927f84eb5d2c

Also, you need to modify the VBA code to make it applied to all worksheets, by replacing:
Sheet1
with:
ActiveSheet

Hope that helps

Haytham Amairah

Silver Contributor

Feb 21, 2020

Mr_Buttons

Hi,

Instead of the embedded button on the worksheet, you can create a macro in the https://support.office.com/en-us/article/create-and-save-all-your-macros-in-a-single-workbook-66c97ab3-11c2-44db-b021-ae005a9bc790 to open the UserForm and add this macro to the Quick Access Toolbar or in a new custom ribbon tab by following the steps in the link below:

https://support.office.com/en-us/article/assign-a-macro-to-a-button-728c83ec-61d0-40bd-b6ba-927f84eb5d2c

Also, you need to modify the VBA code to make it applied to all worksheets, by replacing:

Sheet1

with:

ActiveSheet

Hope that helps