Use Vlookup formula in user form TextBox

 HOME PAGE    

   UPSC :-UPSC Prelims 2021 Paper Analysis I Indian Polity             UPSC Prelims 2021 Paper Analysis I Science & Technology                 UPSC Prelims 2021 Paper Analysis I Geography             IAS/PCS Essay Book  Paper Notice and syllabus :PET EXAMINATION SYLLABUS            PET QUESTION PAPER                 SINDHU GHATI SABHYATA                         GST                     B.Ed Second Year Book -2021                            DIGITAL INDIA                    CHILD LABOUR IN INDIA  Competitive Book :- GK/GS Book 2021                              All Competitive Maths Book                    All Competitive Resigning Book            Important Project :-Visual Studio C # Project      Tally Erp9 Account Feature      Microsoft  Excel VBA Project                    who to  apply mathematical Formula in ms excel user form                   MS Excel UserForm Save And Edit Button Part-1 Module          MS Excel UserForm Save And Edit Button Part-2 Module          Use Vlookup Formula in MS Excel UserForm     Purvanchal University Book :  Purvanchal University Sure Series Book pdf Youtube Class Note :  Maths Class Note

                                      

                                            Vlookup Formula :-

                                                                                Vlookup Formula is using the Filter the data in the data sheet . When You make the data sheet Then the so complication Work is search the write data in the data sheet . In this Problem solve by Vlookup using Formula.

Example :- 

                    I go to a new MS Excel Sheet and put the name of sheet is "Data" , and make  a Employee table like name, id , password, address, mobile number etc. Tell me dray a user form to using MS Excel VBA . I am put the name of Employee in the Combobox and Click the Command Button Refresh , All the Detail of Employee fill the other Textboxs.

Solution :- 

                           Sheet name   =  "Data"  

                          UserForm name = "Refresh Data" 

                         ComboBox name = ComboBoxEmployee_Name

                          TextBox 1 name = TextBoxEmployee_Id

                          TextBox 2 name = TextBoxEmployee_Address

                          TextBox 3 name = TextBoxEmployee_Mobile_Number

                          Command Button 1 name = CommandButton_Refresh

Private Sub CommandButtonRefresh_Click()

Dim TableArray As Range, Employee Name As String

Set TableArray = Sheets("Data").Range("A:B")

Me.TextBoxEmployee_Id.Value =          WorksheetFunction.VLookup(Me.ComboBoxEmployee_Name, TableArray, 2, 0)

Me.TextBoxEmployee_Address.Value = WorksheetFunction.VLookup(Me.ComboBoxEmployee_Name, TableArray, 3, 0)

Me.TextBoxEmployee_Mobile_Number.Value = WorksheetFunction.VLookup(Me.ComboBoxEmployee_Name, TableArray, 4, 0)

End Sub

                                         2. Add Item In ComboBox :-

                                                                                          ComboBox using the checkout of Repeated entry . This Box is help the new data entry and worn the copy data . ComboBox is make the data Entry is Easy and fast. 

Example :- 

                    Make the ComboBox in UserForm and fix the list data in the data sheet . In this work  UserForm_Initialize code is help to show the data in comboBox list. It is complete the two step to codding fist is  Sub Product_List()  and second is Private Sub UserForm_Initialize()

                             Sheet name   =  "Data"  

                          UserForm name = "Refresh Data" 

                         ComboBox name = ComboBoxEmployee_Name

Coding fist :-

                   It the codding of show the data in the comboBox list when we run the Program.

Private Sub UserForm_Initialize()

Call Product_List

End Sub

Codding Second :-

                                   It is codding of Product list , Whose call in the fist codding module.

   

  Sub Product_List()

Set sh = ThisWorkbook.Sheets("Data")

Dim i As Integer

Me.ComboBoxEmployee_Name.Clear

Me.ComboBoxEmployee_Name.AddItem ""

For i = 2 To Application.WorksheetFunction.CountA(sh.Range("A:A"))

Me.ComboBoxEmployee_Name.AddItem sh.Range("A" & i)

Next i

End Sub

Some other topics:-

1. TextBox change Module 

2. TextBox Enter Module 

