Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 05-09-2014, 09:08 AM
macropod's Avatar
macropod macropod is offline Is it possible to take an input from a UserForm in one document to a UserForm in a do Windows 7 32bit Is it possible to take an input from a UserForm in one document to a UserForm in a do Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

To do what you want would probably require you to:
1. create a document variable or custom document property in the template
2. when you create a new document from the template, update the new document's copy of the document variable or custom document property
3. have the code in your userform read the document variable or custom document property in the activedocument and check the appropriate button programmatically.
I'm not sure whether the AutoNew macro you now have would fire before the document variable or custom document property is updated. If it does, you wouldn't be able to use the AutoNew macro; instead you'd need to update the document variable or custom document property then call another macro to load the userform via Application.Run. For example, in your 'Cleaned VBA Document' document:
Code:
'Code to populate the document variable or custom document property, then
Application.Run ActiveDocument.AttachedTemplate.FullName & "!Module1.LoadUserForm"
where 'LoadUserForm' is the macro name in the 'process document' template.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible to take an input from a UserForm in one document to a UserForm in a do Checkbox in Userform lukael Excel Programming 5 02-18-2014 05:20 AM
Userform Code not quite right - help please vbanovice Word VBA 1 09-29-2013 09:20 PM
Is it possible to take an input from a UserForm in one document to a UserForm in a do Show userform without losing document focus? Or other method to get a graphic to pop? AlexR Word VBA 7 03-31-2013 12:17 PM
Is it possible to take an input from a UserForm in one document to a UserForm in a do How to link userform to another word document SaneMan Word VBA 5 10-14-2011 05:12 AM
Is it possible to take an input from a UserForm in one document to a UserForm in a do Setting focus to specific word document from UserForm SaneMan Word VBA 5 04-01-2011 03:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:50 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft