Threads Replies Last Post 23 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23   msgbox problem on a word user form I am trying to validate that an item was selected in a listbox when a user goes to the next listbox on a word user form. I can trap for the error and display a message box notifying the user that they did not select an value in the previous listbox. However, when I try to redirect the user to the previous listbox the msgbox wants to display twice before the vba logic refocuses the curs... 6 30.09.2006 23:47:13 check that user selected a value in a list box I am trying to validate if a user selected a value in a listbox. Does anyone know how to display a message if the listbox has no selected values? Thanks in advance. Jonathan... 3 30.09.2006 21:39:01 Check if a paragraph fits into a cell without "breaking" its height. How can I check if a paragraph fits into a cell without "breaking" its height using VBA? Thank you! ... 5 30.09.2006 21:16:45 Folder delete code New to this group so Hi to you all, Im after some help as Im new to VBA/code and its adictive. Im after help finishing the code below off, I would like to add a commandbutton to allow the selected files to be deleted from the target folder. Private Sub CommandButton1_Click() activeDir = "C:\my path" documents.Open (activeDir & "\" & ListBox1.Value) RAOPEN.hide End Sub ... 7 30.09.2006 16:03:32 How to keep date from wrapping between month and day I have written a macro to allow the user to enter dates in mmddyy format and then hit a hotkey to expand the dates into January 1, 2006 format. However, if the date is near the end of a line it can separate the month from the day because of word wrap. I know that if I am entering text from the keyboard, I can use control-shift-space to make a "sticky space," but I can't get this to work in VB... 4 30.09.2006 16:01:52 If Selection does not contain a Number or Colon I'm trying to determine if the current selection contains any characters that are not a digit or a colon Any help is greatly appreciated Thanks... 2 30.09.2006 04:38:25 Userform Creation for data entry/parsing My idea is to create a text form field that On Entry open a user form. this form has four text entry boxes. The first box is set to 5 places in the format AA111. Text box 2, and 3 allows up to three numbers places (1, 12, 123, 001, 012). box 4 allows up to 6 numbers. I then want the data to populate the text from field in the format Field1Field2-Field3-Field4 with an leading zeros remove... 2 29.09.2006 19:58:45 removing lines / paragraphs Hi I have a word document that is being used as a standard letter. The word document has bookmarks and is linked to access. The standard word document has the company name, address and contact details at the top of the page, however, when this is printed to headed paper I would like to remove the company details. so how would I write the code to delete the top 7 lines / 1st paragraph ... 2 29.09.2006 10:50:34 Create CSV File Hello All, I would like to take the following file (180 Pages) and turn it into a true CSV file. I am able to remove the uninteresting characters and insert commas before the port numbers. I then search the document for a comma and do a back space to get the the port number up on the same line as the IP address/host name. My Question is how do I make this macro continue through the ... 8 29.09.2006 06:20:24 Track changes prob Hi, Before a macro runs, I want to make sure that people turn off their track changes mode (and I would like them to do it manually). However, the script I am using seems to believe that track changes mode is being used when it is not. This happens when the user copies text from an email and pastes it into their doc (and they do not have track changes on, nor are there any track changes ... 1 28.09.2006 21:18:02 Selection Contains Space(s)? I'm trying to check to see if the current Selection contains one or more spaces. If I use Section = " " it only determines whether there is one space and won't determine if there are multiple spaces in the selection. I need to check if selection contains one or more spaces. Any help is greatly appreciated. Thanks in advance.... 6 28.09.2006 20:41:02 Editing emails in Word Hello! I'm disabled, and have had no PC training whatsoever. I've caught on to quite a bit; the harder it is, the better I'm able to master it. But I can't figure out how to do anything in Word! I get email jokes from friends every day, and am tired of printing out the ones I like with all the forwarding trails, and the stuff that follows. I waste 2-3 pieces of paper to get a joke th... 9 28.09.2006 10:31:01 locating data in text. I am new to this.. I need to list the directories and file names for over 1800 words in over 600 files. I hae the words to search for in a .TXT formated file. The files I need to search are Excel formated. I need the results placed in an output file. Can anyone help me with basic code to preform the search. I am running XP sp2 ..net = 2003 Thanks for your efforts.. ... 2 28.09.2006 07:37:52 Selecting All Text Between Two Strings I want to find all instances of text that begin with [B]-[/B Wrote: > , end with *QUOTE]*. This would include the beginning and ending > strings, and all text in between (including any tabs, line breaks, para > marks, etc.). Does this require a macro? If so, what would such a > macro look like? > > Thanks in advance. -- hziemba -----------------------------------------... 3 27.09.2006 14:44:22 Macro to save a file with the name of text from an ASK field I am trying to create a macro to save the current document with a variable filename, which will be in a ASK field. When the document opens, the macro I have now opens dialogue box to update all 5 of the ASK fields for the user to input data, then when a button is clicked it prints to a specified printer. What I need now is the ability to save the document in the name of the text that is in o... 2 27.09.2006 03:45:02 Get rid of user form in new document I have a Word .dot Template that collects header / footer info and puts it into a document using a UserForm. Then each GM fills out the report. They click a macro button at the end which changes the font, password protects and saves the document to a certain file. All is well, so far (thanks Jay Freedman!). Problem is, when the President opens each newly created .doc document to revi... 2 27.09.2006 00:13:55 Select last word of paragraph How can I select the last word of a certain paragraph? Thank you :) ... 3 26.09.2006 21:50:07 Getting the value of an unbookmarked checkbox I have hundreds of forms I've been tasked to extract data from into an Excel spreadsheet. The VBA script I developed performs the task well, but it depends entirely upon the Bookmark name to retrieve values that are Checkbox and Textbox. Turns out that four checkboxes on all these forms were somehow created without a Bookmark name, so VBA has nothing to grab onto, thereby skipping those field... 2 26.09.2006 13:59:08 just starting If you can point me to a faq or topic, thank you. If not, bear with me. I have not used VBA before. I have a Word document using placeholders/variables. It is used by another application that fills in user data based on the variables. I would like to personalize the form a bit more by replacing text such as he/she. I thought perhaps an if/then statement would work but I haven't a c... 6 24.09.2006 13:59:38 Extending My Selection I need to extend the current Selection to the right until it reaches a character that is NOT equal to either a digit (any number) or the colon ":" (kind of an odd request, I know). Any help would be greatly appreciated. Thanks, ... 3 23.09.2006 05:00:01 Looping problem Hi, I created this from some of the comments posted here. Why does the "For Each...Next" loop through the whole document and not just the selection? Sub NumSR() Dim rSlc As Range ' selection range Dim rTmp As Range ' temporary range Dim oPrg As Paragraph Set rSlc = Selection.Range For Each oPrg In rSlc.Paragraphs Set rTmp = oPrg.Range With rTmp.Find .Text = "([^32^t^s]{... 2 22.09.2006 20:19:42 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 ... 4 21.09.2006 19:38:01 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 Automatic number changing I am responsible for recording and distributing minutes of a weekly meeting. The information is typed into a table, which has 2 columns. Column 1 has the identification number (ID) of the item under discussion, details of which appear in column 2. The number of rows in the table varies from week to week, but can have as many as 30 rows. Some items carry over from meeting to meeting, so t... 3 19.09.2006 21:23:02 Putting a return within text I really need some help with this one, I have tried a few options but not managed to get any to work. I need to insert a carriage return into some text automatically entered by a form I have created so that instead of being on one line it is seperated into paragraphs. Here is the code I need to alter: If OptionButton1.Value = True Then pleasenote = "you need to have had your home loa... 2 19.09.2006 11:26:06 23 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23