Maths Class Note

    HOME PAGE     

  UPSC :-UPSC Prelims 2021 Paper Analysis I Indian Polity             UPSC Prelims 2021 Paper Analysis I Science & Technology                 UPSC Prelims 2021 Paper Analysis I Geography             IAS/PCS Essay Book  Paper Notice and syllabus :PET EXAMINATION SYLLABUS            PET QUESTION PAPER                 SINDHU GHATI SABHYATA                         GST                     B.Ed Second Year Book -2021                            DIGITAL INDIA                    CHILD LABOUR IN INDIA  Competitive Book :- GK/GS Book 2021                              All Competitive Maths Book                    All Competitive Resigning Book            Important Project :-Visual Studio C # Project      Tally Erp9 Account Feature      Microsoft  Excel VBA Project                    who to  apply mathematical Formula in ms excel user form                   MS Excel UserForm Save And Edit Button Part-1 Module          MS Excel UserForm Save And Edit Button Part-2 Module Purvanchal University Book :  Purvanchal University Sure Series Book pdf Youtube Class Note :  Maths Class Note

                                    SUPPER 20-20 CLASSES

CLASS -  1 :- 

Topic :1

             * Divided Role :-

                             1 . Divided by 2 :- Last digit of given number is 2,4,6,8 and 0 then given number is divided by 2.

Example :- 2552,60134,2686,4008,1540 etc.

                            2. Divided by 3 :- Sum of all digit is given number is divided by 3 . Then the given number is divided by 3.

Example :-  3543, 9651,8856 etc.

                            3. Divided by 4 :- Last second digit of given number is divide by 4. Then the given number is divided by 4. 

 Example :- 25436,4504,56816, etc.

                            4. Divided by 5:-  Last digit of given number is 0 and 5 . Then  the given number is divided by 5.

Example :- 26530,2565,451120, 6695 etc.

                            5. Divided by 6 :-  If the given number is follow the divided properties of 3 and 2 . Then the given number is divided by 6. 

 Example :- 2532,5646,9852 etc.

                           6. Divided by 7:- Divided rule of 7 is so complicated then directly divided by 7.

                           7. Divided by 8 :- Last three digit of given number is divided by 8 . Then the given number is divided by 8. 

 Example :- 645816,98496,50016 etc.

                           8. Divided by 9 :- Sum of all digit is given number is divided by 9. Then the given number is divided by 9.

 Example :- 63864,45252,8001 etc.

                           9. Divided by 11 :- Difference of all odd place number sum and even place number sum in the given number is divided by 11 or difference is 0 . Then the given number is divided by 11.

Example :- 1925,652311,5940 etc.

        * Find the fist digit of given factor :-

             1. CASE 

                     1.  2¹= 2

                      2. 2²= 4 

                      3. 2³= 8

                     4. 2⁴= 16

                     5.  2⁵= 32

                    6. 2⁶= 64

                    7. 2⁷= 128

                    8. 2⁸= 256

We find out the given above example is power of 2 is increase but the fist digit number 2,4,8,6 is repeated .

 

        2. CASE :-

                     1.  3¹= 3

                      2. 3²= 9 

                      3. 3³= 27

                     4. 3⁴= 81

                     5. 3⁵= 243

                    6. 3⁶= 729

                    7. 3⁷= 2187

                    8. 3⁸=  6561      

We find out the given above example is power of 3 is increase but the fist digit number 3,9,7,1 is repeated .

Note :- In the same case of 4,5,6,7,8 and 9 . Then divided the power 4 and find the remender

 

                            

 Question 1. Find the fist digit of given number   2546⁸⁵+ 3654⁶³.

A) 0

B) 2

C) 8

D) 5 

Question 2. Find the fist digit of given number   4578⁵⁵⁴+ 5554⁶⁵³- 2646⁵²+ 8654³⁸.

A) 5

B) 6 

C) 8

D) 3

Question 3. Find the fist digit of given number   (254684^5845 65)*(26⁸⁵⁶³)

A) 5 

B) 8

C) 6

D) 4

Question 4.  Find the fist digit of given number   (254686^545545 6235)*(21212156^855456563)

A) 6

B) 4

C) 3

D) 2

Question 5.  Find the fist digit of given number   (22323135^58445 54)*(25315⁸⁴⁵⁶³³)

A) 3

B) 2

C) 5

D) 6

Question 6. 254876  is divided by.

A) 4

B) 5

C) 3

D) 9

Question 7. 117649 is divided by.

A) 6

B) 7

C) 3

D) 9

Question 8. 45768932 is divided by.

A) 6

B) 13

C) 7

D) 11

Question 9.  (3135^5845 54)*(2315⁸⁴⁵⁶³³) is divided by .

A) 3

B) 5

C) 6

D) 4

Question 10. (286^545 625)*(25^85456563) is divided by .

A) 6

B) 5

C) 11

D) 9

Solution 1.  A

Solution 2.  C

Solution 3. D

 

Solution 4.  A

Solution 5.  C

Solution 6.  A

 

Solution 7. B

Solution 8. D

Solution 9. B

Solution 10. A

Time and distance Trick questions