Newbie...

  • Thread starter Thread starter Marion Scheffels
  • Start date Start date
M

Marion Scheffels

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
--
(e-mail address removed)

"Didn't they say the pen was mightier than the sword?" - James Bond
"Thanks to me they were right!" - Q
(GoldenEye)
 
Marion Scheffels said:
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 ;-)
Click to expand...

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
 
Armin Zingler said:
Depending on the product you are using, it's microsoft.public.de.word.vba or
microsoft.public.de.excel or...
Click to expand...

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

MarionS
--
(e-mail address removed)

"Didn't they say the pen was mightier than the sword?" - James Bond
"Thanks to me they were right!" - Q
(GoldenEye)
 
Back
Top