ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Sheet msgbox (https://www.excelbanter.com/excel-programming/294912-sheet-msgbox.html)

Fraggs[_4_]

Sheet msgbox
 
I know how to create the msgbox for the whole workbook so that when yo
open the workbook the msgbox appears, thats fine. Is it possible an
if so how do I create a msgbox just for a sheet so that when it i
selected a msgbox appears

--
Message posted from http://www.ExcelForum.com


Frank Kabel

Sheet msgbox
 
Hi
have a look at the workbook sheetactivate event

--
Regards
Frank Kabel
Frankfurt, Germany


I know how to create the msgbox for the whole workbook so that when
you open the workbook the msgbox appears, thats fine. Is it possible
and if so how do I create a msgbox just for a sheet so that when it

is
selected a msgbox appears?


---
Message posted from http://www.ExcelForum.com/



Bob Phillips[_6_]

Sheet msgbox
 
Frank' suggestion will apply to al sheets. If you want it to apply to just
one sheet use the Worksheet_Activate event, and put the code in that
worksheet code module. Be aware that if you close the workbook with that
worksheet active, when you open the workbook again, that sheet will be
displayed, but it does not trigger the activate.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Frank Kabel" wrote in message
...
Hi
have a look at the workbook sheetactivate event

--
Regards
Frank Kabel
Frankfurt, Germany


I know how to create the msgbox for the whole workbook so that when
you open the workbook the msgbox appears, thats fine. Is it possible
and if so how do I create a msgbox just for a sheet so that when it

is
selected a msgbox appears?


---
Message posted from http://www.ExcelForum.com/






All times are GMT +1. The time now is 06:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com