Friend was looking for a way to create a help (manual) in Excel, he wanted to use a Userform to display it.
To keep it simple, he has put a WordObject on the worksheet in the worksheet.
The area that covers the Word document is converted to a picture in jpg format, which can be easily loaded into a Userform.image.
This image is saved in Ms Windows temporary folder, from which the Userform.image can load the image.
It takes too long to load a WordObject into a Userform every time, and if the help word file is not there, the help will not work.
Hence, WordObject is embedded in a Worksheet.
Hope it helps someone. Provided the code with Rem lines. But forgive me if it's crooked English.
Module Code
Userform Code
Bookmarks