Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel 2003 form (Excel 2003)

    Would someone take a look at this form and tell me why the button on the spreadsheet will not open it. All parts look correct to me. I am attaching the file.

    Thanks
    Attached Files Attached Files
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel 2003 form (Excel 2003)

    The macro is not assigned to the code in this workbook but to the code in the personal.xls workbook.

    Right click the button, select Assign Macro and choose the macro that is in the workbook not the one in personal.xls.

    Steve

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Excel 2003 form (Excel 2003)

    Hi there

    You have named the macro the same name as the form and so Excel was confused. There were a few errors in the code, thinhs like having different names to the controls and in the code.

    Have a go now
    Jerry

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2003 form (Excel 2003)

    Understood. Did that. It still brings up the error 424 and highlights the second line in the following code

    Sub OpenfrmRTT()
    frmRTT.Show
    End Sub
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  5. #5
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Excel 2003 form (Excel 2003)

    See my post above and the revised workbook <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Jerry

  6. #6
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2003 form (Excel 2003)

    Jerry

    Your wonderful. Thank you so much...I've looked at this til I was blue in the face.

    It works beautifully,
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

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