Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto look up
I use this code below to look up a number in a sheet
I was wanting to extend this to be able to have both textbox1 and textbox2 to have the look up ability Private Sub TextBox1_Enter() Dim ans On Error Resume Next ans = Application.Match(CLng(TextBox1.Text), Range("A1:A100"), 0) If Not IsError(ans) Then TextBox2.Text = Application.Index(Range("B1:B100"), ans) TextBox3.Text = Application.Index(Range("C1:C100"), ans) Else MsgBox "Invalid code" End If On Error GoTo 0 End Sub Thanks Greg |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto look up
Why wont the code in the joining message not look up names?
Greg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
Auto Number the Rows of Auto Filter Result | Excel Discussion (Misc queries) | |||
Sometimes formuli in workbook don't auto update with auto-recal on | Excel Worksheet Functions | |||
How to AUTO SAVE as opposed to turning on auto recovery: EXCEL | Excel Discussion (Misc queries) | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions |