Recent content by unica

Hi Sanjna, I think you might find it on the microsoft site. Go to search.microsoft.com and enter mscomct2.ocx as the search word. Or else try searching for it in Google, it must be out there somewhere ;-) Good luck! Regards, Unica

Hi Sanjna, In the Additional Controls Dialog Box the control is called "Microsoft Date and Time Picker Control 6.0 (SP4)". If it is not listed there you can try to find the following file on your system (default location is C:\Windows\System) MSCOMCT2.OCX. If the file is present you can add a...

Hi Howard, I had the same problem last week. I know what caused it: my labtop has that little square touchmouse at the bottom of the keyboard, everytime my hand was over it, the "internal" mouse reacted on that touch. I didn't solve it, just made sure I didn't touch it anymore ;-) But I guess...

Hi there, this should work for you: Sub ActOnInputbox() Dim sAnswer As String sAnswer = InputBox("Input text", "Title") If Trim(sAnswer) <> "" Then 'user filled out the inputbox and clicked OK Else 'user did not fill out the inputbox or clicked cancel End...

Hi kh707, maybe converting them to pdf-files is an option? Regards, Unica

Hi MrSR, maybe you can create a userform which pops up. After the user hits the [OK] on your form, the full text (the static and variable text) can be inserted in the document. If the first text is necessary for the user to fill out the variable text correctly, you can provide that on the...

Hi Rolex55, I guess you want to be able to quickly insert a full company address in you Word document? If yes, there are two ways you can deal with this: 1. Type the full address in you Word document, then select all the lines. Then go to Insert - AutoText - New. Enter a meaninfull name for...

So there must be some code in the FileSaveAs procedure of the template where the document is created from. Maybe you can add a check if the document to be 'FileSaveAs' is a new document and then call the FileSave procedure, or show the user the FileSaveAs window. The rest of the code that...

Eric, If you are using textboxes in the document itself then you must be talking about the formfields in Word. If you want users to only fill out the fields then you will have to protect your document when you're done making it. (standard toolbar - extra - protect document, choose formfields...

Hi David, Try this one: Private Sub ComboBox5_Change() Worksheets(&quot;Sheet1&quot;).Range(&quot;A1&quot;).Value = ComboBox5.Value End Sub Good luck. Regards, Unica

Hi Eric, On a VBA Userform you can set the tab-order by rightklicking on the userform. There you will find the option &quot;taborder&quot;. Or you can use the property TabIndex on the properties list. I do not really understand you last question... you want some fields disabled? Regards, Unica

Hi polymath5, Have you tried deleting/renaming the user's normal.dot? Sometimes this helps clearing up some unexplainable issues in Word. Good luck. Regards, Unica

Hi Ken, You could use the registry for keeping track of a sequential number. The values will be entered in: HKEY_CURRENT_USER\Software\VB and VBA Program Settings Code would look like this: Private Sub GetDocNumber() Dim sDocNumber As String Dim iDocNumber As Integer Dim sYear As String Dim...

Hi Ken, yes it can be done. But you must have some reference to the company name. So either it has to be in a bookmark in your document or you must be 100% sure it is always the first word in your document. If it's the first word in your document you can build your documentname as follows: Sub...

Hi TillTek, You can put additional code in the standard Word functionality. This will open the File Save As Window with the documentname &quot;YourDocumentName.doc&quot;: Sub FileSaveAs() With Dialogs(wdDialogFileSaveAs) .Name = &quot;YourDocumentName.doc&quot; .Show...