I am trying to create a userform that will enable the user to set parameters for grades. I have two the dropdown boxes with numers 1 to 100. The first to define the minimum value and the second for the max. The grades are A C E F. I can't work out how to link the two comboboxes to the cells on my worksheet in a way that will automatically give the grade from the defined parameters. Any help would be much appreciated. Using XL 2010.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
UserForm with defined ranges
- Thread starter Xmas
- Start date
Excel Facts
Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Similar threads
- Replies
- 0
- Views
- 582
- Solved
- Replies
- 3
- Views
- 552
- Replies
- 7
- Views
- 1K
- Solved
- Replies
- 3
- Views
- 979
