MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 278|Reply: 4

Something wrong with my coding (new to VBA)

[Copy link]

1

Topics

4

Posts

11

Integral

Member

Rank: 2

Integral
11
Post on 2-11-2017 17:11:17 | All posts |Read mode
Hey guys. A little help and a few tips would be nice to for someone who is just learning vba. so I'm currently making this simple data base for the company I work for and i want to be able to put the vendor name in a specific cell(D2) and basically find all data in sheet 2 with the vendor name in cell D2 and paste in a report sheet (sheet 1). I already have written a code for it but for some reason, its not executing what I want it to execute. Can someone please check my code and see if theres anything wrong with it? I have been trying to solve this for days now and I cant seem to find a fix. Thank you in advance!










Reply

Props Report

8

Topics

1046

Posts

2284

Integral

King

Rank: 6Rank: 6

Integral
2284
Post on 2-11-2017 19:54:07 | All posts



Post a sample workbook. Pictures are pretty but useless for diagnosing and testing code.











Reply Support Opposition

Props Report

1

Topics

4

Posts

11

Integral

Member

Rank: 2

Integral
11
 Author| Post on 2-11-2017 20:59:03 | All posts



here's the workbook im working on. thanks in advance for all the help.








  • userform2.1 (loop).xlsm
    (47.7 KB, 0 views)
    Download

  • Reply Support Opposition

    Props Report

    1

    Topics

    4

    Posts

    11

    Integral

    Member

    Rank: 2

    Integral
    11
     Author| Post on 2-11-2017 23:19:18 | All posts



    here's the workbook im working on. thanks in advance for all the help.








  • userform2.1 (loop).xlsm
    (47.7 KB, 3 views)
    Download

  • Reply Support Opposition

    Props Report

    1

    Topics

    4

    Posts

    11

    Integral

    Member

    Rank: 2

    Integral
    11
     Author| Post on 2-12-2017 02:12:04 | All posts



    here's the workbook im working on. thanks in advance for all the help.








  • userform2.1 (loop).xlsm
    (47.7 KB, 5 views)
    Download

  • Reply Support Opposition

    Props Report

    Points policy of this forum

    Archiver|Mobile|Small dark house|Contact us|Excel Bar

    GMT-5, 9-21-2017 14:36 , Processed in 0.174469 second(s), 20 queries .

    Powered by Discuz! X3

    © 2001-2013 Comsenz Inc.

    !fastreply! Top !return_list!