How to pop up a message box whenever you click on a certain worksheet in excel

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.

Click on Visual Basic and then select “This Workbook”

Now save the workbook and make sure the save as file type is .xlsm

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
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Playlists:

Social media:

[raissabenoccithibes]

Simple and informative, at the same time! Thank you and best wishes!

[aishah.a]

Hi sir. I need to create a pop up message box before closed the workbook. If a cell value are less than 39, a pop message of "Total Hours are less than 39". Do you have a code for it?

[garvitvarshney]

Hello sir plz help..
i want a message when i click in every cell in excel sheet.
What code i run?
Please reply sir what code i change?

[emilysmith]

I am at the point where I hit the developer tab, visual basic, but then how do I add the white box to copy and paste the code? I have the code already. Also, I think I know where to add my message in place of yours, but where exactly?

[nazishfatima]

The video is very helpful i want a code ..i fill the form but didn't get a code