質問するログイン新規登録

回答編集履歴

1

誤字の修正

2020/03/27 09:34

投稿

mattuwan
mattuwan

スコア2167

answer CHANGED
@@ -9,7 +9,7 @@
9
9
 
10
10
  Set rngList = Worksheets("Sheet1").Range("C1").CurrentRegion
11
11
  Set rngKey = rngList.Columns("E").Cells
12
- strBegin = CLng(CDate(Me.TextBox2.test)) & Me.TextBox1.Text
12
+ strBegin = CLng(CDate(Me.TextBox2.Text)) & Me.TextBox1.Text
13
13
  strEnd = CLng(CDate(Me.TextBox3.Text)) & Me.TextBox1.Text
14
14
 
15
15
  '検索