patel51
11-27-2008, 09:17 PM
ok, i am trying to write a select case statement. depending on the case, i want to change the caption of another button to the correct value. so far this is what i have;
Select Case mintTurn
Case "1"
cmdRoll.Caption = "Roll the dice," & "Range(C5).Value" & "!"
Case "2"
cmdRoll.Caption = "Roll the dice," & "Range(E5).Value" & "!"
End Select
i have the values that i want already stored in cells C5 and E5, but how do i write the syntax so that if its case 1, then the caption will change to "Roll the dice, (whatever is stored in C5)!"
Select Case mintTurn
Case "1"
cmdRoll.Caption = "Roll the dice," & "Range(C5).Value" & "!"
Case "2"
cmdRoll.Caption = "Roll the dice," & "Range(E5).Value" & "!"
End Select
i have the values that i want already stored in cells C5 and E5, but how do i write the syntax so that if its case 1, then the caption will change to "Roll the dice, (whatever is stored in C5)!"