Popup message box

[Socrates]

Hi,

I have a workbook that has 22 tabs and I would like to have a popup message box giving general instructions on how to use the workbook. (company workbook) I am not familiar with VB coding at all, so I'm wondering if someone could help me out?

Thanks in advance for your help.

[Richard Buttrey]

Hi,

It's probable that there may be too many instructions to fit neatly into a VBA message box. It may therefore be better therefore to use a dedicated additional tab which contains all the instructions. This could be a hidden tab which is unhidden in response to a macro, which in turn could be invoked with a shortcut key. e.g. Ctrl-i. Another macro say Ctrl-h could be used to hide the instructions, or they could be hidden automatically in response to a move away from the Instructions tab.

This could be refined further if there are several sets of instructions since these could be hyperlinked to a 'Contents' list at the top of the Instructions tab.

The simplest way to achieve this if you are as yet unfamiliar with VBA would be to record a macro to hide the Instructions tab. Then another macro to unhide it, then apply the shortcuts to the two macros.

Regards