Threads Replies Last Post 10 Pages: 1  2  3  4  5  6  7  8  9  10   need help testing small part of userform i have been learning Excel VBA, now am moving onto Word.... in my first attempt @ a userform, i am stuck a little on the structure as it's different from Excel... i've got the form set up & initialized, but trying this first small command isn't working. it runs fine until i try to set the focus, then it says that page isn't enabled (even tho i thought i told it to enable it if that specific ... 6 30.09.2006 09:07:37 Sending completed User Forms... I have designed a User Form. It is a Print Shop Requisition with various fields to order a printing job from the In-Plant Print Shop. My hope is to have departments fill out the form and click the Submit button at the bottom of the completed form and have it emailed back to me as an attached completed form. I have designed this type of form before, but it has been a long time. I am t... 15 30.09.2006 07:55:01 Finding name of subroutine or button (probably simple) I have a userform setup with a multipage control. I have various textboxes that need to be filled out for various information. I have also included a option button (copyhpm2) which will allow me to do a quick subroutine and then allow me to update the text of a box. My issue is that I would like to be able to find out which button has been pushed. (I know I could hardcode this with a var... 3 30.09.2006 05:20:01 VBA Word 2000 - make form stay on top of everything I've seen posts on this topic, but none of them satisfy what I'm trying to do. Does anyone know of a way to make a form stay on top of all applications or even on top of all open Word documents? I want a form that stays on top even if I minimize its parent Window (the document from which it was launched). I want it to stay on top even if I click on another Word document. Is it possible? ... 3 28.09.2006 17:18:28 Listbox: need help creating one Hi, As a technical writer, I dabble with macros and VBA. I created a userform with a textbox in which you can enter a bookmark name (if you know what it is) and a command button that selects that bookmark. How do I code a listbox to present a set of choices? I saw the following in the forum but there must be more code I'm missing. ListBox1.List = Array("Apples", "Oranges", "Pears",... 8 26.09.2006 13:52:02 Deleting Documents I have several versions of a document in MS Word that I'd like to delete and also delete the title from the documents registry that displays when you click on files - open. I've searched several of the help screens for a while this morning trying to find out how to do this and came up with nothing. It gets frustrating. Thought I'd see if I could get some help clues at this forum. ... 1 25.09.2006 17:16:27 Help with DAO and word Hello, I have a userform which fills list/combo boxes from access databases. I have gotten this far with questions to this group and looking at the links like mvps.org. I have a few questions / more things that I would like to do but can't find the answers. If you could help .... I use Word 2003, Access 2003, Win XP pro sp2 Here is a sample of the line that calls the sub to fill a b... 3 25.09.2006 16:28:31 Index Match in Word Table, or Embedded Excel? Hello there, Is it possible to use Index/Match in a Word Table, or otherwise return the formula result from an embedded Excel table to a word document bookmark/formfield? I have had a hard time figuring out how to take Word document bookmark values, get them into some form of embedded Excel workbook, have calculations run on them, then return the results to other bookmark fields in the ... 1 21.09.2006 15:00:19 Calculating in VBA with changing criteria - I have a table in Word 2000, 6 rows, 2 columns. - In the first column, rows 1-5 are for review criteria, and in the second column is a dropdown box in each cell with rating values from 0-4. - The user selects a rating from the dropdown box, then in the last cell of the table (row 5, col 2), a formula calculate the average. The problem is, not all of the fields are mandatory, so the numbe... 6 21.09.2006 14:46:07 Word VBA PrintToFile Is there any way to turn off PrintToFile without actually having to print anything? I've got an application that I enable the PrintToFile option to create a file for spooling to a network printer. I've been clearing the PrintToFile by setting it false and printing a zero page document back to the default printer. Unfortunately, while nothing prints, it results in a banner page printing, which... 2 21.09.2006 05:02:02 Page/MultiPage Control Hi, I have a multipage control on my userform that consists of 9 pages. I want to do an error check when the user changes pages to ensure that they have entered the data correctly. Sounds simple enough! I thought that the Change event would be appropriate to determine when they have changed the page but I'm having difficulty determining which page they were on in the first place. ... 2 20.09.2006 14:51:13 Word Userform Issue Hello all, I am working on a project where I get user information via a Word userform. This form then opens several other Word forms, one at a time and writes some data, saves and closes. Is there a way to speed up the process by not having every form open then write and then close? I am doing this with about a dozen forms right now. Thanks for the tip. -Lumpjaw -- Using... 4 20.09.2006 14:03:55 list box headings Hello, I have a userform with a listbox that is filled with data from an access database file, using the listbox.list method. It all works fine, but is there any way to fill in the column headings with the names of the fields, preferably not directly as the database field names are stupid. I tried putting the correct header names in the caption property in the database - no good. U... 3 19.09.2006 03:14:28 Hyperlinks Hi, would I be right in thinking that if you place a hyperlink on some text in a foot, it will not work? Thanks Alex ... 7 17.09.2006 21:06:28 Form Checking Hi if I have a user form with two check boxes on it and I only want the user to be able to check one or the other. How do I stop them checking both please Thanks A ... 4 17.09.2006 17:58:50 Exit Design Mode when opening a document (Word 2002) Hello, I am using textboxes in a Word document. Everything is working fine except that everytime I do open my document, I have to Exit Design Mode. Is there a way to be automatically NOT into Design Mode when opening an existing document ? Thank you ... 2 15.09.2006 03:49:45 Enumerating properties Is there a Properties collection for a Userform? I cannot seem to find one. I want to enumerate the properties for a Userform. Is there a Properties collection for a control on a Userform? I cannot seem to find one. I want to enumerate the properties for each control on a Userform ... 3 14.09.2006 22:57:42 Word VBA I am working on a Word document that has a built in userform. The userform prompts the user to input some data, the data is then written to various other Word documents. What I want to do is open an Excel and write the same data to a specific cell in the doument. Here is the scenario. Word Document "New Job" prompts user to input "JobName" Word Document "Project" receives the JobName inf... 2 13.09.2006 00:14:11 Doc template with customized doc Properties dialog box Hi, In my documents properties, i have configured some custom fields, with additional information, as document number, etc, etc, that i have to always fill in for each new document. Since it would be useful to share the template with my team, i would like to customize the properties dialog box, showing these custom fields in the same form with the standard docproperties. Could you help ... 2 07.09.2006 18:03:35 inserting text based on choices in userform LS, I am looking to incorporate something in a document automation template I am using. The document has several chapters (or rather paragraphs) that need to be in the document either in a chapter, or in an appendix. I want to create a userform that lists these paragraphs and the possibility to choose between "put in chapter 4" or "put in appendix". Hiding the chapters I think wi... 15 07.09.2006 13:12:45 opening userform in other template Hello, I have a number of templates that all use the same general user forms that I made with code in the forms and vba macro files. I want to keep the forms/macros with the normal template so that any of the other templates can access them. I want to keep them as one source so that I can fix/update the code all at once. I can access the VBA subroutines with a public declaration b... 4 04.09.2006 13:52:42 Fields update in userform Would appreciate some help on the below. I have a document that has several fields in it that I would like to fill using a userform. I have created the userform, and the document with fields. Now I need a way to update the fields in the document with the text in the userform. Basically I guess I need the code to put under the commandbutton that would do this action... Can someone help m... 9 04.09.2006 10:48:30 SaveAs Default Name I'm working on a UserForm for generating a letter to the referring physician in response to a consultation. I generally name my documents with the patient's last name and the date of the letter (e.g. Smith 2006-08-16.doc) The UserForm, of course, gathers this info. When I click Save or SaveAs I would like this to be the default filename. I have tried putting this into the Title proper... 6 04.09.2006 09:22:29 Inserting a graphic I have a UserForm which is used to place text into a document based on user input, and the code looks like this: Selection.GoTo What:=wdGoToBookmark, name:="Relationship" Selection.SelectCell Selection.Text = "Husband" What I want to do now is go to a Bookmark called Picture and have a picture (graphic) inserted at that point. I want the picture to display in front of any tex... 7 03.09.2006 05:42:51 Clearing/reinitializing docvariables? Before releasing my template to the user, I need to clear the docvariables and reset the arrays. Is there a simple way of doing such without copying the code to a new template? The userform has a couple combo boxes which I populate for the user to select from. Now I want to clear out all the testing data and start over. ... 5 02.09.2006 22:11:51 10 Pages: 1  2  3  4  5  6  7  8  9  10