Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. congelator

    Loop in WORD with same cells in differents sheets

    Hi PH, No, I didn't tried because I'm a beginner in VBA and I don't know Mailmerge, datasource and Datafields. I found the Bookmarks which worked just as I wanted and needed till now...! If you have any suggestion... welcome Thanks Ced Lausanne / Switzerland
  2. congelator

    Loop in WORD with same cells in differents sheets

    Hi everybody, I need you help : I made a userform with 5 fields (name - firstname - city...). When we click on "OK", the informations are moved in cells in WORD, at the right bookmarks (name with NAME bookmark, firstname with FIRSTNAME bookmark,...). Everything is going well with...
  3. congelator

    checking date format

    Thank's AndyWatt, I paste and adapted your code and... and... It works..!!! Now my code is (if that could be helpfull to someone else...) Private Sub tbox_date_aud_Exit(ByVal Cancel As MSForms.ReturnBoolean) Dim Date_correcte As String ' Vérification si la date existante est déjà correcte...
  4. congelator

    checking date format

    Hi ca8msm thanks's for your quick response. You had a great idea with changing date automatically, I didn't thought about it. Here is the actual code I wrote : If Not IsDate(tbox_date_aud) Then MsgBox "VOUS AVEZ ENTRE UN MAUVAIS FORMAT DE DATE", 48, "ATTENTION !&quot...
  5. congelator

    checking date format

    Hi everybody, I have a field in wich users will have to write a date. I would like to check if they use a correct format (dd.mm.yyyy). If it's not the right format, show a msgbox and come back to the active field and have the wrong date highlited. If anyone hase a suggestion... thanks in...
  6. congelator

    Word 97 - Automatic correction

    Hi everybody, mbarron is right. One of my colleague have a list of more then 200 words which are used in his autocorrect. As he works on differents computers he always has to type them one by one. So I'm seaching a solution to add these words in the autocorrect list on each computer without...
  7. congelator

    Word 97 - Automatic correction

    Hi everybody ! First, sorry but my menus are in French... and I'll do my best to translate them ! I have a file with more than 200 words to enter in the "automatic correction" (Tools and 5th possibility) for ex : when I type "hi" that's automatically replaced by "Hello...
  8. congelator

    How do I sort a range of IP addresses typed in Excel?

    Hi, As Carol said, you didn't explained exactly what's wrong but if your cell's format is "Standard" and you type like this : 001.002.003.1 123.002.145.005 245.2.3.1 255.001.002.123 You normally should be able to sort the collumn without any problem. Good luck ;-) Ced Lausanne /...
  9. congelator

    Cannot Insert bullets in Word 97

    I already had a similar problem with a user because he "customised" the bullets... with a white police. Format / Bullet and Numbering / Bullet / Customise / Police / Color PS : "path names" can be wrong because I'm working on a French version Ced Lausanne / Switzerland
  10. congelator

    turning picture in Powerpoint 97

    That confirms what I thought and what I told to the user but he assured me he did it directly... Thanks for your confirmation :-) Ced Lausanne / Switzerland
  11. congelator

    turning picture in Powerpoint 97

    Hi everybody, I've inserted a picture in Powerpoint 97. I need to turn it 90 degrees left but the small icon in the bottom of the screen is not active. Any idea is welcomed Thanks Ced Lausanne / Switzerland
  12. congelator

    check a Date in Word

    Your're right Rob but I could write any date format in that field that's why I used such a code :-( to check date field and date format... Ced
  13. congelator

    check a Date in Word

    Hi Clive, Thanks for your help. I finally find a way to check the date's field with differents others checks. Here is the code if that could be usefull... Sorry for the French comments but I do speak French... In "ThisDocument&quot...
  14. congelator

    check a Date in Word

    Thanks Clive, I tried but it doesn't work as I try to do. In fact, I have a date field. If someone write a date, the program goes on. If it's not a date, I want to show a msgbox saying something If you can help me, that would be great because I can't find it even in books I have... B-(
  15. congelator

    check a Date in Word

    I need your help before i become crazy !! How can I do to check, in Microsoft Word, if the text entered in the vba date field is really a date and not just text ?

Part and Inventory Search

Back
Top