Private Sub Workbook_Open() Sheet1.CommandButton1.Caption = "実行" Sheet1.Label1.Caption = "花の名前を選択してください" Sheet1.OptionButton1.Caption = "バラ" Sheet1.OptionButton2.Caption = "サクラ" Sheet1.OptionButton3.Caption = "キク" End Sub
Sub Macro1() Dim res(2) As Boolean res(0) = Sheet1.OptionButton1.Value res(1) = Sheet1.OptionButton2.Value res(2) = Sheet1.OptionButton3.Value dp = 1 End Sub