Forms, check boxes linking to a list

Tutorials Win: Microsoft Windows Forum

- Previous
  - 1
    - Delete text frames and text Using Word 2003: I am trying to delete all text frames and the text in documents. I have tried various For Next routines that have deleted only some of the frames but have left bordered text in their place. Help!! -- CLG Tag: Forms, check boxes linking to a list Tag: 94694
  - 2
    - More On Class Last week Jonathan, Karl, and Jean-Guy where schooling me on Class modules. I have read the articles that Jonathan posted and wanted to try to put theory to practice. Submitted for comments by those or any other master. With the input of a few others, I have put together a routine that ensures the input to a VBA input box is a numeric whole number greater than five. It is several lines of code and I thought perhaps that it could be a "Class" and if I need a whole number greater than 5 several times in a procedure that I could call the class. Here is my testing procedure: Sub TestOfClass() Dim myNum As myNumClass Dim i As Long Set myNum = New myNumClass For i = 1 To myNum.lngNumber Debug.Print "Test1" Next i Set myNum = New myNumClass For i = 1 To myNum.lngNumber Debug.Print "Test2" Next i End Sub I created a Class named myNumClass and entered this code: Private mLngNumber As Long Private Sub Class_Initialize() Dim strInput As String Dim bInValid As Boolean Do bInValid = False strInput = InputBox("Enter a whole number greater than 5", _ "Number Input", "0") If strInput = vbNullString Then Exit Sub On Error Resume Next If strInput <> CLng(strInput) Or CLng(strInput) <= 5 Then If Err.Number = 13 Then bInValid = True On Error GoTo 0 Else bInValid = True End If End If If bInValid Then MsgBox "You must enter a valid whole number that is > 5." End If Loop While bInValid mLngNumber = strInput End Sub Property Get lngNumber() As Long lngNumber = mLngNumber End Property When I run TestofClass, I see the results that I expect. My questions are: 1. Is this a sensible use of a class? 2. Is it constructed in the conventional manner? 3. Do I have my terms correct? I mean is it correct to say "Call the class?" Thanks. Tag: Forms, check boxes linking to a list Tag: 94675
  - 3
    - Bottom of Document How do I force my text to the bottom of the document no matter what is above it? I want to place an Image or Data at the top of varying length but I want this specific text (4 rows) at the bottom left. Tag: Forms, check boxes linking to a list Tag: 94670
  - 4
    - multi-change script/tool Hello, Is it possible in Microsoft Word 2000 to change many different words in a document with one "tool", script or macro? I have a list of 5000 text advertisements and every month I need to erase 500-600 of them. I do it manually by "find/change" their signatutes (every ad has its unique signature) and it takes me 3 hours to do so. Veery boooooooring! Maybe there is a way to automate it? wZ Tag: Forms, check boxes linking to a list Tag: 94667
  - 5
    - Tricky (?) headline/paragraph numbering problem Hi! I have a problem with numbering headings and following paragraphs that I wonder if it's possible to solve. a) I have a couple of headings like this: 1 Heading 1 bla bla 1.1 Heading 2 bla bla 1.1.1 Heading 3 bla bla 2 Heading 1 bla bla 2.1 Heading 2 bla bla 2.1.1 Heading 3 bla bla This works fine, no problem. b) Now I also want numbered paragraphs related to the headings like this: 1 Heading 1 bla bla 1.1 Paragrah 2 bla bla 1.1.1 Paragrah 3 bla bla This also works fine. c) The problem is though if I now insert another heading, it links to the previous paragraph instead of the heading. 1 Heading 1 bla bla 1.1 Paragrah 2 bla bla 1.1.1 Paragrah 3 bla bla 1.2 Heading 2 bla bla <------------Wrong! Should be 1.1 (ie related to the previous heading, not the previous paragraph). The paragraphs should be linked to the headings but not the opposite so to say. I don't know how to do this if possible? Any ideas? Best /e Tag: Forms, check boxes linking to a list Tag: 94657
  - 6
    - Prompting for default information Hello, On opening a document, I'd like to prompt users for default information (2 questions) that would automatically be placed in a document. Is msgbox the way to do this? -- Guiseppe Tag: Forms, check boxes linking to a list Tag: 94647
  - 7
    - Finding Macrobutton and delete I have a table in a Word2000 document. In the table, I have multiple {macrobutton insertpicture} fields. After inserting the picture, the placeholder and text appear after the picture, taking up space and displaying the default text. How can I search the document and delete all instances of the macrobutton placeholders? I plan on running the procedure in a print procedure code module. Thank you very much. Tag: Forms, check boxes linking to a list Tag: 94639
  - 8
    - Saving embedded Visio objects as Visio files Our Word documents include Visio objects whose original files are now scattered. I need VBA to do the equivalent of double-clicking to open the object in Visio, saving as a file, and then returning to Word to find the next Visio object. I've been looking at examples of calling other apps, but I don't understand how to move between Word and Visio as I described. Any example code would be a big help. Tag: Forms, check boxes linking to a list Tag: 94631
  - 9
    - Using DateDiff in Formfields... Hey Gang, Word 2003 Trying to create an automated form for my church and am stumped as to how to do this. I have a calendar form (actually two of them) that populate formfields (StartDate and EndDate). I have another formfield (TotalDays) that I cm trying to populate with the number of days difference between the other two formfields. I assigned the following macro to the "Entry" of the TotalDays field. However, it is not working. Sub CalculateTotalDays() ActiveDocument.FormFields("TotalDays").Result = DateDiff("d", EndDate, StartDate) End Sub I am assuming that Word can't recognize formfields the same way Acces does to know to use them in the calculation, but I can't seem to find a way to make it work. Any ideas? TIA! -- Bill Foley Microsoft PowerPoint MVP Microsoft Office Specialist Master Instructor www.pttinc.com Tag: Forms, check boxes linking to a list Tag: 94616
  - 10
    - Hitting Cancel Button on Input Box takes me to "GoTo Error MsgBox" instead of exiting the macro Dear Experts: I created a macro that allows the user to format the Table of Contents by using InputBoxes. The user can fill in a value into the dialog box "Please indicate the left indent in centimeters". The value he/she indicates is then transferred to the "With ... " line. I then want the the user to see the previously filled in value (in centimeters) whenever he re-runs the macro. It works fine with the following macro lines (only part of the whole macro) but as soon as I hit the Cancel Button on the InputBox form it does not exit the sub but takes me to the Error Message on the bottom. How do I have to rewrite the code that - when the user hits the Cancel Button on the inputbox form - the macro is exited? Dim LeftIndent As Single LeftIndent = Round(PointsToCentimeters(ActiveDocument.Styles_("Custom_TOC_Style").ParagraphFormat.LeftIndent), 1) On Error GoTo Mistake 'since I declared the LefIndent as single, entering character(s) or blank(s) causes the macro to jump to the Error Message below LeftIndent = InputBox("Please indicate the left Indent", "Indent Size", LeftIndent) If LeftIndent <= 1.3 Then MsgBox "No values below 1.3 are allowed. " Exit Sub End If With ActiveDocument.Styles("Custom_TOC_Style").ParagraphFormat .LeftIndent = CentimetersToPoints(LeftIndent) .FirstLineIndent = CentimetersToPoints(-LeftIndent) End With Exit Sub Mistake: MsgBox "only numbers are allowed, no blanks or characters", vbInformation End Sub Help is appreciated. Thanks in advance Andreas Tag: Forms, check boxes linking to a list Tag: 94607
  - 11
    - Inserting Single word document into multiple documents Hi, Im looking to add a two page word document at the end of around 3000 CVs .Is there a way of doing this all at once? I have looked all over the internet and all i can find is programs that will insert text into open documents.I need to do it to a whole folder. Help is much appreciated. Thanks Terry Tag: Forms, check boxes linking to a list Tag: 94606
  - 12
    - repeat text entered one place to another place I am creating a form and want to be able to take text entered into a field and have it automatically copy and update to another area in the same document. Any help will be appreciated! Tag: Forms, check boxes linking to a list Tag: 94603
  - 13
    - Setting different character styles on one line of text I have to put a line of text in a footer which has three different character styles with three different sets of text. They all work on their own, but each one cancels out the one previous to it because I do not know how to set the styles & text properly so if I run the code all I am left with is the third style and text. Here is the code I am using: ActiveDocument.Sections(1).Footers(wdheaderFooterFirstPage).Range.Style = (³FooterBold²) ActiveDocument.Sections(1).Footers(wdheaderFooterFirstPage).Range.Text = ³Name² ActiveDocument.Sections(1).Footers(wdheaderFooterFirstPage).Range.Style = (³FooterPlain²) ActiveDocument.Sections(1).Footers(wdheaderFooterFirstPage).Range.Text = ³Address² & vbTab ActiveDocument.Sections(1).Footers(wdheaderFooterFirstPage).Range.Font.Size = 6 ActiveDocument.Sections(1).Footers(wdheaderFooterFirstPage).Range.Text = ³Printed on recycled paper² How can I get all of these co-existing in the footer. The Name and Address text sections are of varying length. Thanks for any help Sol Tag: Forms, check boxes linking to a list Tag: 94597
  - 14
    - shortcut Hello, I have a perplexing problem. First a little background. I created a folder named 'MoJR Documents'. This folder is located on a secondary drive(D:\MoJR Documents) apart from Word. I have a folder named 'My Documents' under C:\Documents and Settings\MoJR\My Documents. I decided to leave this folder in it's original location figuring I may use it as an extra folder at some point. Currently, it has one document in it. I created a shortcut to the 'D:\MoJR Documents' folder and placed it on the taksbar. However, when I open this folder using the shortcut created for it, the address window in Windows Explorer indicates 'My Documents'. This may not be a problem, I'm not sure. However, it may be causing a problem when I try to write a script to use a hotkey combo to open a specific document in the 'D:\MoJR Documents' folder. Why would there be a discrepancy between the shortcut and the folder listed in the address window of Win Explorer? How can I correct this problem? Thank you, MoJR Tag: Forms, check boxes linking to a list Tag: 94595
  - 15
    - Getting the REF number from a SEQ field For a cross-reference to a SEQ field (such as the one on a figure caption) a REF field includes a long number, looking like this: { REF_Ref4018934786 \h } But the SEQ field that this points to doesn't display that number. The number must be in the document someplace, but how can I retrieve it? It's the only way I can tie together various things relating to a figure. Thanks. Tag: Forms, check boxes linking to a list Tag: 94589
  - 16
    - Range Oddity I wonder why you can add a formfield to a range set to a table cell range, but you can't add a field to range set to a table cell range. As the code below illustrates, to add a field to a table cell you first have to collapse a range assigned to a table cell range: Sub RangeTest() Dim oRng1 As Word.Range Dim oRng2 As Word.Range Set oRng1 = ActiveDocument.Tables(1).Rows(1).Cells(1).Range Set oRng2 = ActiveDocument.Tables(1).Rows(1).Cells(2).Range ActiveDocument.FormFields.Add oRng1, wdFieldFormTextInput On Error GoTo Err_Handler ActiveDocument.Fields.Add oRng2, wdFieldQuote, "Test" Exit Sub Err_Handler: oRng2.Collapse wdCollapseStart Resume End Sub Tag: Forms, check boxes linking to a list Tag: 94584
  - 17
    - Print multipage doc on "other" printer I have finally gotten my doc to print where and how I need it. Essentially, I needed it to not go to the default printer, save a copy as doc file by unique name, copy to clipboard and a few other things I needed. What I can't get is how to tell it if doc is = or less than 1 page, go to "printer a" else go to "printer b" I was going to paste all the defective code here but it takes up space and doesn't work. Here is the part that does work. Thanks for any help. Jeff 'Sets printer to print this document to the datacenter printer, does not chnage default printer. Dim sCurrentPrinter As String sCurrentPrinter = ActivePrinter ActivePrinter = "\\Stpprntv02\FSA_Claims Holding on NE08" Application.PrintOut FileName:="", Range:=wdPrintAllDocument, Item:= _ wdPrintDocumentContent, COPIES:=1, Pages:="", PageType:=wdPrintAllPages, _ Collate:=True, Background:=True, PrintToFile:=False, PrintZoomColumn:=0, _ PrintZoomRow:=0, PrintZoomPaperWidth:=0, PrintZoomPaperHeight:=0 ActivePrinter = sCurrentPrinter 'unlocks doc (doc is protected) to copy the whole doc to save in Acorde. If ActiveDocument.ProtectionType <> wdNoProtection Then ActiveDocument.Unprotect End If 'copies whole doc to clipboard Selection.WholeStory Selection.Copy 'locks doc after paste into Acorde If ActiveDocument.ProtectionType = wdNoProtection Then ActiveDocument.Protect _ Type:=wdAllowOnlyFormFields, NoReset:=True End If 'Creates numeric text file called "settings" (on network) to store doc by unique name Order = System.PrivateProfileString("Q:\Shared\Settings.Txt", _ "MacroSettings", "Order") If Order = "" Then Order = 1 Else Order = Order + 1 End If System.PrivateProfileString("Q:\Shared\Settings.txt", "MacroSettings", _ "Order") = Order 'Saves file with unique name to network location as backup by time and sequence number. ActiveDocument.SaveAs FileName:="q:\shared\denial2dc\" & Format(Now, "hh-mm-ss") & Format(Order, "-00#") End Sub Tag: Forms, check boxes linking to a list Tag: 94583
  - 18
    - Form question i have a form that includes multiple sections. sections can have checkboxes and/or dropdown fields. i want to allow the user to go thru the sections and check boxes pick from drop downs. once they are done i want them to have a toolbar button that will "hide" any unchecked boxes and any unselected drop down boxes. I don't want to delete the unchecked/unselected boxes since the user will reuse the document in the future. I just need the unchecked boxes and any unselected drop down boxes to be hidden, so, the document can be view/printed/faxed, ect without all the clutter of the unneccesary text. any advice would be appreciated. thanks JB914 Tag: Forms, check boxes linking to a list Tag: 94581
  - 19
    - VBE Auto List Members I just noticed something odd with the VBE Auto List Members feature You can type the line: ActiveDocument.Fields.Add Selection.Range, 'and no list appears of the various wdFieldTypes however, if you type the line: ActiveDocument.FormFields.Add Selection.Range 'then the complete list appears. It is odd that the feature is absent where it would be most handy, and present when selecting over 95% of the items listed would result in a RTE "Subscript out of range." Tag: Forms, check boxes linking to a list Tag: 94566
  - 20
    - Inserting a wdFieldFormTextInput into a word table cell I'm having issues inserting a wdFieldFormTextInput into a word table cell. I create the table with a macro which works perfectly. I then need to insert a wdFieldFormTextInput into the first rows 2nd cell. I can set the text easily enough using .............. [code] MyRange.Table(1).Rows(1).Cells(2).Range.Text = " Testy Text " [/code] I've tried multiple ways of adding the merge field all of which have failed. I'm grateful for any advice! Here is an example of what I've tied to do to accomplish what i'm after! [code] ActiveDocument.Fields.Add Range:=MyRange.Tables(1).Rows(1).Cells(2).Range, Type:=wdFieldFormTextInput, Text:="MERGEFIELD TESTMERGER", PreserveFormatting:=True [/code] I get the generic "Run-time error '4605': This command is not available" error message when trying to run the above. Tag: Forms, check boxes linking to a list Tag: 94559
  - 21
    - How to read UTF-8 chars using VBA Hi, I am currently developing some Word templates (office 2003) + VBA I have a UTF-8 encoded text file...I wanted to read and show the values into a list box... The charactors are getting changed while reading and filling the control...(but in the text file they are perfect) I tried FSO and Open statement with Line input.. I dont know how to Convert into normal chars.. How to resovle.. ? Its bit urgent...give me some useful links Many thanks. MSK. Tag: Forms, check boxes linking to a list Tag: 94558
  - 22
    - Adding Hyperlink Text, then deleting Hello, So, I have a big macro in Word 2003 that I've been working on that keeps growing. The end goal is to have a complete script to convert a Word document into a wiki formatted document (for posting on our internal wiki). I've got most of it down, but hitting a snag with changing hyperlinks into wiki formatted text. First, I need to find the hyperlinks, then I need to add wiki formatting in front of them and after them, then delete the hyperlink itself. To add to the issue, a significant number of my hyperlinks are tied to shapes so when I delete all hyperlinks - it removes them completely, leaving the shape but no address. Can you please help? Thank you, Alison Tag: Forms, check boxes linking to a list Tag: 94554
  - 23
    - List of Available Dialog boxes in Word (VBA) Does anyone happen to have a list of all the built in Dialog Boxes in Word that can be called using VBA? Tag: Forms, check boxes linking to a list Tag: 94548
  - 24
    - dealing with missing references Hi! I have a problem where I reference som dll-files that are available when I work connected to the network, but not when I work off line. Hence when I use Word off line I get an error. Any ideas? Trap it through on error? Something else? Best /e Tag: Forms, check boxes linking to a list Tag: 94546
  - 25
    - Edit Keylog File Hi everyone. A keylogger I have spits out a file that is very difficult to read! My daughter makes a ot of mistakes typing, so there are a lot of backspaces! Unfortunately, the keylogger records a backspace as [Backspace]. Is there a way to write code to start at the beginning of the file and essentially do an edit/replace, deleting [Backspace] AND the character before it? Thanks!! Tag: Forms, check boxes linking to a list Tag: 94540
