+ Reply to Thread
Results 1 to 4 of 4

VBA: Reset Field Code

  1. #1
    Registered User
    Join Date
    07-31-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2010
    Posts
    2

    VBA: Reset Field Code

    Hi,
    I am new to this forum and this is my first post. (Even though I have used the forum extensively as a Guest )

    I have coded this macro that will change the display text of a from field in word. I have made a word document with checkboxes, which I am protecting to activate the checkboxes. However I want the users to enter certain data to the document. For this I have added a ‘MACROBUTTON’ field, which will trigger below procedure:

    Please Login or Register  to view this content.
    I wanted to know how robust the macro is? And possible ways to improve it?

    Thank you
    Last edited by arlu1201; 07-31-2012 at 04:04 AM.

  2. #2
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: VBA: Reset Field Code

    Welcome to the forum.

    I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,667

    Re: VBA: Reset Field Code

    Hi Pravin,

    I can't see any sense in having the MACROBUTTON field. You don't need it to add content to the document (you could just as easily use a text formfield or write to a bookmark) and, having populated the MACROBUTTON field, your user can't double-click it in a protected Section to change its contents.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  4. #4
    Registered User
    Join Date
    07-31-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: VBA: Reset Field Code

    Dear Arlu and macropod,
    Thank you for your comments. Sorry for the late reply. Removed the macrobutton field and added a text formfield instead.

    Cheers,
    Pravin

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1