[算表] 使用combox值進行vlookup查詢
軟體:EXCEL
版本:2016
欲使用 COMBOX1.VALUE 的值
經由VLOOKUP函數查詢LIST1工作表
其結果寫入TEXTBOX7值內
Private Sub ComboBox1_Change()
Dim data As Range
Dim Str2 As String
Dim ACC_CODE As String
Set data = [ACCCODE]
TextBox7.Text = Appliction.WorksheetFunction.VLookup(ComboBox1.Value,
list2.Range("ACCCODE"), 2, False)
END SUB
執行後出現 錯誤'424'
此數需要物件請問這裡要怎麼修正
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 114.37.195.11
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1505110138.A.F04.html
→
09/11 18:20, , 1F
09/11 18:20, 1F
→
09/11 18:21, , 2F
09/11 18:21, 2F
→
09/11 18:39, , 3F
09/11 18:39, 3F
→
09/11 18:55, , 4F
09/11 18:55, 4F
→
09/11 18:55, , 5F
09/11 18:55, 5F
→
09/11 18:55, , 6F
09/11 18:55, 6F
→
09/11 19:01, , 7F
09/11 19:01, 7F
→
09/11 19:22, , 8F
09/11 19:22, 8F
→
09/11 19:22, , 9F
09/11 19:22, 9F
→
09/12 23:22, , 10F
09/12 23:22, 10F
→
09/12 23:22, , 11F
09/12 23:22, 11F
→
09/12 23:45, , 12F
09/12 23:45, 12F
→
09/12 23:46, , 13F
09/12 23:46, 13F
→
09/12 23:47, , 14F
09/12 23:47, 14F
Office 近期熱門文章
PTT數位生活區 即時熱門文章