Search results for query: *

This question relates to WORD VBA only: I know I can use this: Me.Textbox1.Value = 2345 or Me.Textbox1.text = "Hello" and x = Me.Textbox1.Value (or text) But in this case if have multiple frames and tabs I have a form -- frmMain frmMain has mpgWizard -- a multipage control...

I can't get the cursor back into the textbox (or list, or combo) in Word 2000. This does work in Word 97, though. Can anyone help? Private Sub Textbox1_Exit (ByVal Cancel as MSForms.ReturnBoolean) If Not IsNumeric(TextBox1.Text) Then MsgBox "Please enter a numeric value&quot...

I am creating a project with many, many panels using multipage. I have lots and lots of controls -- text, combo, etc. I have written the following code to change the background color on entry and exit. I have also written the following code to format the text boxes for date and amount...

Can anyone supply the values in the registry for the templates directory for Users, Workgroups, and documents when Word 2000 is installed on an NT system? Could you also provide Word 97 values on an NT? Thanks, Dan i.e., System.PrivateProfileString("&quot...

I would like to add Calc.exe to my VBA Word project. That is, the user can click a button on my form, and calculator will appear. Can I capture or control any buttons, menus, or textboxes in Calc using VBA? The user will make a calculation, which then must appear in the form textbox (for...

I have textboxes on a form, some of which are coded to change the background color in the Enter and Exit event. The last textbox on the form, however, does not change the background color on Exit (tabbing out of textbox to next control, which is a command button). I have tried many different...

I have created the following to reuse my code for textboxes by creating a class to handle the enter and exit events. I can get the change event and several others after running this code, but what happened to the enter and exit? I really do need the enter and exit events. This code is placed...

I have written the following code in a form and in a class module (actually I got help from the internet). It works fine in VBA 6.0 (Word 2000), but will not work in VBA 5.0 (Word 97) -- it actually was written for VB. I am writing an automation document with Word and need my new programming...

I have the following code in my VBA module which works fine on a comma delimited text file. However, my text file is tab delimited. I have looked everywhere for a comparable statement to "Microsoft Text Driver ..." for tabs. Can someone put me onto the correct coding? On Error GoTo...

Can someone tell me what the exact default directories are for Word 2000 (assuming new install of Word 2000 on a new machine from Office 2000 Premium). I have to write an install routine for my program, and need this information as a starting point, so precision is crucial. I have found...

I have a form with an interest rate (Loan_Rate) textbox, masked 0#.###. The user enters the interest rate, and it must be converted to words. The words are placed into another textbox so the user can see the text (Loan_RateSO1 and PctTable array), and supposedly would be saved to the table (must...

I have a text box controlled by a checkbox which, on exit, cannot be empty. I prefill the text box with the format (999,999-99-99) [txtSelectLoanNumber]. On exit the code checks for content and length, and displays a message box if not correct. Otherwise it reformats the text input by the...

First, this problem is in WORD VBA -- I have a combobox which is driven by the value in a textbox.<br><br>Based on the value in a textbox, the original combobox list should be replaced with new list items.&nbsp;&nbsp;Instead, the new items are being added to the existing list.<br><br>I believe...

I have some very complicated templates.<br><br>Our users complain when they use File ¦ New and select the template.<br><br>There is a long wait for the highlight to move to the selected template while Word tries to find its &quot;Preview&quot; example, which my templates don't...

Brain dead?&nbsp;&nbsp;Senior Moment?<br><br>I have searched and read all variations of the methods suggested in this forum (which is the best I've found 'cause you guys are so smart) to prevent saving a record until a command button (Save) is clicked.<br><br>I have tried Cancel, Cycle Current...

I have created a report layout to display the number of times an answer (A, B, C, or D) are given to a particular question in a set of questions 1 to 20, multiple records.<br> <br> Sample desired layout:<br> .........A....B....C....D<br> Q1.......16...2....1....3<br>...