+ Reply to Thread
Results 1 to 14 of 14

Userfrom Vlookup for spreadsheet reconciliation

  1. #1
    Registered User
    Join Date
    08-26-2013
    Location
    kalyan
    MS-Off Ver
    Excel 2010
    Posts
    14

    Userfrom Vlookup for spreadsheet reconciliation

    Hi


    This is Hemant here hope everything is well. I realy like this forum. I need your help for excel macro through userform for spreadsheet reconciliation.
    Can we have userform for doing spreadsheet reconciliation(Only by using VLOOKUP). Here are the things i need in userform

    1)First box that will ask you Lookup Value (column range)
    2)Second Box will ask you Tabel_array say (column range)
    3)Third box will ask you Col_index_num (column range)
    4)Fourth box will ask for range_lookup (0,1)
    5)Fifth box will ask for the column where you need your result in excel

    Please help me with complete userform or spreadsheet

    Thanks
    --------------------------------------

  2. #2
    Registered User
    Join Date
    03-19-2014
    Location
    India
    MS-Off Ver
    Excel & VBA - 2007 & 2010
    Posts
    60

    Post Re: Userfrom Vlookup for spreadsheet reconciliation

    Hi,

    Create a userform in VBA and in the OK button of the userform, use below codes.

    Also find the template sheet.
    Vlookup.xls

    Please Login or Register  to view this content.
    Last edited by moinsk21; 03-19-2014 at 10:51 AM.

  3. #3
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,613

    Re: Userfrom Vlookup for spreadsheet reconciliation

    Hi moinsk21,

    It's nice to see your involvement.
    However forum rules http://www.excelforum.com/forum-rule...rum-rules.html apply also to those who help.
    Please edit your post and use code tags (button with # sign in editor) the result will be like:

    Please Login or Register  to view this content.
    Once again - your comittment is appreciated, but form also matters.
    Best Regards,

    Kaper

  4. #4
    Registered User
    Join Date
    03-19-2014
    Location
    India
    MS-Off Ver
    Excel & VBA - 2007 & 2010
    Posts
    60

    Re: Userfrom Vlookup for spreadsheet reconciliation

    Hi Kaper,

    Thanks for the information, i will make sure next time.

  5. #5
    Registered User
    Join Date
    08-26-2013
    Location
    kalyan
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Userfrom Vlookup for spreadsheet reconciliation

    Hi Moinsk21

    Thanks for your quick turnaround.I am new learner of VBA can you please attached the form or spread sheet

    Please help
    Thanks
    -----------------------

  6. #6
    Registered User
    Join Date
    08-26-2013
    Location
    kalyan
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Userfrom Vlookup for spreadsheet reconciliation

    Hi

    Please Help

    Thanks
    ----------------------------

  7. #7
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,613

    Re: Userfrom Vlookup for spreadsheet reconciliation

    Hi hemant_sonawane,

    look above into first answer of moinsk21. He added a file:
    Also find the template sheet.
    Vlookup.xls
    click on Vlookup.xls to download it.

  8. #8
    Registered User
    Join Date
    08-26-2013
    Location
    kalyan
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Userfrom Vlookup for spreadsheet reconciliation

    Hi Kaper

    Thanks alot i got it. Just want to know after clicking on Vlookup button when userform popup in each box i have to give column range or i have to put manualy names. Can you please give me example wht i suppose to write in Userform. Sorry for troubling you

    Please help

    Thanks
    ---------------

  9. #9
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,613

    Re: Userfrom Vlookup for spreadsheet reconciliation

    Hope moinsk21 will comment on this - it is his code and his sample file.

  10. #10
    Registered User
    Join Date
    08-26-2013
    Location
    kalyan
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Userfrom Vlookup for spreadsheet reconciliation

    Hi Moinsk21

    Please help me on my query.

    Thanks
    --------------

  11. #11
    Registered User
    Join Date
    08-26-2013
    Location
    kalyan
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Userfrom Vlookup for spreadsheet reconciliation

    Hi Moinsk21

    Please help me on my query.

    Thanks
    --------------

  12. #12
    Registered User
    Join Date
    08-26-2013
    Location
    kalyan
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Userfrom Vlookup for spreadsheet reconciliation

    Hi Moinsk21

    Please help me on my query.

    Thanks
    --------------

  13. #13
    Registered User
    Join Date
    08-26-2013
    Location
    kalyan
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Userfrom Vlookup for spreadsheet reconciliation

    Hi

    Some one please help me on my query.

    Thanks
    --------------

  14. #14
    Registered User
    Join Date
    08-26-2013
    Location
    kalyan
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Userfrom Vlookup for spreadsheet reconciliation

    HI

    I resolve it.

    Thanks
    --------------------------

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Reconciliation
    By Shihab in forum Excel General
    Replies: 2
    Last Post: 01-12-2014, 12:21 PM
  2. Replies: 1
    Last Post: 08-16-2010, 05:51 PM
  3. Reconciliation
    By Eduard in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-22-2008, 05:05 AM
  4. Reconciliation
    By cmt_london in forum Excel General
    Replies: 1
    Last Post: 02-19-2008, 09:14 AM
  5. Replies: 8
    Last Post: 07-13-2006, 09:15 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1