Results 1 to 4 of 4

Thread: Help with macros

  1. #1
    Fried Chip Extremist alsenior's Avatar
    Join Date
    Nov 2005
    Location
    Stafford
    Posts
    2,948
    Thanks
    102
    Thanked
    191 times in 145 posts
    • alsenior's system
      • Motherboard:
      • DFI Lanparty Jr x58-T3H6
      • CPU:
      • Core i7 920
      • Memory:
      • 6 x 2GB ocz Gold
      • Storage:
      • 1 TB Samsung F3
      • Graphics card(s):
      • 1gb 4890 vapor-x xfire
      • PSU:
      • xfx 850W
      • Case:
      • Lian-li Pc7
      • Operating System:
      • Windows 7 X64
      • Monitor(s):
      • Dell 2208WFP
      • Internet:
      • 30mb Virgin media

    Help with macros

    i need some help making some macros for my AS ict project.

    i need two macros to do the following :

    • clear a sheet and go to menu sheet(working now)
    • close ther sheet and close excel(not working but not needed)
    • when a button is clicked a radio button is clicked i need to use a formula to work out a figure and than add it to the overall figure


    can someone point me in the right dirction i need the macros pretty quickly i know how to change the sheet but clearing the sheet is harder and i don't know if closing excel is possable
    Last edited by alsenior; 06-02-2007 at 12:36 PM.
    Quote Originally Posted by Jay View Post
    What kind of emergency would need Windows 95? I think you are already in a bad state of emergency when your backup plan is Windows 95.
    Beginners guide to raid Beginners guide to raid post edition Hexus.Social - FAQ

  2. #2
    Senior Member
    Join Date
    Aug 2005
    Location
    Brisbane
    Posts
    612
    Thanks
    20
    Thanked
    35 times in 22 posts
    • toolsong's system
      • Motherboard:
      • ASUS P7P55D EVO
      • CPU:
      • i7 860 @ 3.8 GHz
      • Memory:
      • 2 x 4GB Corsair Vengeance
      • Storage:
      • SSDs
      • Graphics card(s):
      • GTX970
      • PSU:
      • Seasonic X650
      • Case:
      • Antec P180
      • Operating System:
      • Win7 x64
      • Monitor(s):
      • Dell U2515H
      • Internet:
      • Fibre @ 100/40
    As with any VBA the simplest place to start is:

    1) Record the steps you want to automate.
    2) Look at the generated code for the objects and methods it uses.
    3) Read VBA help for the above objects and methods.
    4) Modify recording to fit your task and make it more easily reused.

  3. #3
    Fried Chip Extremist alsenior's Avatar
    Join Date
    Nov 2005
    Location
    Stafford
    Posts
    2,948
    Thanks
    102
    Thanked
    191 times in 145 posts
    • alsenior's system
      • Motherboard:
      • DFI Lanparty Jr x58-T3H6
      • CPU:
      • Core i7 920
      • Memory:
      • 6 x 2GB ocz Gold
      • Storage:
      • 1 TB Samsung F3
      • Graphics card(s):
      • 1gb 4890 vapor-x xfire
      • PSU:
      • xfx 850W
      • Case:
      • Lian-li Pc7
      • Operating System:
      • Windows 7 X64
      • Monitor(s):
      • Dell 2208WFP
      • Internet:
      • 30mb Virgin media
    i still need more help but i have got the first two working i need help getting this lasdt one to work i dont think i am able to record that type of macro and the internet is useless for this.
    Quote Originally Posted by Jay View Post
    What kind of emergency would need Windows 95? I think you are already in a bad state of emergency when your backup plan is Windows 95.
    Beginners guide to raid Beginners guide to raid post edition Hexus.Social - FAQ

  4. #4
    Senior Member
    Join Date
    Aug 2005
    Location
    Brisbane
    Posts
    612
    Thanks
    20
    Thanked
    35 times in 22 posts
    • toolsong's system
      • Motherboard:
      • ASUS P7P55D EVO
      • CPU:
      • i7 860 @ 3.8 GHz
      • Memory:
      • 2 x 4GB Corsair Vengeance
      • Storage:
      • SSDs
      • Graphics card(s):
      • GTX970
      • PSU:
      • Seasonic X650
      • Case:
      • Antec P180
      • Operating System:
      • Win7 x64
      • Monitor(s):
      • Dell U2515H
      • Internet:
      • Fibre @ 100/40
    Quote Originally Posted by alsenior View Post
    ...and the internet is useless for this.
    I'm not sure how you came to that conclusion? I've never had any trouble finding code samples (for any language) and you've not asked anything that isn't in the sample code provided in the VBA Help files.

    To implement #3, the first thing you need to do is make sure you have the "Control Toolbox" toolbar visible.

    This will allow you to draw a command button (correct) or radio button (wrong object for this purpose) onto the page and write some code for its "click" event.

    Right click the button and select "View code" to open the VBA editor.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Who's still playing WoW then?
    By Starburn in forum PC
    Replies: 1920
    Last Post: 31-03-2011, 06:20 PM
  2. Lynn
    By Lynn E. in forum Welcome to HEXUS!
    Replies: 3
    Last Post: 12-08-2006, 10:47 PM
  3. Outlook and Macros!!!
    By darrensen in forum Software
    Replies: 1
    Last Post: 24-10-2005, 10:26 AM
  4. Macros
    By ERU in forum PC
    Replies: 16
    Last Post: 03-05-2005, 04:38 PM
  5. Microsoft Word 2003 Macros
    By Cuffz in forum Software
    Replies: 2
    Last Post: 15-02-2005, 11:19 AM

Posting Permissions

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