Results 1 to 8 of 8
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    command button hyperlink

    I am creating a multipage tabbed userform dialog in Word 97 VBA. I would like to use a command button to take the user to the next logical page of dialog. Is there a way to create this sort of hyperlink? Thank you.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: command button hyperlink

    Yes. I did this in my ModuleManager template a couple of years ago. If you'ld like to test-drive a copy just to see the tabbed forms slide, glide and wobble, let me know an email address or I'll attach a Zipped copy.

    Warning: The project is incomplete. It was written as an exercise in the design of GUI forms.


    If you like what you see, I'll carve out the relevant code and post it here.

  3. #3
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: command button hyperlink

    I don't know if this would be at all helpful, but I have a working example of this created in Access. There are Back and Next buttons that work similar to a wizard - they even disable when the first or last tab is selected.

    Let me know if you're interested and I'll post this.

  4. #4
    Star Lounger
    Join Date
    Jan 2001
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: command button hyperlink

    That's sounds interesting. I would love to see it. Thanks.

  5. #5
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: command button hyperlink

    I don't know if <A target="_blank" HREF=http://msdn.microsoft.com/library/techart/msdn_wizardof.htm>this article from Microsoft</A> will help you. It's not a tabbed control though, but it might be of use.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  6. #6
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: command button hyperlink

    I'd love to post it here, but it's about 400K (Zipped). I've uploaded it to my website. Here's the link: <A target="_blank" HREF=http://communities.msn.com/MarkJ/files/TabControlExample.zip>http://communities.msn.com/MarkJ/fil...rolExample.zip</A>.
    Please ignore the poor programming because this is one of my older projects. There may be a few controls that no longer work since I hacked it up for example purposes. The names are fake.
    HTH <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

  7. #7
    Star Lounger
    Join Date
    Jan 2001
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: command button hyperlink

    The wizard is something I didn't think of, and if I can get a handle on it, may be appropriate. My userform is very lengthy with multipages embedded in multipages, and I get lost myself filling it out, so I am trying to anticipate user difficulties.

    Thanks so much for all the ideas. I have a lot to check out.

  8. #8
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: command button hyperlink

    Thank you. It would be great to see it.
    Yes. I did this in my ModuleManager template a couple of years ago. If


    I have u/l it to my web site. For a short time (I get only 5MB to play with) you can grab it at
    http://www.vif.com/users/cgreaves/modmn.zip


    Drag the template "ModMn???.dot" into your Startup directory and THEN load Word97SR2.

    Click on the "ModuleManager" button in the "ModMn" toolbar.

    Click on "Source of Modules".

    In the multi-tabbed GUI that appears, click in the following sequence on the tabs Drives, Paths, Files, Modules, Items, Text window, Clipboard, Shopping basket, Help.

    Then click on them in reverse order (Help, Shopping basket, Clipboard etc).

    You should start to see a randomized variety of movement.





    If you want to actually USE this beast:

    In the drives tab, click then double-click on a drive letter.

    The Paths tab should arrive automatically. Drill down (Click/Double Click) to a directory that you know contains Word templates.

    Click to select that directory, then click on the LOAD button.

    The Files tab should arrive automatically.

    Click on one template, Ctrl-Click on a second template. two templates should be highlighted.

    The Modules tab should appear automatically.

    (You can go back to playing Tabs if you want)

    Click on one module. Click LOAD. The Items tab should appear automatically.

    Click on one procedure. Click on Load. The Text window Tab should appear automatically. There is your procedure (we hope).

    Click on the ALL button to select ALL the text in the tab. Clip on the CLIPBOARD button.

    That should copy your procedure to the clipboard (Open Notepad.exe and choose Edit, Paste to see that this is so).



    When you are done, click on the EXIT button and then the CANCEL button.

Posting Permissions

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