Re: Accessing a TextBox
- From: Jim <Jim@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 13 Apr 2005 11:57:06 -0700
I am trying to do something similar to what I see in Jay's answer, but not
quite the same. I am trying to paste a number I have stored as a variable
into a cell of a table which is embedded in a footer. Any ideas on how to do
this would be appreciated.
"Jay Freedman" wrote:
> Stefan_B wrote:
> > Hello,
> >
> > I have a textbox which sits in the header of a document, is their
> > anyway I can access the textbox, so that I may search the Header for
> > particulars pieces of text?
> >
> > Thanks,
> > Stefan.
>
> Hi Stefan,
>
> The following code assumes that "the header" means the primary header of
> section 1 (there could be first-page and/or even-page headers, or you could
> want a different section), that the header actually contains at least one
> shape object (a text box is a shape object), and that the first shape is the
> textbox you want to search. If any one of these assumptions isn't true, the
> On Error trap will be triggered and the macro will simply exit. In a real
> macro, you should test each assumption in turn and handle any problems
> appropriately.
>
> It also assumes you're just searching for the first occurrence of the text
> "find me" -- of course, that can be changed, and the search can be altered
> to become a replacement. All the interesting stuff is in the Set oRg
> statement.
>
> Sub foo()
> Dim oRg As Range
>
> On Error GoTo Bye
>
> Set oRg = ActiveDocument.Sections(1) _
> .Headers(wdHeaderFooterPrimary).Shapes(1) _
> .TextFrame.TextRange
>
> With oRg.Find
> .ClearFormatting
> .Format = False
> .Forward = True
> .Wrap = wdFindStop
> .Text = "find me"
> If .Execute Then
> oRg.Select
> End If
> End With
>
> Bye:
> End Sub
>
> --
> Regards,
> Jay Freedman
> Microsoft Word MVP FAQ: http://word.mvps.org
>
>
>
.
- Follow-Ups:
- Re: Accessing a TextBox
- From: Jay Freedman
- Re: Accessing a TextBox
- Prev by Date: Re: Setting variables
- Next by Date: Re: macro security question
- Previous by thread: macro security question
- Next by thread: Re: Accessing a TextBox
- Index(es):
Relevant Pages
|