Replace “e:\test.html” with the actual path to the desired HTML file that you want to insert to the Outlook email message body.
To explore the folders ONLy, you can provide the Dialog type as msoFileDialogFolderPicker Design the user interface as shown in the image. Add the subroutine Write the click event code for the command button that calls the subroutine Test the application Step 1) User Interface. Below is a step by step process on how to Call Sub in VBA: Design the user interface and set the properties for the user controls. It's easily accessible you don't need anything more than a working version of Microsoft Office. Built into Microsoft Excel, this language can be used to program apps right inside an Excel worksheet. When I bring my cursor to this cell, to change cursor pointer to pointer like in hyperlink.Thanks I would like to trigger an event once i click on a cell, for example I click one click on a cell (1,1) and it run some macro.2. I often tend to see the Like operator as the last resort before using Regular.
The VBA Like operator is something so useful I am often surprised how rarely it is used in Excel and Access VBA.
