Using Html As A Interface For Vba Excel

I am looking to develop an Excel based VBA system, as opposed to displaying and entering data in user forms, is it possible to use HTML as an interface to do so? And if so, can you

Solution 1:

Use the Microsoft Web Browser ActiveX control. You can put this control on a userform or position it directly over your worksheet. Your VBA code will then populate the web browser (basically Internet Explorer in a frame) with whatever HTML you generate. (In my experience, you'll likely have to generate the HTML and save it as a temp file before pushing it to the web browser control - but my memory may be fuzzy on this.)