+ Reply to Thread
Results 1 to 12 of 12

Repeat macro from user input

  1. 06-14-2008, 11:30 AM #1
    traxwriter
    traxwriter is offline
    Registered User
    Join Date
    06-14-2008
    Posts
    6

    Repeat macro from user input

    Hi,

    I have a very simple macro for recalculating formulas and printing the page.

    I need a way to show an input box where the user can say how many times to repeat the process i.e. 2x = recalculate, print, recalculate, print.

    Thanks in advance

    Edit: The input number needs to be rounded to even then halved before repeating
    Last edited by traxwriter; 06-14-2008 at 11:33 AM.
    Reply With QuoteRegister To Reply
  2. 06-14-2008, 12:12 PM #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
    Can you post your code - remember to use Code Tags
    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-14-2008, 12:32 PM #3
    traxwriter
    traxwriter is offline
    Registered User
    Join Date
    06-14-2008
    Posts
    6
    Please Login or Register  to view this content.
    As I said simple code, actually I recorded it lol.
    Reply With QuoteRegister To Reply
  4. 06-14-2008, 12:44 PM #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
    What's the purpose of it? Calculation is automatic unless you have switched it off in Options. tt uses an Excel4 macro and I don't know how you recorded that.
    Reply With QuoteRegister To Reply
  5. 06-14-2008, 12:55 PM #5
    traxwriter
    traxwriter is offline
    Registered User
    Join Date
    06-14-2008
    Posts
    6
    The purpose of it is the recalculate several RANDBETWEEN formulas so each page printed is different. I recorded it in the usual way by pressing record macro, pressing F9, Control P and enter.

    Edit: SImply printing 50 copies produces the same sheets wihtout recalculating the forumlas in between copies
    Last edited by traxwriter; 06-14-2008 at 01:00 PM.
    Reply With QuoteRegister To Reply
  6. 06-14-2008, 01:06 PM #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
    What version of Excel are you using?

    This should do what you want

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 06-14-2008, 01:18 PM #7
    traxwriter
    traxwriter is offline
    Registered User
    Join Date
    06-14-2008
    Posts
    6
    Thanks for that, I'm using 2007.

    Just tried the macro you supplied, I get Compile Error: End If without block If

    I copied it and placed it like this:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 06-14-2008, 01:23 PM #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
    The End If needed moving. 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  9. 06-14-2008, 01:36 PM #9
    traxwriter
    traxwriter is offline
    Registered User
    Join Date
    06-14-2008
    Posts
    6
    That's great thanks very much, now just one thing

    Say a user types 10 in the input we need to half it so 5 sheets are printed. Bearing in mind that if they typed 9 we couldn't print 4.5 so we would print 5 instead. In excel I would use something like: =EVEN(A1)/2

    Can this be fitted into a macro?

    Thanks for all your help so far.
    Reply With QuoteRegister To Reply
  10. 06-14-2008, 01:53 PM #10
    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
    Try this

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  11. 06-14-2008, 01:56 PM #11
    traxwriter
    traxwriter is offline
    Registered User
    Join Date
    06-14-2008
    Posts
    6
    Thats absolutely fantastic, Thanks very much royUK
    Reply With QuoteRegister To Reply
  12. 06-14-2008, 03:31 PM #12
    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
    Glad it helped.
    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