前提・実現したいこと
こんにちわ。Excel VBAで初心者です。
自分でシフト表を作りたくて、コンボボックスで
開始と終了で時と分に分けてフォーム作成を勉強中です。
時間と分を設定する際にどうしても、
同じ数字を使うのですが、
これは関数などで省略できますか?
お詳しい方いましたら、お願い申し上げます。
発生している問題・エラーメッセージ
エラーメッセージ
該当のソースコード
Private Sub Starthour_Change() //シフト開始時 With Starthour Sheet2.Range("I39").Value = .ListIndex Sheet2.Range("I39").Value = Starthour End With End Sub Private Sub StartMinutes_Change() With StartMinutes 'シフト開始分 Sheet2.Range("K39").Value = .ListIndex Sheet2.Range("K39").Value = StartMinutes End With End Sub Private Sub Endhour_Change() //シフト終了時 With Endhour Sheet2.Range("I40").Value = .ListIndex Sheet2.Range("I40").Value = Endhour End With End Sub Private Sub EndMinutes_Change() With EndMinutes 'シフト終了時分 Sheet2.Range("K40").Value = .ListIndex Sheet2.Range("K40").Value = EndMinutes End With End Sub Private Sub UserForm_Initialize() //'シフト開始時 With Starthour .AddItem "" .AddItem "01" .AddItem "02" .AddItem "03" .AddItem "04" .AddItem "05" .AddItem "06" .AddItem "07" .AddItem "08" .AddItem "09" .AddItem "10" .AddItem "11" .AddItem "12" .AddItem "13" .AddItem "14" .AddItem "15" .AddItem "16" .AddItem "17" .AddItem "18" .AddItem "19" .AddItem "20" .AddItem "21" .AddItem "22" .AddItem "23" .AddItem "24" End With End Sub With StartMinutes 'シフト開始分 .AddItem "" .AddItem "01" .AddItem "02" .AddItem "03" .AddItem "04" .AddItem "05" .AddItem "06" .AddItem "07" .AddItem "08" .AddItem "09" .AddItem "10" .AddItem "11" .AddItem "12" .AddItem "13" .AddItem "14" .AddItem "15" .AddItem "16" .AddItem "17" .AddItem "18" .AddItem "19" .AddItem "20" .AddItem "21" .AddItem "22" .AddItem "23" .AddItem "24" .AddItem "25" .AddItem "26" .AddItem "27" .AddItem "28" .AddItem "29" .AddItem "30" .AddItem "31" .AddItem "32" .AddItem "33" .AddItem "34" .AddItem "35" .AddItem "36" .AddItem "37" .AddItem "38" .AddItem "39" .AddItem "40" .AddItem "41" .AddItem "42" .AddItem "43" .AddItem "44" .AddItem "45" .AddItem "46" .AddItem "47" .AddItem "48" .AddItem "49" .AddItem "50" .AddItem "51" .AddItem "52" .AddItem "53" .AddItem "54" .AddItem "55" .AddItem "56" .AddItem "57" .AddItem "58" .AddItem "59" End With //シフト終了時 With Endhour .AddItem "" .AddItem "01" .AddItem "02" .AddItem "03" .AddItem "04" .AddItem "05" .AddItem "06" .AddItem "07" .AddItem "08" .AddItem "09" .AddItem "10" .AddItem "11" .AddItem "12" .AddItem "13" .AddItem "14" .AddItem "15" .AddItem "16" .AddItem "17" .AddItem "18" .AddItem "19" .AddItem "20" .AddItem "21" .AddItem "22" .AddItem "23" .AddItem "24" End With End Sub With StartMinutes 'シフト終了分 .AddItem "" .AddItem "01" .AddItem "02" .AddItem "03" .AddItem "04" .AddItem "05" .AddItem "06" .AddItem "07" .AddItem "08" .AddItem "09" .AddItem "10" .AddItem "11" .AddItem "12" .AddItem "13" .AddItem "14" .AddItem "15" .AddItem "16" .AddItem "17" .AddItem "18" .AddItem "19" .AddItem "20" .AddItem "21" .AddItem "22" .AddItem "23" .AddItem "24" .AddItem "25" .AddItem "26" .AddItem "27" .AddItem "28" .AddItem "29" .AddItem "30" .AddItem "31" .AddItem "32" .AddItem "33" .AddItem "34" .AddItem "35" .AddItem "36" .AddItem "37" .AddItem "38" .AddItem "39" .AddItem "40" .AddItem "41" .AddItem "42" .AddItem "43" .AddItem "44" .AddItem "45" .AddItem "46" .AddItem "47" .AddItem "48" .AddItem "49" .AddItem "50" .AddItem "51" .AddItem "52" .AddItem "53" .AddItem "54" .AddItem "55" .AddItem "56" .AddItem "57" .AddItem "58" .AddItem "59" End With End Sub
試したこと
ここに問題に対して試したことを記載してください。
補足情報(FW/ツールのバージョンなど)
Excel VBA
ここにより詳細な情報を記載してください。