Robert Berke
asked on
Display simple HTML or RTF in Excel user Form
I have a feeling I cannot do what I want to do, but I am hoping an expert can give me guidance.
My current application menu system shows several options in Listbox1 on Userform1:
When the user right clicks an option, the listbox1_mouseup routine shows detailed instructions by opening a corresponding word document, from "c:\DetailedInstructions\S howOrders. doc".
This is very slow, so I want to put a shorter version of the instructions directly under Listbox1 on the form.
I added a 1 inch by 4 inch control to the form: Userform1.WebBrowser1
then added this code to listbox1_mouseup:
This works nicely except for one thing. when the user clicks inside userform1.Webbrowser1, I want the hyperlinks to open "outside" of webBrowser1.
For instance let's say c:\ShortInstructions\ShowO rders.HTM contains two hyperlinks:
When user clicks Hyper1, Word should open
When user clicks Hyper2 msnbc should open using Chrome, Firefox or IE depending on the users default browser.
Am I out of luck?
By the way, I do not insist on an HTML solution. I will accept RTF or Wiki Formatting or any other solution that can be implemented with less than an hour or two of coding.
rberke
My current application menu system shows several options in Listbox1 on Userform1:
ShowOrders
EditOrders
ShowCustomers
When the user right clicks an option, the listbox1_mouseup routine shows detailed instructions by opening a corresponding word document, from "c:\DetailedInstructions\S
This is very slow, so I want to put a shorter version of the instructions directly under Listbox1 on the form.
I added a 1 inch by 4 inch control to the form: Userform1.WebBrowser1
then added this code to listbox1_mouseup:
userform1.webbrowser1.navigate "c:\ShortInstructions\ShowOrders.HTM"
This works nicely except for one thing. when the user clicks inside userform1.Webbrowser1, I want the hyperlinks to open "outside" of webBrowser1.
For instance let's say c:\ShortInstructions\ShowO
When user clicks Hyper1, Word should open
When user clicks Hyper2 msnbc should open using Chrome, Firefox or IE depending on the users default browser.
Am I out of luck?
By the way, I do not insist on an HTML solution. I will accept RTF or Wiki Formatting or any other solution that can be implemented with less than an hour or two of coding.
rberke
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're very welcome.
Good luck with the rest of your project.
Good luck with the rest of your project.
ASKER
Bob