+ Reply to Thread
Results 1 to 9 of 9

VBA Code to pull info onto Userform

  1. 06-15-2009, 03:14 AM #1
    Climaxgp
    Climaxgp is offline
    Forum Contributor
    Join Date
    08-13-2008
    Location
    South Africa
    Posts
    130

    VBA Code to pull info onto Userform

    Hi Guys

    I had some free time and decided to play around with Userforms, i'm completely new to this!

    No i have encountered a problem. I do not know how to link the Team Leader and Month to pull the following onto the userform:

    Applications
    Approved
    QA
    Year to Date: Applications
    Year to Date: Approved
    Year to Date: QA

    I'm not sure if you need a VBA code, Macro or formula? Any help will do

    I have attached the workbook
    Attached Files Attached Files
    Last edited by Climaxgp; 06-15-2009 at 06:58 AM.
    Reply With QuoteRegister To Reply
  2. 06-15-2009, 03:21 AM #2
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: VBA Code to pull info onto Userform

    our sheet layout doesn't make it easy. You could use .Find to locate the tem leader, but the name in the tables is preceded by Team Leader
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example
    Reply With QuoteRegister To Reply
  3. 06-15-2009, 04:04 AM #3
    Climaxgp
    Climaxgp is offline
    Forum Contributor
    Join Date
    08-13-2008
    Location
    South Africa
    Posts
    130

    Re: VBA Code to pull info onto Userform

    Thanks royUK

    So it can't be done? Is there any other way of doing it?
    Reply With QuoteRegister To Reply
  4. 06-15-2009, 04:22 AM #4
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: VBA Code to pull info onto Userform

    Design your worksheet to be used by the form, remove Team Leader from the text, so only the name is in the column
    Reply With QuoteRegister To Reply
  5. 06-15-2009, 04:23 AM #5
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: VBA Code to pull info onto Userform

    Design your worksheet to be used by the form, remove Team Leader from the text, so only the name is in the column
    Reply With QuoteRegister To Reply
  6. 06-15-2009, 04:45 AM #6
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: VBA Code to pull info onto Userform

    If you change the cells as i suggest yo can use the cboMonth change event to trigger the input
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 06-15-2009, 05:30 AM #7
    Climaxgp
    Climaxgp is offline
    Forum Contributor
    Join Date
    08-13-2008
    Location
    South Africa
    Posts
    130

    Re: VBA Code to pull info onto Userform

    Thank you royUK!!!!!!! It works perfectly!!!!!!!!!!!!

    I know i'm asking for abit to much here... but how do i link up the "year to date-applications, "year to date - approved" and year to date - QA"?
    Reply With QuoteRegister To Reply
  8. 06-15-2009, 06:17 AM #8
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: VBA Code to pull info onto Userform

    You only need to extend the code using the same priinciples - read the help on Offset etc
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  9. 06-15-2009, 07:00 AM #9
    Climaxgp
    Climaxgp is offline
    Forum Contributor
    Join Date
    08-13-2008
    Location
    South Africa
    Posts
    130

    Re: VBA Code to pull info onto Userform

    Thanks royUK, really appreciate it!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1