Threads Replies Last Post 10 Pages: 1  2  3  4  5  6  7  8  9  10   How to make a text field numeric I wanted to calculate a text field based on the falues of 3 other text fileds. The problem arose that when I did this: FieldA.Value=800.00 FieldB.Value=200.00 FieldA.Value=.00 FieldD.Value = FormatNumber(FieldA.Value + FieldB.Value + FieldB.Value, 2) I got a text value of 800.00200.00.00 How do I define a numeric field in a userform instead of using a text field? ... 3 18.07.2006 13:59:48 The Currently Active UserForm? Hi, I wonder if there's a way to get the currently active modal/nonmodal UserForm in Word VBA? Something like Application.ActiveUserForm? Yet I haven't found one... I need this to provide context for a command called from a custom command bar, which I pop up as a "shortcut menu" in my UserForm window. When the command bar is displayed, you know, it doesn't "know" if it's in the user for... 1 17.07.2006 14:04:47 non modal userform Hi! Can I have a non modal userform but still halt the code to wait for the user to click one of my buttons on the userform? I am trying to do a step by step instruction with a userform In one of the steps I want to ask the user to mark a table and then click ok. My problem is that to be able to mark something in the document I need to set the userform to nonmodal but if I do that the ... 3 17.07.2006 13:25:52 option button to show text Hi, I am trying to create two option buttons on a user form in word VBA that when one selected a certain text will appear in the document and a different text will appear when the second option button is selected. The text itself is long with screen shots. Any suggestions? Thanks, ... 3 11.07.2006 15:20:18 Dtpicker commands Hi All I am trying to link 2 dtpickers so that the From date (dtpicker1) can never be bigger than the To date (dtpicker2), which is defaulted to Now on Worksheet_activate. SO i am wondering if there is a on change command for the dtpicker so that when a change is made if dtpicker1.value<dtpicker2.value then msgbox....... set dtpicker1.value = dtpicker2.value. Regards Stopher ... 3 07.07.2006 11:10:27 Create Command Button Scripts for Forms I have created some forms in MS Word, and was wondering if command buttons can be created that would allow the user to save the form, print the document and send an email. I understand that there are buttons on the tool bars, but a request has been for it to be embedded in the form. Thanks! KCCARR ... 3 06.07.2006 16:15:56 New Userform Gallery Hi all, Thought you might be interested in a new site I have just launched, devoted to showcasing the best in Userform design. Check it out here: http://www.userformgallery.com Cheers, Scott. ... 2 05.07.2006 13:44:20 Problem cross-referencing bookmarks in a VBA User Form I have created a document that has some repeating information in it. Instead of having to type the text (for example: client name, product) several times throughout the document, I decided to create a Word Template with a VBA User Form and cross-references to populate this repeating information for me. I used the instructions found here: http://www.dragondrop.com/WordCoding/word011... 6 29.06.2006 19:27:19 USERFORM Buenas grupo, me ha surgido un problema y se uds me pueden ayudar como lo han hecho infinidad de veces.... Tengo un userform llamado Buscar en donde coloque 11 textbox, con sus respectivas etiquetas, cada textbox es una informacion diferente, (fecha, codigo, número, etc) y estan relacionados a una tabla en una hoja llamada Obras, que tiene estos campos ordenados en columnas(fecha, codigo, ... 1 27.06.2006 05:37:40 Application.FileDialog(msoFileDialogOpen).Show doesn't show files Hello I've written the following code, in a UserForm: Dim fileName As Variant Dim files As FileDialogSelectedItems Application.FileDialog(msoFileDialogOpen).Show ListBox1.Clear Set files = Application.FileDialog(msoFileDialogOpen).SelectedItems If files.Count = 0 Then Me.FileText.Text = "No se seleccionaron archivos" Else For Each fileName ... 3 25.06.2006 12:46:45 OutPersonals OutPersonals http://outpersonals.com/go/g671669 ... 1 24.06.2006 19:04:26 OutPersonals OutPersonals http://outpersonals.com/go/g671669 ... 1 24.06.2006 19:02:58 FAQ - Frequently Aske Questions - vba - please read before posting - unofficial June posting FAQ = Frequently Asked Questions - brief - vba - unofficial This FAQ is posted every ten days or so. Please save us all some time by reading it before posting to the news group. This newsgroup is about VBA - Visual Basic for Applications - which is the programming language for Word 97-2003 (macros). There is a longer FAQ with more questions and links that is regularly posted in the non-... 2 23.06.2006 18:35:05 Passing FormField bookmark as a parameter to a UserForm I have a Text FormField with an entry macro that loads an UserForm. I need to pass the FormField name property "bookmark" as a parameter to be used by the UserForm. This UserForm will be called by numurous Text FormField in the document and in no specific order so I need to pass the name specific to each FormField. I can't figure out how to acssess this property. Any help appreciated ... 4 21.06.2006 12:42:56 Passing FormField bookmark as a parameter to a UserForm I have a Text FormField with an entry macro that loads an UserForm. I need to pass the FormField name property "bookmark" as a parameter to be used by the UserForm. This UserForm will be called by numurous Text FormField in the document and in no specific order so I need to pass the name specific to each FormField. I can't figure out how to acssess this property. Any help appreciated ... 1 21.06.2006 00:15:00 How to create a form in Word documents to contain checkboxes etc I am using office 2000. I have got some questions about Word VBA. 1. How can I create a form in Word documents for holding textboxes, checkboxes etc.? Which ActiveX control should be used? 2. What VBA codes should be added so as to launch the form automatically whenever the document is opened? Please advise. ... 9 20.06.2006 12:47:01 User's Name in Page Howdy, Is it possible with a macro to pull the user's display name from Active Directory and put it into the page? Thanks, David ... 2 18.06.2006 04:37:03 How to create an auto reference for a template. Hello, I have a questions, although I looked at most links didn't seem to find a hint. I have a template with a bookmark ("DocNo"). I am trying to achive autonumbering for this template whenever a new document is created, this DocNo is automatically inserted into the bookmark. An example format for the docNo would be like "yymmddnr" (nr. being the first number and it should keep incr... 3 15.06.2006 21:00:43 Getting Path and Filename info from FileOpen dialog box Hi all. Word 2003 I have a userform that has a browse button on it. I want the user to be able to browse to a folder and file of their choosing, then grab the path and file name of the chosen file, insert it into the userform and then copy that file to another folder, all without opening the file they have chosen. Is this possible? Thanks Scott Scott Schaffer ITSA Olive Wal... 2 15.06.2006 02:58:31 Textbox text formatting Here's a rather bizarre request.... One of my clients has asked me to create a template which will have a number of graphics, etc. In this template there will be an area for text. However, they don't want anybody to be able to directly modify the document in any way. So I thought of protecting the document for userforms. Then having a great big textbox in the userform for people to wri... 3 13.06.2006 22:26:16 Searching word tables (column) for a specific word(s) and update bookmark Hello, I am using word 2000 on Win.XP I designed a word template with bookmarks and a word table with 5 cols(Prod.No, Descr, price, qty, colr, etc) . Then I created a userform (frmMyprodts) with a list box to enable user select the products. This listbox is populated from a products table in access - with three cols. getting data from the table. When the user selects a product from the lis... 7 13.06.2006 20:39:49 resize control in userform Hello, I have a picture (or any othe control) on a UserForm that i want to enable the user to resize it in any direction by clicking on it and dragging in the required direction Is there a way to do it? Thanks a lot ... 2 12.06.2006 20:55:19 UserForm checking I have a UserForm that I want to test has been fully completed. Is there anywhere within the system that contains an array of all the textboxes, or do I need to create my own. Thanks, Steve... 4 09.06.2006 19:35:02 Extracting Picture files to insert in forms Hello, I have a form that will need images extracted from documents to be inserted into the form each runtime, changing as different documents are opened. Unfortunately, the images are part of the document, and I can not find a way to refer to an image within a document when trying to insert a picture into the form. Looking at other similar entries in this newsgroup, I saved th... 2 06.06.2006 18:42:59 Macro in Document Library Template Doesn't Load Howdy, I have a WSS site and a document library using a Word doc template. The document has form fields and it is locked to limit editing. I have a macro on one field that after the user leaves the field, it will save the document based on that field. This macro works great in two scenarios: 1) if the doc is saved locally to my workstation and 2) when I open the document from WSS thro... 3 06.06.2006 15:40:22 10 Pages: 1  2  3  4  5  6  7  8  9  10