This was motivated by a question in the mrexcel.com forum. The person asking for help had multiple comboboxes in a userform, each of which contained the same items, A through L for the purpose of this exercise. These items were sorted alphabetically. He wanted that when the user selected an item in any of the comboboxes, that item would become unavailable in all of the other comboboxes. Further, if the user selected a new item in a combobox already containing a selection, the old item would be made available in the other comboboxes while still maintaining the sort order for the items. For the original request see http://www.mrexcel.com/forum/showthread.php?t=541741.

For a version in a page by itself (i.e., not in a scrollable iframe as below) visit http://www.tushar-mehta.com/publish_train/xl_vba_cases/1053%20class%20to%20manage%20multiple%20controls%20in%20userform.shtml

Tushar Mehta

For a version in a page by itself (i.e., not in a scrollable iframe as below) visit http://www.tushar-mehta.com/publish_train/xl_vba_cases/0906%20conways%20game%20of%20life.shtml

Tushar Mehta

For a version in a page by itself (i.e., not in a scrollable iframe as below) visit http://www.tushar-mehta.com/publish_train/xl_vba_cases/0120-1%20banded%20rows.shtml

Tushar Mehta

Those who have used an Excel 2010 slicer may have wanted to see that capability in earlier versions of Excel. I like what Microsoft did with slicers in 2010 and wanted to extend that capability backwards. For those who haven’t used a slicer, it is a filter on a particular pivot field shown as an independent object.

So, with TM Retro Slicer, create a slicer in any version of Excel from 2003 to 2010.

TM Retro Slicer works with versions of Excel from 2003 to 2010. Once enabled, a slicer will be visible on the worksheet.

Switching worksheets will hide the slicer and it will reappear when the worksheet is reactivated.

The slicer will remain across a workbook close and re-open.

For more on this time-limited beta version of what will be a shareware solution, please visit http://www.tushar-mehta.com/excel/software/retro_slicer/index.htm

– Tushar Mehta

Tornado diagrams graphically display the result of single-factor sensitivity analysis. This lets one evaluate the risk associated with the uncertainty in each of the variables that affect the outcome. Single-factor analysis means that we measure the effect on the outcome of each factor, one at a time, while holding the others at their nominal (or base) value. The software adjusts each factor between the specified minimum (or low) and maximum (or high) values while recording the value of the outcome. It then plots the resulting data in a bar chart. A typical diagram looks like Figure 1, which shows the effect of four parameters on the result. The uncertainty in the parameter associated with the largest bar, the one at the top of the chart, has the maximum impact on the result, with each successive lower bar having a lesser impact. This arrangement is why the result is called a Tornado Diagram.

Figure 1

The vertical axis corresponds to the result when all the factors (also called parameters or variables) are at their respective nominal (or base) values. For each of the uncertain parameters, the chart contains one horizontal bar and two sets of numbers, one of the left and the other to the right of the bar. Each set of numbers contains the result value (upper number) and the value of the parameter at which the result was reached (the lower number within curly brackets). Negative numbers are shown in parenthesis.

For more on this shareware product, please visit http://www.tushar-mehta.com/excel/software/tornado/index.html

– Tushar Mehta

For a version in a page by itself (i.e., not in a scrollable iframe as below) visit http://www.tushar-mehta.com/publish_train/xl_vba_cases/1051 Add userform items on the fly.shtml

Tushar Mehta

TM Chart Leader Lines simplifies the management of leader lines in a chart. This add-in, which works only with Excel 2007 or later versions of Excel, allows the easy interactive arrangement of data labels and their associated leader lines.

What should not come as a surprise to anyone who has worked closely with charts and VBA is that some of the required information was only available through the old XLM interface. What I found surprising is that some of the features to adjust chart elements and some of the XLM features worked well in Excel 2007 (and 2010) but not in 2003. After a fair amount of effort I decided to limit usability to 2007 or later. While struggling with the issues, I meant to document and share them. But, as is often the case, getting the task done overshadowed the intent to document the issues. {grin}

For more on this shareware product, visit http://www.tushar-mehta.com/excel/software/chart_leader_lines/

– Tushar Mehta

For a version in a page by itself (i.e., not in a scrollable iframe as below) visit http://www.tushar-mehta.com/publish_train/xl_vba_cases/13-03%20Shapes%20on%20a%20Map.shtml

Tushar Mehta