Smarter if-sentence?

[Stevenn]

Can I write this smarter? Maybe a select case-statement?

If A Then
    Let MethodType = 0
ElseIf B Then
    Let MethodType = 1
ElseIf C Then
    Let MethodType = 2
End If

 

[hurgadion]

Hi,
would you like to describe more in detail conditions A, B, C ? Best regards.

 

[Stevenn]

Actually, it should be radio buttons in a UserForm. I have 3 buttons, and whether the user have clicked on the first, second or third button it will determine the MethodType to be 0, 1, or 2. So in my example A, B, and C will just be Me.btnFirstMethod.Value etc. And their values will be true if they were selected.

 

[hurgadion]

I think that if there is a regule between the Values of Me. (for example the Values are equal to 3, 7, 17) then Your Code can look like this:

MethodType = Int(Me.btnFirstMethod.Value / 7)

Best regards.

 

[Stevenn]

But I have 3 different radio buttons: btnFirstMethod, btnSecondMethod, and btnThirdMethod. And depending on which button the user have clicked I want to determine the MethodType variable.

 

[hurgadion]

So,
try change words First, Second, Third on the analogous numeric Values: 1, 2, 3 and try using the code:

Right(Replace(Application.Caller, "Method", ""), 1)-1

Best regards.