How to Create Vlookup Function in Excel ing VBA

Рет қаралды 48,944

5 жыл бұрын

How to Create Vlookup in Excel with VBA using Userform. In this tutorial, you will learn how to use Vlookup on a Userform to search students' details. Functions used include the use of For Loop and, selection Statement.
Join this channel to get access to codes, perks, and see more interesting videos. / @djoamen
To support more videos from DJ Oamen, visit POamen Paypal
www.paypal.me/POamen
To Become a Channel member click on the link below to JOIN:
/ @djoamen
Channel Members can Download the Excel VBA Userform with Vlookup source code, and modify it for their own personal use. Plus one other source code per month. Total - 2 Source codes Per Month, only:
drive.google.com/file/d/1d5zF...
To download the RAW Excel file used on the video (No CODES INCLUDED), see the link below.
drive.google.com/file/d/1nvVz...

Пікірлер: 34

@ashrafabdallaattyaelfeky2639 5 жыл бұрын

Explain in the utmost magnificence ... Ask your presence to search in more than sheet and the result appear in the listbox by writing in the textbox ... Thank you so much for all your presentation of the explanations and codes distinct

@DJOamen 5 жыл бұрын

Thank you

@kb7417 3 жыл бұрын

That vlookup coding part is clever part. Amazing, learnt something new.

@DJOamen 3 жыл бұрын

Glad to hear that! Thanks KB

@TheComputerDocter 2 жыл бұрын

Exactly what I needed. Thanks

@DJOamen 2 жыл бұрын

Glad it helped!

@officialbaryar2017 4 жыл бұрын

You are the realy best teacher.

@DJOamen 4 жыл бұрын

Thank you 👍

@nileshtikekar3235 4 жыл бұрын

Thank you sir, very helpful

@DJOamen 4 жыл бұрын

Thank you👍

@dgitson 4 жыл бұрын

very nice, thanks

@DJOamen 4 жыл бұрын

Most welcome

@ppdbsekolah1913 2 жыл бұрын

Great Teacher...

@DJOamen 2 жыл бұрын

Thank you! 😃

@mexxy7902115 4 жыл бұрын

Thank sir I like your way

@DJOamen 4 жыл бұрын

Most welcome

@omiorahman6283 5 жыл бұрын

Thank you sir

@DJOamen 5 жыл бұрын

Thank you

@teeranonpasutham1133 2 жыл бұрын

Thank you

@DJOamen 2 жыл бұрын

You're welcome

@sigitpurwanto3531 3 жыл бұрын

Terimakasih ilmunya

@DJOamen 3 жыл бұрын

Terima kasih dan saya senang Anda menyukai tutorialnya, ingatlah untuk berlangganan. Semoga harimu menyenangkan

@khaled861991 3 жыл бұрын

What if I need to change a value using the form?

@DJOamen 3 жыл бұрын

The tutorial is all about Vlookup in Excel with VBA using Userform.

@muhammad3165 11 ай бұрын

what if i want to leave out one of the columns? Like i have 9 but i only want to use 7 of it

@DJOamen 11 ай бұрын

For nine columns that's (A to I), see below: lstDisplay.ColumnCount = 9 lstDisplay.RowSource = "A1:I65356"

@kuatulangan9811 4 жыл бұрын

Sir, would you mind to explain what do you mean by dim q and p, thank you very much sir

@DJOamen 4 жыл бұрын

Variable declared e.g q and p.

@kuatulangan9811 4 жыл бұрын

@@DJOamen is those variable q and p refering to some cell on worksheet? im really sorry to bother you for what im not understanding yet sir, thankyou very much for all of your video

@DJOamen 4 жыл бұрын

Declared variables are storage location, the two variables q and p are used to store values within the VBA. Read more about variable here, see link: launchschool.com/books/ruby/read/variables

@kuatulangan9811 4 жыл бұрын

@@DJOamen thankyou very much sir,... really2 thankyou

@isira31 2 ай бұрын

If I enter a student ID which is not in the database, the application will crash. Any solutions for that?

@DJOamen 2 ай бұрын

Private Sub ComboBox1_Change() On Error GoTo ErrorHandler Dim q As Long Dim p As Long q = Application.WorksheetFunction.CountA(Sheet1.Range("A:A")) If q = 0 Then MsgBox "No data found in column A.", vbExclamation Exit Sub End If For p = 1 To 15 Me("Textbox" & p).Value = Application.WorksheetFunction.VLookup(CLng(Me.ComboBox1.Value), _ Sheet1.Range("A" & 2, "P" & q), p + 1, 0) Next p Exit Sub ErrorHandler: MsgBox "An error occurred: " & Err.Description, vbCritical End Sub

@isira31 2 ай бұрын

@@DJOamen Great ... Thank you sir