excel - 如何在 VBa 中使用 Vlookup?
问题描述
这是我为在 Vba 中使用 Vlookup 而编写的代码,但我不断收到
运行时错误 1004 无法获取 Worksheet 函数类的 Vlookup 属性
If WorksheetFunction.IsNA(Application.WorksheetFunction.VLookup(ListBox1.Selected(0), Range("B4:C7"), 2, False)) = True Then
'Create row
Range("EndlineFM").Select
Selection.Insert Shift:=xlDown
'Initialise Detail and montant of new row
Range("TotalF").Offset(-1, 0) = FraisM.ListBox1.Selected(0)
Range("TotalF").Offset(-1, 1) = CSng(FraisM.Chiffremontant)
我该如何解决?谢谢!
解决方案
Application.WorksheetFunction.VLookup
如果找不到匹配项,将始终引发运行时错误 - 您无法使用IsNA()
你可以这样做没有WorksheetFunction
:
Dim m
m = Application.VLookup(ListBox1.Selected(0), Range("B4:C7"), 2, False))
If IsError(m) Then
'Create row
Range("EndlineFM").Insert Shift:=xlDown
'Initialise Detail and montant of new row
Range("TotalF").Offset(-1, 0) = FraisM.ListBox1.Selected(0)
Range("TotalF").Offset(-1, 1) = CSng(FraisM.Chiffremontant)
'etc
推荐阅读
- git - 克隆,从 Github 中提取数据并将 repo 存储在 Flutter 本地
- r - Finding the optimal bandwidth for ksmooth() in R via cross-validation given a grid of bandwidth values
- python - How do I parse a string containing operations to a float in Python?
- azure-functions - Azure 函数绑定类型面临的问题
- javascript - How to copy the first row value to rest values using Angular8
- php - invalid_grant, bad request when refreshing a webpage after signed in though google api
- javascript - my bootstrap page doesnt show properly on mobile devices
- sql - MS SQL join query with transposing rows to columns
- python-3.x - Can we upload media files using URL in MediaFileUpload?
- visual-studio - Update Visual Studio 2019 from 16.8.6 to 16.9.3. Now build projects very slowly