for loop to accept values
Manage your personal finances in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: for loop to accept values

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I am currently working on an Excel file that estimates time to assemble a unit. I would like to include a combination of yes/no buttons and a for loop to accomplish one section but can't figure out how to implement.

    For example, on the question and answer form, a question might read:

    "Does the unit have parts with multiple interfaces?" with Yes/No buttons beside them.

    If Yes is pressed, I would like unhide a cell that asks how many parts with multiple interfaces are on the unit.

    Then I would like to unhide enough rows to ask how many interfaces each part has.

    For example, if there are 4 parts with multiple interfaces on a unit, I would like to unhide 4 rows. The first row would ask how many interfaces part #1 has. The second row would ask how many interfaces part #2 has, etc.

    I could guarantee a maximum value, like there would be no more than 15 components.

    Any ideas how this could be easily implemented for a non-Excel-guru?

    Thanks,
    Jason

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Ever thought about using a userform with dynamic numbers of texboxes instead of hiding and unhiding rows in a worksheet? Do a search on this board for dynamically adding controls.
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com