Create button on spreadsheet
Upcoming Power Excel Seminars
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Create button on spreadsheet

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    67
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Does anyone know how to create buttons on the spreadsheet for running macros???
    I did it once a long time ago but I forgot how to do it now
    please help

    Thanks in advance

  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

      
    From the VisualBasic toolbar, click the Control Toolbox.
    From there click command button.
    Draw the thing on.
    Double click it to add code.
    Turn design view off to run the code when the button is clicked.

    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