Excel -- need to have a custom/floating dialog box (e.g., "Glossary")

Experts:

I'm currently working on developing a survey in Excel.

For some of the questions, it will be useful to have access to a "glossary" (up to ~ 5 glossary terms/definitions).

So, I'd like to use an image (JPG) that -- when clicked -- will bring up a floating dialog box... which obviously can be closed when not needed.

My question:   How can I use VBA to create this floating "glossary" to which I can add a few terms?

Note:  Please see attached XLSM which uses a message box on "Open"... same principle should be applied except I'd like to open it via clicking on the icon.

Thank you in advance!
EEH
Glossary.xlsm
ExpExchHelpAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Rory ArchibaldConnect With a Mentor Commented:
Use a userform and show it modelessly using:
Userformname.Show vbModeless

Open in new window

0
 
ExpExchHelpAuthor Commented:
Rory:

Any chance I can use the existing approach (see attached XLSM) and modify the code?  If yes, how?

EEH
0
 
ExpExchHelpAuthor Commented:
Never mind... I figured it out.  Thank you for chiming in anyways... 'much appreciated.
0
All Courses

From novice to tech pro — start learning today.