Self-Devpt. Nuggets™

<I>[This is a tutorial note for members of my ExcelVB club]</I>

This week I’ve prepared an example MS ExcelVB driven workbook with code that enables you click a button I linked to it on a worksheet, to open a website of your choice in a new browser window.

In order to allow you fully test it with web addresses of your choice, I’ve setup a table in the worksheet in which you can type a list of website names (e.g Yahoomail, Google, Tayosolagbade etc) in one column, and their corresponding TLDs (Top Level Domains e.g com, net, biz etc) in the next column.

Once you do the above, your entries become available in the 2 in-cell drop menus I’ve setup next to the website list table.

Next simply click in the yellow coloured cells to use the in-cell drop menus to choose the website name and TLD you want.

Notice how the compound formula in the cell between the above 2 uses the selections you make from the drop menu to build a full URL.

Once that happens, click the command button labelled “Visit Website” and watch as the ExcelVb code opens a new browser window and loads the URL you built in it.

See my instructions in the example workbook (emailed to you). I’ve also inserted tips in form of in-cell comments in the yellow coloured cells.

During the week, I’ll send you detailed explanations of how the code works, and how to build the workbook from scratch, PLUS potential uses to which you can put this kind of ExcelVB driven workbook solution.