Dialog box - Excel 2010

[ElianaMG]

I need to insert in my workbook a dialog box which needs to be visible when switching from one worksheet to another. This dialog box needs to open automatically as the workbook is opened and buttons associated to macros will be placed over it. I have tried as a message box, but it doesn't allow me to switch through the tabs. I believe this needs to be written as a User Form, but not sure how to make it visible all the time... The expected result should be similar to the attached image. Does anyone knows how can this be written? I am using Office 2010, if that helps... Thank you.

ScreenHunter_02 Dec. 23 09.54.jpg

[davesexcel]

That would be a userform, google "create a userform in excel" to find many examples.

[sktneer]

If you have already designed your userform1, you may try the below codes to achieve this......

Copy the below codes and place them on ThisWorkbook Module.....

Please Login or Register  to view this content.

Does this help?

[ElianaMG]

Hi sktneer, this worked almost as expected... now even if I close the box, ifI go to another tab it opens again, and even if I am looking into another workbook, the dialog box is there... so is there a way to restrict its view only to the workbook and, once close, it remains close unless the user call it again? Thank you

[sktneer]

Place below code on the Sheet Module of the Sheet on which you want to show the userform. To do so, right click on that Sheet Tab --> View Code and paste the following code on the opened code window.

Please Login or Register  to view this content.

And delete the following code from ThisWorkbook module.

Please Login or Register  to view this content.

Hope this helps.

[ElianaMG]

Hi sktneer, thanks that helped a lot.

[sktneer]

You're welcome. Glad I could help.