Results 1 to 9 of 9
  1. #1
    Silver Lounger Charles Kenyon's Avatar
    Join Date
    Jan 2001
    Location
    Sun Prairie, Wisconsin, Wisconsin, USA
    Posts
    2,049
    Thanks
    124
    Thanked 119 Times in 116 Posts

    Re: New on the Word MVP FAQ Page

    Three on Word Forms & VBA, one on tables (rowspan and colspan). <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=wrd&Number=45313&page=0&vie w=collapsed&sb=5&vc=1>Thread on Word forum.

    BTW - If this thread bothers people, let me know and I'll stop posting it. I have nothing to do with the MVP site except being an admirer.
    Charles Kyle Kenyon
    Madison, Wisconsin

  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: New on the Word MVP FAQ Page

    >If this thread bothers people


    hah! Remove it with impunity.


    --I-- like it so much that I've added it as a direct link from the Developer's page on my own web site. I hope you don't mind me plagiarising your voyeuristic theft (grin!)


    Thanks for the posting.

  3. #3
    Silver Lounger Charles Kenyon's Avatar
    Join Date
    Jan 2001
    Location
    Sun Prairie, Wisconsin, Wisconsin, USA
    Posts
    2,049
    Thanks
    124
    Thanked 119 Times in 116 Posts

    New on the Word MVP FAQ Page

    I regularly check the and am starting <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=wrd&Number=45313&page=0&vie w=collapsed&sb=5> this thread on the Word forum to bring others this news, as I have time.

    Revision: Since we now have the ability to edit our posts, I'll add new pages directly to this post rather than refer you to the other thread. That way people won't have to search quite as hard. I imagine that eventually the page will reach capacity and I'll have to start a new one in a reply. The Word thread will probably always be ahead of this one, though. Also, I will simply be copying from there rather than distilling the VBA items. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15> You may want to bookmark the following index pages on that site: , <A target="_blank" HREF=http://www.mvps.org/word/FAQs/index5.html> UserForms FAQ and <A target="_blank" HREF=http://www.mvps.org/word/FAQs/index8.html> Office Inter-Development FAQ</A>.

    <font color=448800>2001 09 04 </font color=448800>- revised articles

    <A target="_blank" HREF=http://www.mvps.org/word/FAQs/MacrosVBA/SpellcheckProtectDoc.htm>How to enable the spellchecker in a protected document</A> (Now caters for user clicking on Cancel button and for a Word 97 bug that crashes Word if formfields in tables contain multiple paragraphs)

    <A target="_blank" HREF=http://www.mvps.org/word/FAQs/MacrosVBA/SetLongFmFldResult.htm>How to set the result of a text formfield using VBA, if the string is longer then 256 characters </A> - revised


    earlier
    2001 08 17

    <A target="_blank" HREF=http://www.mvps.org/word/FAQs/TblsFldsFms/SplitFirstNameLastName.htm>I have a "Name" column which I want to split into "FirstName", "LastName", how can I do it?</A> (revised)


    2001 August 14
    <A target="_blank" HREF=http://www.mvps.org/word/FAQs/General/UsingWildcards.htm>Finding and replacing characters using wildcards </A> by Graham Mayor (w input from Klaus Linke)

    <A target="_blank" HREF=http://www.mvps.org/word/FAQs/MacrosVBA/DeleteHyperlinks.htm>How to convert the hyperlinks in a document to plain text</A> - revised article


    2001 07 26
    <A target="_blank" HREF=http://www.mvps.org/word/FAQs/MacrosVBA/FindReplaceAllWithVBA.htm>Using a macro to replace text where ever it appears in a document including Headers, Footers, Textboxes, etc.</A> by Doug Robbins


    2001 07 23

    <A target="_blank" HREF=http://www.mvps.org/word/FAQs/TblsFldsFms/CellAlignmentProbs.htm>Fixing the Cell Alignment Buttons on the Tables Toolbar in Word 2000+</A> by Dave Rado -- changing from the 9 buttons that include paragraph formatting to the three that only include cell formatting - Word 97 style.


    2001 07 18

    <A target="_blank" HREF=http://www.mvps.org/word/FAQs/MacrosVBA/DistributeMacros.htm>Distributing your Macros to Other Users</A> by Jonathon West - don't think this is new but I just ran across it and think it is a nice addition to the toolkit.


    2001 07 17

    <A target="_blank" HREF=http://www.mvps.org/word/FAQs/MacrosVBA/AdaptiveMenus.htm>How to programmatically disable the Word 2000+
    Charles Kyle Kenyon
    Madison, Wisconsin

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Wellington, Wellington, New Zealand
    Posts
    378
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Tab order in a UseForm

    Hi Charles

    What a great list of resources. Just what's needed for an amateur programmer like me.

    But I still can't find what I want. Using Visual Basic for Word 97, I sometimes can't make the VBA editor to obey my instructions when setting the tab index. It renumbers them behind my back, and sometimes refuses to accept a valid entry.

    Any tips?
    Dale

  5. #5
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tab order in a UseForm

    Edited to include hyperlink - Andrew Cronnolly

    The tab index for controls on a Userform is determined by the order in which you create the controls.

    If you renumber any one control in code , that causes other controls to be also have their tab index changed.

    See MSFT KB article <A target="_blank" HREF=http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q153308>Q153308.</A>.

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Tab order in a UseForm

    If you just want to set the Tab order at design time, you can do so by right clicking on the UserForm and selecting Set Tab Order, and then move each control up and down the list as required. If you have controls within frames, just right click on the frames and do the same for those controls.

    Andrew C

  7. #7
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Wellington, Wellington, New Zealand
    Posts
    378
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Tab order in a UseForm

    Thanks to you both.

    I've tried right-clicking to set the order, but that doesn't work (in this particular case).

    I've now solved the problem by creating a new form, and copying the controls across in the order I want them. Which worked, but it's irritating to have to do it.

    Thanks for the advice, anyway
    Dale

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

    Re: Tab order in a UseForm

    I'm surprised that doesn't work- it works for me in both W97 and W2K.

    You could try setting the property TabIndex in reverse order. Click on the bottom right hand control, set it to zero. Click on the second last in the tab order, set it to 0. Go through all the controls on the form in reverse oder, and put zero into the TabIndex property. Each time you set it to zero, every other control on the form has the tab order bumped up by one.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  9. #9
    Silver Lounger Charles Kenyon's Avatar
    Join Date
    Jan 2001
    Location
    Sun Prairie, Wisconsin, Wisconsin, USA
    Posts
    2,049
    Thanks
    124
    Thanked 119 Times in 116 Posts

    Re: New on the Word MVP FAQ Page

    Too late to edit my first post, so I'll take it from here. Mr. Gate's Scan Disk decided I didn't really need a file allocation table on my hard drive so I've been down and out of touch for a while. Anyway:

    <font color=448800>14 October 2001</font color=448800>

    <A target="_blank" HREF=http://www.mvps.org/word/FAQs/Numbering/CureListNumbering.htm>How to cure Word's List Numbering with a dose of VBA </A> which isn't yet the promised article but a great source for information anyway

    <A target="_blank" HREF=http://www.mvps.org/word/FAQs/AppErrors/BlankDocNotBlank.htm>Why is my "Blank Document" not blank?</A>

    <A target="_blank" HREF=http://www.mvps.org/word/FAQs/Userforms/ExtractImgFromUserFm.htm>Extracting a picture from an Image Control in a UserForm</A>

    <A target="_blank" HREF=http://www.mvps.org/word/FAQs/Userforms/ExtractImgFromUserFm.htm>Extracting a picture from an Image Control in a UserForm </A>

    <A target="_blank" HREF=http://www.mvps.org/word/FAQs/Userforms/DeselectListBoxItem.htm>De-selecting a Selected Item in a Single-Select Listbox
    </A>

    <A target="_blank" HREF=http://www.mvps.org/word/FAQs/Userforms/CreateASplashScreen.htm>Creating a Splash Screen with a UserForm</A>

    <A target="_blank" HREF=http://www.mvps.org/word/FAQs/MacrosVBA/ClearArrayFromRAM.htm>Using the Erase statement to clear an array</A>

    <A target="_blank" HREF=http://www.mvps.org/word/FAQs/Formatting/NoWidthSpace.htm>How to make urls (and delimiters such as , /, : and @) wordwrap in Word</A> {revised article)



    earlier
    2001 September 21
    Nothing new on MVP site but the following are new or revised on my Word sites:
    <A target="_blank" HREF=http://www.addbalance.com/usersguide/basic_formatting.htm> Basic Formatting in Word</A> - added detail to the last section on cleaning up or resetting formatting.
    <A target="_blank" HREF=http://www.addbalance.com/usersguide/fields.htm#Function[/url> Fields</A> (draft page) - updated the keyboard shortcuts table to include Mac keys and also to group by key and by function.
    Charles Kyle Kenyon
    Madison, Wisconsin

Posting Permissions

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