macros!!??
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: macros!!??

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    huddersfield
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Help im tryin to finish off an assignment but cant get my head round it!
    how do i
    1. 'create a macro to automatically copy the template for each product in my spreadsheet???
    2. 'create buttons on a template allowing the user to create a graph and post the results within the spreadsheet??
    confused!?

    [ This Message was edited by: k_eaton on 2002-04-10 08:40 ]

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    =ActiveCell.Address
    Posts
    478
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    There's quite a bit still to go on your assignment I think! Basically there's no quick answer to your question as it's pretty vague.

    To answer the first bit, if you haven't done any VBA before, the simplest thing would be to go to Tools>Macros>Record New Macro.
    Then do whatever it is you want to do. Go into the Visual Basic Editor when you've stopped recording and you'll see the code for copying, pasting, switching workbooks, opening workbooks etc.
    The board could then help you if you run into trouble etc. if you posted some code or had a more specific query.

    Similarly to add buttons to a sheet, a two second guide would run something like...

    From the VisualBasic toolbar, click the Control Toolbox.
    From there click command button.
    Draw the thing on.
    Double click it to add code.

    Hope this gets you started.
    Rgds
    AJ


  3. #3
    New Member
    Join Date
    Apr 2002
    Location
    huddersfield
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hey aj,
    thanks for the help. i do know how to create macros im just unsure of how to create a template. its difficult to explain so ill wait and ask my teacher.
    another Q.......
    'how do i create a small menu on the main menu bar that appears automatically when the spreadsheet is opened?????

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    =ActiveCell.Address
    Posts
    478
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi,

    Adding menus/buttons is not exactly one of my strong points but if you have a look at the post below this works fine to add and remove a button. Perhaps you can adapt it to get a full blown menu??

    http://www.mrexcel.com/board/viewtop...c=3823&forum=2

    Rgds
    AJ

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