+ Reply to Thread
Results 1 to 6 of 6

Something wrong with my coding (new to VBA)

  1. #1
    Registered User
    Join Date
    02-11-2017
    Location
    new york
    MS-Off Ver
    2010
    Posts
    6

    Red face Something wrong with my coding (new to VBA)

    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. attached is the test workbook i am working on. Thank you in advance!
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by mikeonglengco; 02-11-2017 at 07:46 PM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Something wrong with my coding (new to VBA)

    Post a sample workbook. Pictures are pretty but useless for diagnosing and testing code.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    02-11-2017
    Location
    new york
    MS-Off Ver
    2010
    Posts
    6

    Re: Something wrong with my coding (new to VBA)

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

  4. #4
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Something wrong with my coding (new to VBA)

    Give this a try

    Please Login or Register  to view this content.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  5. #5
    Registered User
    Join Date
    02-11-2017
    Location
    new york
    MS-Off Ver
    2010
    Posts
    6

    Re: Something wrong with my coding (new to VBA)

    yes its finally working!! Thanks so much for the help! I really appreciate it.. quick question. whats the easiest code for a command button whose purpose is to clear contents of a specific range?

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Something wrong with my coding (new to VBA)

    Examples:

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

+ 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. [SOLVED] In need of help regarding combo box coding and button coding (Access form project)
    By mailblade in forum Access Tables & Databases
    Replies: 2
    Last Post: 01-09-2016, 01:34 AM
  2. Help with vba coding debugging - I just cant see where I am going wrong ;(
    By dazbear in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-04-2015, 03:33 PM
  3. macro coding help (i have no background in coding)
    By notgoodenough in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-05-2014, 10:22 PM
  4. [SOLVED] Vb macro coding for transpose - complete coding?
    By Dharani Suresh in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 08-02-2013, 11:16 PM
  5. [SOLVED] Vb macro coding for transpose - complete coding?
    By Dharani Suresh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-02-2013, 05:04 AM
  6. Wrong coding or RANDBETWEEN is wrong?
    By zbor in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 07-31-2013, 10:01 AM
  7. [SOLVED] CheckBox coding to work with ComboBox coding
    By JimExcel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-05-2013, 12:23 PM

Tags for this Thread

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