HW#10 - VBA Controls

The following spreadsheet is used to solve Manning's Equation for a circular channel. The option groups are used to make the spreadsheet easier to use.  When the user clicks on one of the units options, the Units (u) cell is set to the proper value and the units labels are updated accordingly.  When the user clicks on one of the options in the "Type of Pipe" section, the appropriate value for Manning's roughness is loaded into the Roughness (n) cell.

Click here to download a copy of this spreadsheet minus the controls.  To complete the spreadsheet, do the following:

a. Add a pair of ActiveX option controls for the units.  Add code for the click event for the English option so that it changes the u value to 1.49. When the Metric option is selected, change u to 1.0.  Also update the units labels for r, D, y, and Q using your VB code.

b. Add four option controls as shown for the roughness coefficient.  When the user clicks on one of the options, set the n value accordingly.

Note that once you change the value for u or n, Excel will automatically update the formula calculations.

IMPORTANT: In order for your option controls to work properly, you will need to organize them into two groups using the Group Name property.  It doesn't matter what group names you use as long as all controls in each group have the same name.  If all option controls on the spreadsheet have the same name, you will only be able to select one option out of all six controls on the sheet.

Submittal Instructions:

1. Be sure to save the changes to your spreadsheet.

2. Upload your spreadsheet via Learning Suite.