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
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...
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...
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 !"...
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...
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...
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...
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 /...
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
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
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
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"...
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-(
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 ?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.