VBA INDEX MATCH Application to display value in Textbox

YingFa

New Member
Joined
Nov 4, 2019
Messages
36
I am trying to use Index Match to replace Vlookup Function so my textbox displays date format. If I use Vlookup my textbox shows numbers. I tried the below code but it is not displaying the value in the textbox once I run the code. Can I please have your help to make the code work?

Code:
Dim TBL As String
TBL= ComboBox7.Text

On Error Resume Next



Me.TextBox3.Value = Application.WorksheetFunction.Index(TBL, Sheets("PCARDatabase").Range("A4:A99"), Application.WorksheetFunction.Match(PCAR, Sheets("Data").Range("E4:E999"), 0), 1)

End Sub
A column has my TBL value and I want to mach it with the value in column E

Thank you.
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
10,223
Office Version
2007
Platform
Windows
You could explain with a simple example:
- What do you want to look for?
- Where are you going to look?
- And what do you want as a result?
 

Watch MrExcel Video

Forum statistics

Threads
1,089,979
Messages
5,411,636
Members
403,383
Latest member
Excelacity

This Week's Hot Topics

Top