Fun code - Page 2
Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 28

Thread: Fun code

  1. #11
    Board Regular
    Join Date
    Feb 2002
    Location
    Las Vegas Nevada USA
    Posts
    239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi jbyrne
    Easy way, from the forms toolbar put a button on the sheet and attach it to the procedure (ShowStars). Just right click on the button, select "Assign macro"
    Enjoy
    George
    George

    Learn to listen. Opportunity sometimes knocks very softly.

  2. #12
    Board Regular
    Join Date
    Feb 2002
    Posts
    177
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks George,

    I seem to be getting a Compile error. Variable not defined mssg. When I click ok, The public sub showstars is highlighted in yellow.

    Jim

  3. #13
    Board Regular
    Join Date
    Feb 2002
    Location
    Las Vegas Nevada USA
    Posts
    239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Jim
    How did you enter the code?
    There are two separate procedures and they need to go into a standard module.
    George

    Learn to listen. Opportunity sometimes knocks very softly.

  4. #14
    Board Regular
    Join Date
    Feb 2002
    Posts
    177
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    George,

    I copied your code then clicked on the VB editor and pasted. I guess I did it wrong.

  5. #15
    Board Regular
    Join Date
    Feb 2002
    Location
    Las Vegas Nevada USA
    Posts
    239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Jim
    Sorry I gave you a bum steer. The code has to go in the sheet not a standard module.
    Use the insert procedure and then copy and paste the code in. Two separate procedures.
    George

    Learn to listen. Opportunity sometimes knocks very softly.

  6. #16
    Board Regular
    Join Date
    Feb 2002
    Posts
    177
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    George,

    When you say the code has to go into the sheet. I don't know much about coding or VBA, so excuse my ignorance.....I'm learning as I go.

  7. #17
    Board Regular
    Join Date
    Feb 2002
    Location
    Las Vegas Nevada USA
    Posts
    239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    OK here goes
    Open a fresh workbook, right click on the sheet tab, select “View code”
    This will put you into the VBE (Visual Basic Editor) At the top of the
    Screen click on “Insert” select “Procedure” name them the same as my post
    and paste in the code. Do this twice, once for each procedure.
    Good luck

    George

    Learn to listen. Opportunity sometimes knocks very softly.

  8. #18
    Board Regular
    Join Date
    Feb 2002
    Posts
    177
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks George, I appreciate you letting me pick your brain. Have a good night!

  9. #19
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Im impressed sent to top of board in case many missed it good to learn from

    well done.


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  10. #20
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,445
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Aloha,

    If anyone has the time and patience, can you walk me through this.



    I get stuck at the Insert/Procedure the window won't accept any names.

    Brian

    [ This Message was edited by: Brian from Maui on 2002-04-06 22:55 ]

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