Hi @all!

I am new to Visual Basic, having just created some Makros (SUBs in
English?) and facing a few problems. Please be patient with me... I am
not only a newbee but also German and didn't find a German
newsgroup... I might have some problem with understanding English tech
bubble ;-)

I have a sheet with 12 address stickers and would like to have two
formatted text areas on any sticker where I actually need them. The
selected address on the sticker gets copied, formatted and appears in
the text areas just as I want them to.
But the text areas themselves always appear on the *first* sticker. I
want them to be put into the same sticker the address was copied from.

How can I get the right sticker selected?
These are the first two lines:
    Selection.Copy
    ActiveDocument.Shapes.AddTextbox(msoTextOrientationHorizontal,
36.3, _
        35.5, 205.2, 84.5).Select
I'd bet there's some order/tag (sp?) at first or in between to choose
the same sticker as the marked text is in for inserting the text
areas.

Thank you in advance for your help!

MarionS

microsoft.public.de.german.entwickler.dotnet.vb

is the German VB.Net newsgroup. But I guess, reading your question,
this (English) group is not the right one, too, because it's also
a VB.Net group - same in English. :-)

VB.Net is a language (like C# and others) based on the .Net Framework.
You're probably looking for a VBA (visual basic for applications) group.
Depending on the product you are using, it's microsoft.public.de.word.vba or
microsoft.public.de.excel or...


Armin

I'll have a look - thank you! :-)

MarionS

How to invoke IE ...
2003 v. 2005 studio - need some help, please.
Raising CustomControl Events from within Class
Moving a project to a different location
How to connect to MS Access....
X & Y within DataGridView
Binary Formatter not suitable accross firewalls
Help get record count and moving forward and backwards!
Tabbed Document Interface
ComboBox