How to pop up a message box whenever you click on a certain worksheet in excel
22.6 هزار بار بازدید -
5 سال پیش
-
What if you click on
What if you click on a worksheet and a message box pops up reminding you to do something important like saving the sheet or make a copy of the database or even thing like subscribing this channel: http://bit.ly/2GOqj7k
Hello everyone. Welcome to excel 10 tutorial, I’m your host Kazi and we are about to learn how to pop up a message box whenever you click on a certain worksheet in excel.
Let’s get started.
First go to the developer tab (here is how to add developer tab: Introducing Developer Tab Excel Vba ... )
Click on Visual Basic and then select “This Workbook”
Then paste the code. (Please subscribe and here goes the code: Patreon: 26496341)
Now save the workbook and make sure the save as file type is .xlsm
Here is something to understand Excel File Type: Excel File Types - Excel VBA Programm...
Now click on that Worksheet and you will see a pop up message saying you to subscribe the channel: http://bit.ly/2GOqj7k
Done. You have successfully setup a popup message box to show whenever you click on the specific worksheet.
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
Patreon: excel10tutorial
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ
Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Excel VBA Programming Course: http://bit.ly/excelvbacourse
Social media:
Facebook: Facebook: excel10tutorial
Twitter: Twitter: excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: Tumblr: excel10tutorial
Instagram: Instagram: excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial
Hello everyone. Welcome to excel 10 tutorial, I’m your host Kazi and we are about to learn how to pop up a message box whenever you click on a certain worksheet in excel.
Let’s get started.
First go to the developer tab (here is how to add developer tab: Introducing Developer Tab Excel Vba ... )
Click on Visual Basic and then select “This Workbook”
Then paste the code. (Please subscribe and here goes the code: Patreon: 26496341)
Now save the workbook and make sure the save as file type is .xlsm
Here is something to understand Excel File Type: Excel File Types - Excel VBA Programm...
Now click on that Worksheet and you will see a pop up message saying you to subscribe the channel: http://bit.ly/2GOqj7k
Done. You have successfully setup a popup message box to show whenever you click on the specific worksheet.
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
Patreon: excel10tutorial
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ
Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Excel VBA Programming Course: http://bit.ly/excelvbacourse
Social media:
Facebook: Facebook: excel10tutorial
Twitter: Twitter: excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: Tumblr: excel10tutorial
Instagram: Instagram: excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial
5 سال پیش
در تاریخ 1398/02/10 منتشر شده
است.
22,649
بـار بازدید شده