data not available for activedocument from userform 
Author Message
 data not available for activedocument from userform

Hi Nigel,

I'm a bit startled here

This works fine
Private Sub Calendar1_Click()
    Selection.Range.Text = Format(Calendar1.Value, "dd-mm-yyyy")
End Sub

or is this too simple ...? , if so show us the code

Krgrds,
Perry



A question from a Word VBA newcomer..

Having a problem getting a user form to see a background document....

The code works fine when the template file is open ( as in not just double
clicked on it to create a new document from the template ), however, when I
do want to use the template properly, nothing happens.

The userform has a calendar control on it and I use the "click" method of
this control to generate a date which I want to put in the main document. It
just does not want to recognise the "activedocument" method.  I can
"debug.print" the "activedocument.name" and even set a variable to the
"activedocument.name", but when I try to use it, no chance.

Any help would be greatly appreciated as this is driving me nuts

Nige......



Thu, 24 Jul 2003 17:56:07 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Userform Properties not available in MSForms.Userform

2. Deleted UserForm name not available

3. VBA UserForm appears not to fetch XL data, and to HOLD old data

4. Contact data not available in the address book

5. UserForm or not to UserForm?

6. Feild in data souce not available

7. UserForm or not to UserForm?

8. mail merge has the open data source not available

9. ODBC - numeric data not available

10. Table View not available after returning data to Excel then going back to Query


 
Powered by phpBB® Forum Software © phpBB Group