Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    User Forms (Excel 97)

    I am currently creating a job payment program in Excel, That requires a control (Taskbarkbar with macro buttons etc, I can not use a Taskbar because if another computer opens the program the taskbar has not be setup in that computers excell program. So I throught of using a Userform to act like a Tackbar that worked fine. But the problem comes when I require the Userform to stay running at the top of the screen at the same time the user is using the Excel program. I require the activated Userform to allow the Excel program to continue running, being able to copy, paste and type text etc, Is this possible?

    Any help would be much appreicated
    Jonathon

  2. #2
    2 Star Lounger
    Join Date
    May 2002
    Location
    Midland, Michigan, USA
    Posts
    133
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: User Forms (Excel 97)

    I wanted some similar functionality on a spreadsheet I was working on. My workaround:
    I put a button on my form that would hide the form and show a toolbar.
    When the user was done clicking around in the spreadsheet, he or she would click the toolbar button, and the toolbar would disappear & the form would unhide.

    Perhaps that can help, or perhaps you can build a toolbar with custom buttons to each specific part of the workbook - sort of your own version of the taskbar.
    HTH

  3. #3
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: User Forms (Excel 97)

    I recommend you to make your toolbar on the fly. See this thread .

  4. #4
    New Lounger
    Join Date
    Mar 2002
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: User Forms (Excel 97)

    Thanks HP
    I went to the web site and downloaded the Excel file and it work well

    Cheers
    Jonathon

  5. #5
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: User Forms (Excel 97)

    I think you're referring to 'modal' vs 'modeless' forms. The difference is whether or not the form allows you to gain access to other forms or dialogs or buttons while this form is displayed. In xl97 modal is the only choice which means the user must close the top-most form before they are able to do anything else.

    In Excel2000 this is a setup parameter when you create a form.

    You might get something out of Stephen Bullen's Excel site as I seem to remember him referencing some way to 'trick' Excel97 into this.
    http://www.bmsltd.ie/Excel/Default.htm

    Look for 'modelessform.zip'

    HTH, Deb <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Edited Mar 13th 2004 to update link

Posting Permissions

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