+ Reply to Thread
Results 1 to 2 of 2

Do while Loop that is conditional based upon user input?

  1. #1
    Registered User
    Join Date
    04-02-2007
    Posts
    8

    Do while Loop that is conditional based upon user input?

    Here is what I have...

    G01 Z # [ 0.242031066 ] A # [ 100 ]

    Each of these "charactars" is in an individual field, while the .242 is a calculation pulled from another set of fields

    Here is the calculation...

    ((COS(AD11+AD13))*AC9)+AC10

    In my spreadsheet I have a "number of steps" column, which is also a calculation. I would like to have the button "generate code" give me as many lines of code as I need, while incrementing the angle, based upon the input given. The example attached will need a 100 lines of code. I think I could figure this out, if someone out there can provide a couple of good statements that would output this code the correct fields. I'm not sure if this makes sense, so I attached the spreadsheet with the output I want (hand calculated).

    I basically need it to say put a G01 in this cell a 100 times when the number or value 100 is a cell pulled from the spreadsheet. Then do the same for the remaining fields... I think that makes sense.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    06-17-2009
    Location
    Chennai,India
    MS-Off Ver
    Excel 2003,excel 2007
    Posts
    678

    Re: Do while Loop that is conditional based upon user input?

    when you attach a sheet you must refer to cell addresses instead of values for easy understanding.
    you requirement is not at all clear. you want to fill the range E9 down with the formulas. why do you need a macro and button? why not just copy the formula in E9 down.
    Little more clarity will be helpful to help you.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1