+ Reply to Thread
Results 1 to 5 of 5

looping :(

  1. #1
    Registered User
    Join Date
    07-31-2017
    Location
    PHILIPPINES
    MS-Off Ver
    2010
    Posts
    32

    looping :(

    Hi Guys,

    hope you can help me with this project.

    Depending on "Current User" Value, use VBA Loops to fill values X to Y starting cell A1 such that each column has only 10 cells filled. The output should be as per above sample
    Values of X and Y will be based on the User's level. Please below table.
    Your "User Level" reference is cell C25.value(drop down). Link and call your macro everytime c25.value changes
    Option explicit is a must.

    **Code must be placed on "Sheet1"

    Hope to hear from you. Thank you in advance.

  2. #2
    Registered User
    Join Date
    07-31-2017
    Location
    PHILIPPINES
    MS-Off Ver
    2010
    Posts
    32

    Re: looping :(

    Here's the attachment
    Attached Files Attached Files

  3. #3
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,824

    Re: looping :(

    Copy and paste this macro into the worksheet code module. Do the following: right click the tab for your "Activity" sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Since the drop down list was in cell C24, I based the macro on that cell. Change it to C25 if the drop down is in cell C25. Close the code window to return to your sheet. make a selection in the drop down list.
    Please Login or Register  to view this content.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  4. #4
    Registered User
    Join Date
    07-31-2017
    Location
    PHILIPPINES
    MS-Off Ver
    2010
    Posts
    32

    Re: looping :(

    woooow. that was fast and amazing! :D htanks much brotha!

  5. #5
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,824

    Re: looping :(

    You are very welcome.

+ 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. Looping
    By geniusufo007 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-18-2017, 12:22 PM
  2. Do looping row by row using vba.
    By airbatucampur92 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-08-2014, 12:01 AM
  3. VBA looping
    By bjcowen9000 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-19-2013, 06:43 PM
  4. Do Until Looping (not looping through all other columns)
    By orle8050 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-11-2013, 10:37 AM
  5. [SOLVED] VBA Looping with Ifs
    By harrison298 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-21-2012, 04:35 AM
  6. Looping
    By RBI in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-15-2008, 02:45 PM
  7. Help with looping
    By dok112 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-01-2005, 01:09 PM

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