- Next
  - 1
    - XML and validation I have 2 big problems with an XML Validation: First I want to load an XML File, attach a XSL Schema and validate it: Set xmdoc = Documents.Open(filename) 'schema anbinden blnSchemaAttached = False For Each objNS In Application.XMLNamespaces If objNS.URI = uriSchema Then 'objNS.AttachToDocument xmdoc blnSchemaAttached = True Exit For End If Next If blnSchemaAttached = False Then 'xmdoc.XMLSchemaReferences.Add "bbreport.xmlref.sp", "bbreport", pathSchema, True Set objNS = Application.XMLNamespaces.Add(pathSchema, uriSchema, "bbreport", True) End If objNS.AttachToDocument xmdoc xmdoc.XMLSchemaReferences(uriSchema).Reload xmdoc.XMLSchemaReferences.AutomaticValidation = True 'Schemaverletzungen prÃ¼fen xmdoc.XMLSchemaReferences.Validate If xmdoc.XMLSchemaViolations.count > 0 Then ' ValidationStatus <> wdXMLValidationStatusOK Then MsgBox "error" End If But it's not possible to validate, the code doesn't recognize not valid xml Files. The second problem comes creation a new file: I create e new file and want to attach an existing schema. Set formdoc = ActiveDocument 'neues dok und Schema anbinden Set xmdoc = Documents.Add xmdoc.XMLSaveDataOnly = True blnSchemaAttached = False For Each objNS In Application.XMLNamespaces If objNS.URI = uriSchema Then 'objNS.AttachToDocument xmdoc blnSchemaAttached = True Exit For End If Next If blnSchemaAttached = False Then Set objNS = Application.XMLNamespaces.Add(pathSchema, uriSchema, "bbreport", True) 'xmdoc.XMLSchemaReferences.Add "bbreport.xmlref.sp", "bbreport", pathSchema, True 'objNS.AttachToDocument xmdoc End If xmdoc.XMLSchemaReferences(uriSchema).Reload In the last line I get an Error, I dont understand. It seems, like I need another XML Schema beside my own Schema to save the doc. It would be very nice, if someone had any ideas for me Stefan Tag: Forms, check boxes linking to a list Tag: 94536
  - 2
    - formatting table cells with WordArt I'm trying to create a sheet of labels to use on book spines. Each label will contain one letter formatted and colored with WordArt and centered on the label (first letter of author's last name). I've managed to create a sheet of labels containing the one letter centered in each label, but I can't seem to figure out how to automate changing the letters to WordArt, although I can do it manually. I was attempting to loop through each cell (standard Avery label layout), select the text and change to WordArt, and then change the color of the text. I did manage to do it once, but the WordArt all ended up in the middle of the document. Can anyone tell me how to loop through, select the text in each cell and change it to WordArt in the same spot? Recording the macro gives me the middle of the document as anchor points - I can't figure out what the anchor points would be for each label. Any suggestions would be greatly appreciated! Jane Tag: Forms, check boxes linking to a list Tag: 94534
  - 3
    - Vb and MS Word Hi There I seem to be having some problems with my coding and am looking for some help. I am designing an application in VB 2005 use for editing spelling and grammar errors in MS Word documents. The application would check and edits, as well as proof read MS Word documents. The following is a snippet of the code I am working on: 1 Dim wordapp As New Word.Application 2 Dim doc, temp, temp1 As Word.Document\3 3 4 5 6 'Determinig whether Word is running or not 7 While wordapp.Visible = True 8 doc = wordapp.Templates.Application.ActiveDocument 9 10 wordapp.ActiveDocument.Content.Text = RichTextBox2.Text 11 'doc = wordapp.ActiveDocument 12 'wordapp.ActiveDocument.Content.Text = RichTextBox2.Text 13 ToolStripStatusLabel2.Text = doc.Words.Count 14 15 End While 16 17 If wordapp.Visible = False Then 18 wordapp.Visible = True 19 If wordapp.Visible = True Then 20 temp = wordapp.ActiveDocument 21 End If 22 temp = wordapp.Documents.Add() 23 temp = wordapp.ActiveDocument 24 temp.Content.Text = RichTextBox2.Text 25 26 'doc = wordapp.ActiveWindow 27 'wordapp.Selection.TypeText(RichTextBox2.Text) 28 'wordapp.ActiveDocument.Content.Text = RichTextBox2.Text 29 ToolStripStatusLabel2.Text = doc.Words.Count 30 31 ElseIf wordapp.Visible = True Then 32 temp = wordapp.Documents.Add() 33 doc = wordapp.ActiveDocument 34 'temp = doc 35 'doc.Content.Text = RichTextBox2.Text 36 'doc = wordapp.ActiveDocument 'set doc to activedocument 37 wordapp.Selection.TypeText(RichTextBox2.Text) 38 'ActiveDocument.Content.Text = RichTextBox2.Text 39 ToolStripStatusLabel2.Text = doc.Words.Count 40 End If The problem appear in line 17 -24 where I am checking to see whether a MS Word document is open or not. The doccument could be one currently used by the user or one that have been saved or just a new document. My question is as follows: â?¢ In line 17 â?? 21 of my code, I am attempting to see whether or not the MS Word application is running or not. If the application is runninng and a file is use, I want that file assign to ActivateDocument. â?¢ On my form there are two rich text boxes: one is for displaying the paragraph containing the spelling and writing errors. The second, displays the whole document. My problem is whenever I enter text into the text box, instead of that typed text into the activated document it appears in a new MS Word Document. I would be grateful if anyone can advice me how to overcome this problem. Thanks, Immy â?? Tag: Forms, check boxes linking to a list Tag: 94528
  - 4
    - I thought that I had a basic understanding of errors This is a multi-part message in MIME format. ------=_NextPart_000_0026_01C7170E.4D45F5C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Can someone help me understand why TestA works and TestB and TestC do = not: Sub TestA() On Error Resume Next Err.Raise 6 On Error GoTo SubErr: Err.Raise 13 SubErr: MsgBox "Eureka!!" End Sub Sub TestB() On Error GoTo Err_Handler Err.Raise 6 Err_Handler: On Error GoTo SubErr: Err.Raise 13 SubErr: MsgBox "Eureka!!" End Sub Sub TestC() On Error GoTo Err_Handler Err.Raise 6 Err_Handler: On Error Resume Next Err.Raise 13 MsgBox "Eureka!!" End Sub In TestB and TestC, I have tried about every combination of GoTo, = Resume, Err.Clear, that I can think of. I don't understand why the code = isn't handling the second error. thanks. --=20 Greg Maxey/Word MVP See: http://gregmaxey.mvps.org/word_tips.htm For some helpful tips using Word. ------=_NextPart_000_0026_01C7170E.4D45F5C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.5730.11" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#f8f2d6> <DIV>Can someone help me understand why TestA works and TestB and TestC = do=20 not:</DIV> <DIV> </DIV> <DIV>Sub TestA()<BR>On Error Resume Next<BR>Err.Raise 6<BR>On Error GoTo = SubErr:<BR>Err.Raise 13<BR>SubErr:<BR>MsgBox "Eureka!!"<BR>End = Sub<BR></DIV> <DIV>Sub TestB()<BR>On Error GoTo Err_Handler<BR>Err.Raise=20 6<BR>Err_Handler:<BR>On Error GoTo SubErr:<BR>Err.Raise = 13<BR>SubErr:<BR>MsgBox=20 "Eureka!!"<BR>End Sub<BR></DIV> <DIV>Sub TestC()<BR>On Error GoTo Err_Handler<BR>Err.Raise=20 6<BR>Err_Handler:<BR>On Error Resume Next<BR>Err.Raise 13<BR>MsgBox=20 "Eureka!!"<BR>End Sub<BR></DIV> <DIV>In TestB and TestC, I have tried about every combination of GoTo, = Resume,=20 Err.Clear, that I can think of.  I don't understand why the code = isn't=20 handling the second error.  thanks.<BR>-- <BR>Greg Maxey/Word=20 MVP<BR>See:<BR><A=20 href=3D"http://gregmaxey.mvps.org/word_tips.htm">http://gregmaxey.mvps.or= g/word_tips.htm</A><BR>For=20 some helpful tips using Word.<BR></DIV></BODY></HTML> ------=_NextPart_000_0026_01C7170E.4D45F5C0-- Tag: Forms, check boxes linking to a list Tag: 94525
  - 5
    - How to keep Microsoft Word from automatically doublespacing???? PLEASE Help!! Hello, A re-occuring problem I've been having w/ Microsoft Word is this- If I put an extra line between one line of text and another, like this... Here is my text Here is the next line ....and if I do this several times, Word automatically starts doing it for me. But when it comes time when I don't want an extra line between lines (i.e. I don't want it double- spaced), I'm unable to do so. In other words, Word automatically double spaces when I push 'Enter'. I have spent hours trying to figure out this problem. I have gone through every possible automatic setting. So if someone could PLEASE tell me how to keep Word from automatically doing this, that would be wonderful!!! Thanks so much everyone for your time and help! Tag: Forms, check boxes linking to a list Tag: 94523
  - 6
    - How to keep Microsoft Word from automatically doublespacing???? PLEASE Help!! Hello, A re-occuring problem I've been having w/ Microsoft Word is this- If I put an extra line between one line of text and another, like this... Here is my text Here is the next line ....and if I do this several times, Word automatically starts doing it for me. But when it comes time when I don't want an extra line between lines (i.e. I don't want it double- spaced), I'm unable to do so. In other words, Word automatically double spaces when I push 'Enter'. I have spent hours trying to figure out this problem. I have gone through every possible automatic setting. So if someone could PLEASE tell me how to keep Word from automatically doing this, that would be wonderful!!! Thanks so much everyone for your time and help! Tag: Forms, check boxes linking to a list Tag: 94522
  - 7
    - Application.version numbers for Word I'm trying to branch some code based on Aplication.Version numbers; I know that 2007 is version 12, and Word 2003 , but I don't know the other version numbers, and haven't been able to find them. Can someone help? Specifically, I need to differentiate Office 2007 versus Office 2000 or 2003, versus earlier versions. I'm guessing I can use this code: Dim versStr as String Select Case CInt(Application.Version) Case >=12: versStr = "Word 2007" Case 11: versStr = "Word 2003" Case 10: versStr = "Word 2000" Case Else: versStr = "Word 97 or earlier" End Select Can anyone verify these numbers for me?? thanks gary Tag: Forms, check boxes linking to a list Tag: 94519
  - 8
    - APA style format template I am trying to make a template for APA style papers . I am all new at this and having a very hard time - HELP! Tag: Forms, check boxes linking to a list Tag: 94512
  - 9
    - specfic file name macro from form fields entries I want a document to automatically have the file name entered when an employee clicks save or the save as. The file name will be a combination of two form fields (Text6 and Text70). Is there a way to get the entries from these two fields and append them into one file name? I also would like to these save at a specific location on a network drive. I have no experience in VB. Word 2003 Any help would be appreciated! Tag: Forms, check boxes linking to a list Tag: 94509
  - 10
    - Height of the text in cell Hi folks. I need to write a macros that reduces size of text in table when it begin to resize in case of long string of text inserted ? Tag: Forms, check boxes linking to a list Tag: 94503
  - 11
    - How do I turn off file conversion. It's affecting all my files All my files have becomeconverted to some strange text. I have no idea what I did or didn't do. The message comes up giving me 3 choices, Window (default) MS dos or other decoding. I've tried all 3 at various times but nothing works. I really need my files. Can someone sugest something? Tag: Forms, check boxes linking to a list Tag: 94499
  - 12
    - Resources to support Word in multiple languages? I have a Word template with added menus, toolbars, forms, etc. Now I am supporting languages other than English. The problems come when I need to refer to Word menu items in my user interface or documentation. For example, I might need to tell users to go to: Menu: Help > SpecialTemplate Help or Menu: Insert > SpecialTemplate Symbols... Needed: "Help" or "Insert" in other languages (Spanish, French, German, etc.). Where can I find a reference that shows the menus and dialog boxes for Word in different languages? Are there other resources available for those of us who need to support Word in multiple languages? Approaches tried or unlikely to work: *************************** "Microsoft Terminology" is not Word-specific and does not cover menus. Examples of things not covered: what to call a "tab" on a MultiPage object, Word menus. www.microsoft.com/globaldev/tools/MILSGlossary.mspx Buying the multi-lingual version of MS Office with all the language packs needed as I need to support Word 97, 2000, 2002, 2003 and soon 2007 (unless this can be done without great expense) Tag: Forms, check boxes linking to a list Tag: 94497
  - 13
    - Search not working as wanted G'day there One & All, I'm currently working on my first Word VB project (well, the first one I've not abandoned and forgotten about) and I've obviously got something wrong. I have some experience with VB for Excel, so most of the concepts ring a bell or two, but the Word object model escapes me and I'm still trying to get my head around it. I have 3 years worth of occurrence logs that I need to search for a specific string. The logs consist of a single table with some consistent entries. Unfortunately this string appears in all logs in one of those entries which I describe as a "heading area". I need to find it in the "narrative" section, not one of the heading areas. The logs are organised in Year Folders, with Month folders inside. The log names are the date for each daily log. I'm trying to perform the following tasks: 1. Use dialog to obtain enclosing folder for all documents - done. 2. Iterate through all subfolders to find log documents - done. 3. Search through each log in turn and search for one of the consistant headings, then commence searching from the next line down for the target word. If found, then store filename in base docuement and ... 4. Stop at end of document, and got to next one - done. Courtesy of the Word MVP pages, and this group's archives, I think I've got 1, 2 & 4 working OK. However 3 is giving me a few problems. I'm getting false hits, and missing occurrences of the target. Ergo, I've got something out of whack. I hope that someone here may be able to point me in the right direction. Here's my searching code: Application.Documents.Open FileName:=strPATH & strFILENAME (Do I need to "open"?) Application.Documents(strFILENAME).Activate With Selection.Find .Text = "Objectives C" ' Heading where search begins from next line .MatchWholeWord = True .Font.Underline = wdUnderlineSingle Do While .Execute Selection.GoTo what:=wdGoToLine, which:=wdGoToNext With Selection.Find .Text = "hotel" .Forward = True .Wrap = wdFindStop .MatchCase = False .MatchWholeWord = True If .Found = True Then strFULLNAME = Mid(strPATH & strFILENAME, 78, Len(strPATH & strFILENAME) - 77) ' Leave just parent folder and filename If Len(objSTOREDOC.Content) = 0 Then _ objSTARTRANGE.InsertAfter strFULLNAME & vbCr Else objSTOREDOC.Content.Select Selection.Collapse direction:=wdCollapseEnd Selection.InsertAfter strFULLNAME & vbCr End If End If End With Loop End With Application.Documents(strFILENAME).Close strFILENAME = Dir (This is repeated in a loop) Hopefully this will make sense and someone can point out a better way to do it. Thanks for listening, -- See ya, Ken McLennan Qld, Australia Tag: Forms, check boxes linking to a list Tag: 94494
  - 14
    - Can't open certain help file pages Office 2003 In Word VBA (as well as Excel VBA), if I type a help term in the "Type a question for help" box, several help file pages shown as hyperlinks generally appear. However, those links with "(Visual Basic for Applications)" at the end of the help-page name do not work when I click on them. (Example: "Character Set (0-127) (Visual Basic for Applications)".) Nothing happens. Other hyperlinks, to Word-, Excel-, or Office-related VBA help pages, work fine in bringing up the relevant help page. In the Office 2003 installer, Office Shared Features > Visual Basic > Visual Basic Help is installed. Any ideas on how to make these help pages appear? Thanks. Tag: Forms, check boxes linking to a list Tag: 94473
  - 15
    - Who has the file open? I have been using the code posted on the MVP site at http://word.mvps.org/FAQs/MacrosVBA/CheckIfFileOpen.htm and I would now like to find out who has the file open if it is open. Is this possible please? Thanks Stephen Tag: Forms, check boxes linking to a list Tag: 94463
  - 16
    - How to install MS Word with out macro language capabilities ... I wonder how you could do something like that. . I don't mean disabling it or not letting certain users use it, but actually not installing this functionality at all . lbrtchx Tag: Forms, check boxes linking to a list Tag: 94456
  - 17
    - Adding Multiple Rows to a Table in a Word Form First off I would like to thank all of the people that post, and all the people that respond. I have lurked for a long time, dependent on the Q&A of others. Today I have spent 12 hours reviewing and steeling snippets from all over the web. I have my table set up to add a row at the end of my table on my protected form, and to add a text form field to 5 of the 7 cells, and also add & populate 2 separate dropdown lists. This works and I could stop here. That being said, my table can be updated with only several rows or up to 5 full pages. I would like to tweak my VBA code to request some sort of input and it would populate that many rows. I am guessing that the best answer would be to loop my current code the number of times the user input. If so, I am guessing it should be fairly easy addition for the loop. Lastly, I am posting because I am sure there are other people that may / will be looking for a similar solution. I am enclosing my code below in case this information is needed to answer my question. I still have to update my comments, sorry. Sub AddRow2() Dim oTbl As Table Set oTbl = Selection.Tables(1) response = MsgBox("Would you like to Add a new row?", vbQuestion + vbYesNo) If response = vbYes Then ActiveDocument.Unprotect ' Disable the AddRow macro that is currently in the last cell ' (since we're creating a new last cell) Selection.Tables(1).Cell(Selection.Tables(1).Rows.Count, Selection.Tables(1).Columns.Count).Range.FormFields(1).ExitMacro = "" Selection.InsertRowsBelow 1 Selection.Collapse (wdCollapseStart) myRow = Selection.Information(wdStartOfRangeRowNumber) Selection.FormFields.Add Range:=Selection.Range, Type:=wdFieldFormTextInput 'Selection.SelectCell Selection.Bookmarks.Add Name:="a1temp", Range:=Selection.Cells(1) myCount = ActiveDocument.Range.FormFields.Count With ActiveDocument.FormFields(myCount) .Name = "text1row" & myRow .Enabled = True End With Selection.Bookmarks.Add Name:="a1temp", Range:=Selection.Range Selection.MoveRight Unit:=wdCell Selection.FormFields.Add Range:=Selection.Range, Type:=wdFieldFormTextInput myCount = ActiveDocument.Range.FormFields.Count With ActiveDocument.FormFields(myCount) .Name = "text2row" & myRow .Enabled = True End With Selection.MoveRight Unit:=wdCell Set myField3 = Selection.FormFields.Add(Range:=Selection.Range, Type:=wdFieldFormDropDown) myCount = ActiveDocument.Range.FormFields.Count With ActiveDocument.FormFields(myCount) .Name = "text3row" & myRow .Enabled = True With myField3.DropDown.ListEntries .Add Name:=" " .Add Name:=" Files " .Add Name:=" Object " .Add Name:=" Report " End With End With Selection.MoveRight Unit:=wdCell Selection.FormFields.Add Range:=Selection.Range, Type:=wdFieldFormTextInput myCount = ActiveDocument.Range.FormFields.Count With ActiveDocument.FormFields(myCount) .Name = "text4row" & myRow .Enabled = True End With Selection.MoveRight Unit:=wdCell Set myField5 = Selection.FormFields.Add(Range:=Selection.Range, Type:=wdFieldFormDropDown) myCount = ActiveDocument.Range.FormFields.Count With ActiveDocument.FormFields(myCount) .Name = "text5row" & myRow .Enabled = True With myField5.DropDown.ListEntries .Add Name:=" " .Add Name:=" Promote " .Add Name:=" Restore " .Add Name:=" Delete " End With End With Selection.MoveRight Unit:=wdCell Selection.FormFields.Add Range:=Selection.Range, Type:=wdFieldFormTextInput myCount = ActiveDocument.Range.FormFields.Count With ActiveDocument.FormFields(myCount) .Name = "text6row" & myRow .Enabled = True End With Selection.MoveRight Unit:=wdCell Selection.FormFields.Add Range:=Selection.Range, Type:=wdFieldFormTextInput myCount = ActiveDocument.Range.FormFields.Count With ActiveDocument.FormFields(myCount) .Name = "text7row" & myRow .Enabled = True ' .ExitMacro = "AddRow2" End With oTbl.Cell(oTbl.Rows.Count, oTbl.Columns.Count).Range.FormFields(1).ExitMacro = "AddRow2" oTbl.Cell(oTbl.Rows.Count, 1).Range.FormFields(1).Select ActiveDocument.Protect NoReset:=True, Type:=wdAllowOnlyFormFields End If End Sub Tag: Forms, check boxes linking to a list Tag: 94452
  - 18
    - Selecting text between 2 found words in Word Hi i want to select some text throughout a document to be deleted. The test will look like this...... 'Christmas : 2 x 5" Fruit & Cone Candle Rings Product: Christmas 2 x 5" Fruit & Cone Candle Rings Custom Label: 213878' I want to select the word 'Product' and everything up to (but NOT including) the word Label and then delete that selection. I want this to loop through the document until there are no more Products to be found Any help is appreciated Tag: Forms, check boxes linking to a list Tag: 94431
  - 19
    - Word 2003 - Fixing Styles in Templates Hi there, Can anyone provide any suggestions on how to fix styles in Word 2003 Template documents? I believe it is possible to code VBA to get the styles to revert back at close/open of the document, if the styles are changed by the user in anyway. Thanks, Nikki UNiTAB Qld Brisbane Tag: Forms, check boxes linking to a list Tag: 94423
  - 20
    - Bind a macro to a keystroke in Word 2007???? First off, I'd like to say that I hate Office 2007. :oP I hate the huge, fluffy GUI that they force you to use (since your only other option is to build an entire set of toolbars, one icon at a time, and just ignore the "ribbon"). I hate that the only features I can find are extremely obvious ones... which means that every average user is gonna think this is the best upgrade ever, and every advanced user is gonna end up pulling their hair out trying to find advanced features that they've been using for years... which brings me to my question. How do I bind a keystroke to a macro in Word 2007? Before, I would just go to Tools > Customize > Keyboard... and bind the keystroke... but now, of course, since there is no such thing as a "menu" any more, that option doesn't exist, and I can't find anything like it on the "ribbon". Anyone figure this out yet? WATYF Tag: Forms, check boxes linking to a list Tag: 94422
  - 21
    - Yes/No checkbox OR drop down I have a word document where there are lots of Yes/No drop down boxes. Is there a way I could make them default to either of the 2 choices on the click of a command button (or some other way) ? Thanks. Tag: Forms, check boxes linking to a list Tag: 94418
  - 22
    - No Class or High Class For the most part, Class modules are still a mystery to me. What little knowledge I have of them was imparted by Jezebel when I was working on a project to list, count and sort spelling errors. Earlier today and OP wanted to simply list all spelling errors contained in a document in a separate document. I thought of my earlier project and passed on the link. I then started thinking about a simpler code to do exactly what the OP requested "and" prevent duplicates. Here is the result of those thoughts: Sub NoClass() Dim DupChk As Object Dim oCol As Collection Dim oSpError As Word.Range Dim i As Long Set oCol = New Collection 'Add to collection For Each oSpError In ActiveDocument.Range.SpellingErrors On Error Resume Next Set DupChk = oCol(oSpError.Text) On Error GoTo 0 If DupChk Is Nothing Then oCol.Add oSpError End If Set DupChk = Nothing Next 'Publish results Documents.Add For i = 1 To oCol.Count ActiveDocument.Range.InsertAfter oCol(i) & vbCr Next i End Sub That seems straightforward and does the job. To do the same thing with a class, I first inserted a class module, named it clsError and pasted in this code: Private mName As String Public Property Get Name() As String Name = mName End Property Public Property Let Name(NewValue As String) mName = NewValue End Property In the project module, I used this code: Sub HighClass() Dim oError As clsError Dim oCol As Collection Dim oSpError As Word.Range Set oCol = New Collection 'Add to collection For Each oSpError In ActiveDocument.Range.SpellingErrors On Error Resume Next Set oError = oCol(oSpError.Text) On Error GoTo 0 If oError Is Nothing Then Set oError = New clsError oError.Name = oSpError.Text oCol.Add oError, oError.Name End If Set oError = Nothing Next 'Publish results Documents.Add With ActiveDocument.Range For Each oError In oCol .InsertAfter oError.Name & vbCr Next End With End Sub This works equally as well. What again is the benefit of using a Class? Is there any benefit in this example? Thanks. Tag: Forms, check boxes linking to a list Tag: 94410
  - 23
    - Copy all misspelled words Hi All, I have a large document (over 1000 pages) and want to copy all the misspelled words and paste them in new document (1 below the other) how can this be done? I am using Word 2003. Thanks in advance :) Tag: Forms, check boxes linking to a list Tag: 94402
  - 24
    - Document name in titlebar, step by step I want to put the path and document name in Word 2003 in the title bar, and found the following posting from a couple of years back. However, it is a bit too cryptic for me, since i don't use VBA at all. Can someone please take the info below and tell me step by step how i would do this? I would like to set up a macro to do this automatically, so if that could be explained, that would be great. Many thanks "Switch to VBA and in the immediate window type: windows(activedocument.Name).Caption = activedocument.FullName You could set up a macro to do this automatically, but I suggest you try it manually for a while. On most machines these days, the full path is so long that the result will be ugly." Tag: Forms, check boxes linking to a list Tag: 94394
  - 25
    - Where can I get help for VBScript? I have a word macro that I need to convert to VBScript. I've done simple ones in the past but this one is a little more complicated and I'm having difficulties. Does anyone know of a message board like this for VBScript? Thanks Rose G Tag: Forms, check boxes linking to a list Tag: 94390

Any help would be very much appreciated....

I would like to create a group of 3 check boxes say containing Editor,
reviewer and Approver. These check boxes should be mutually exclusive. If
the user selects the editor check box, a drop down list containing only
Editors for the user to choose and if the user checks the Reviewer, then the
list of reviewers names appear and so on.

In advance, than you for your help.

Top

RE: Forms, check boxes linking to a list by AlexM4096

AlexM4096
Sun Dec 10 19:00:00 CST 2006

Is this what you're after?

Create a form with three checkboxes named 'ApprChBox', 'EditChBox', and
'RevwChBox', and a combobox named 'TheListCombo' and put this code in the
form:

'-->In a form
Private Sub ApprChBox_Change()
Dim A$
'Save the last selected item
A$ = TheListCombo.Text

'Clear the list
TheListCombo.Clear

'Add Approved names if checked
If ApprChBox.Value = True Then
Call TheListCombo.AddItem("Appr1", TheListCombo.ListCount)
Call TheListCombo.AddItem("Appr2", TheListCombo.ListCount)
End If
'Add Edit names if checked
If EditChBox.Value = True Then
Call TheListCombo.AddItem("Edit1", TheListCombo.ListCount)
Call TheListCombo.AddItem("Edit2", TheListCombo.ListCount)
End If
'Add Reviewed names if checked
If RevwChBox.Value = True Then
Call TheListCombo.AddItem("Review1", TheListCombo.ListCount)
Call TheListCombo.AddItem("Review2", TheListCombo.ListCount)
End If

'If the last selected item is in new list then leave, if not then delete
For I = 0 To TheListCombo.ListCount - 1
If LCase(TheListCombo.List(I)) = LCase(A$) Then
TheListCombo.Text = A$
Exit For
End If
Next I
End Sub
Private Sub EditChBox_Change(): ApprChBox_Change
End Sub
Private Sub RevwChBox_Change(): ApprChBox_Change
End Sub
'-->End of Code

I hope this helps you any

"Vanna" wrote:

> Any help would be very much appreciated....
>
> I would like to create a group of 3 check boxes say containing Editor,
> reviewer and Approver. These check boxes should be mutually exclusive. If
> the user selects the editor check box, a drop down list containing only
> Editors for the user to choose and if the user checks the Reviewer, then the
> list of reviewers names appear and so on.
>
> In advance, than you for your help.

Top