Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 04-06-2011, 10:28 AM
Johnny thunder Johnny thunder is offline Check Box Macro Windows XP Check Box Macro Office 2003
Novice
Check Box Macro
 
Join Date: Apr 2011
Posts: 10
Johnny thunder is on a distinguished road
Default

That worked out great!

I have another question, I have changed a few check Boxes to Form Fields with drop-down comments "Add" "Delete" and I was able to write the code that will mirror the comment from my Select all form field but I was only able to write it for one other individual bookmark, I have a range of form fields 1-15 labeled "LMSI_Office1 - LMSI_Office15" and I was not sure how to write that in code?

Sub CopyField()
Dim Temp As String
Temp = ActiveDocument.FormFields("LMSI_Office1").Result
ActiveDocument.FormFields("LMSI_Office2").Result = Temp
End Sub

Above is my code. I also need to add something to this and don't know how to do it, I need the code to un-protect the sheet before running the macro (No password required) and then re-protect the sheet "protect document for forms" Any idea's on the above question?

The range question would really help out cause manually writing in 15 lines seems like overkill?

Thanks for your help!
Reply With Quote
 

Tags
macro, vba, word 2003



Similar Threads
Thread Thread Starter Forum Replies Last Post
Check Box Macro check with condition karti Word 2 03-15-2011 06:06 AM
Check whether Follow Up set konfis Outlook 0 10-27-2010 11:19 PM
Need Help with Using a Check Box Nick9589 Excel 1 05-01-2010 09:29 AM
Spell Check WorkerB Word 2 11-21-2009 07:22 AM
Check Box in Word serayam Word 1 11-06-2008 06:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:02 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft