PDA

View Full Version : Choices from User Form



jgoods
04-23-2015, 10:12 AM
If I have a user form with three options in a frame (average, max, min), how do I write a code so that it calculates the option selected by the user?
There is also a list box that has three options, so the user selects what they want calculated and from which worksheet.

Thank you!

Paul_Hossler
04-23-2015, 10:15 AM
Assuming you've renamed the Option Buttons




If obMax Then
...code....
ElseIf obMin Then
... code ...
ElseIf obAvg Then
.... code ....
End If