Userform, duplicating data??

J

Jones

(I tried posting this just now, but it didn't go through on my end.
Hopefully a duplicate message doesn't go through.)

In WP, having a template dump the user input data into more that one
spot is easy, we just duplicate the code. I haven't been able to find
the equivalent functionality yet in Word. I'm on this page here:
http://www.fontstuff.com/vba/vbatut09a.htm.

I often need user input data to be used by the template in at least 2
spots and every once in a while in more than that, thought that's not
often. (i.e., user inputs data once, but it'll get copied to 2
labels, for example - back and front of an index tab / file folder
labels, front and tab / letter and envelope, etc., etc.). The text
attributes change in these cases but one sets that up in the template.
The data to enter is all the user needs to worry about.

Is there a way to do this in Word?

Thanks.
 
J

Jezebel

It's easy in Word too.

Method 1: put the data in one bookmarked location in the document and use
REF fields elsewhere.
Method 2: add the data as custom or built-in document properties and use
DocProperty fields.
Method 3: add the data as document variables and use DocVariable fields.

If you're working from VBA, method 2 is my preference.
 
S

StargateFan

It's easy in Word too.

Method 1: put the data in one bookmarked location in the document and use
REF fields elsewhere.
Method 2: add the data as custom or built-in document properties and use
DocProperty fields.
Method 3: add the data as document variables and use DocVariable fields.
Click to expand...

Oh boy. Okay. I'll hunt down on how to do this but probably won't
get to this till the weekend now. Sorry to say this but this isn't as
easy at all. But I'll get there eventually.

Thanks for the help. I appreciate it!

***************************
The neat thing about WP's way is that one can use just stick with the
userform that is generated automatically. Often much more than
adequate for what one needs. One doesn't have to built a userform
from scratch. You _can_; I've dabbled in that myself when I've needed
something with more buttons, etc., but it's so easy to use. I was
hoping there was something like that in Word. If there isn't is there
at least a generic userform downloadable somewhere that is easy to
modify? I don't have the kind of time this will take to build
otherwise. It'd be nice to find a template with a userform that can
be modified _quickly_ when I'm at work and one that has maybe 10
entries or so. I figure that in most cases it would be a question of
just editing the box labels and deleting any that aren't needed on the
form and then shrinking the form down to size. Logically, I wouldn't
have to worry about any vestigial coding as there would be no way for
user to access it via the form so they'd become a moot point. Anyway,
hopefully that's the last question re this issue as the above will
take a bit of time to figure out and it's already 12:07 a.m.! <g>

Thanks so much.
 
Top