Dymically add text box to form in Word Macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JUICE - 07 May 2006 20:00 GMT

Hi,
I was wondering if anyone could help. I am getting an "object required"
error on the following line of code:

Set ctlText = Controls.Add("VB.TextBox", "ctlText1")

I am initialising like so in the class module:

Dim WithEvents ctlText As VB.TextBox

Reply to this Message

Jezebel - 07 May 2006 23:49 GMT

The keyword 'Controls' is defined in both the Office and Forms libraries;
and the Office library normally takes precedence in the references list. So
the 'object required' -- in this case -- is the commandbar that owns the
controls collection.

Try: Me.Controls.Add(...)

> Hi,
> I was wondering if anyone could help. I am getting an "object required"
[quoted text clipped - 5 lines]
>
> Dim WithEvents ctlText As VB.TextBox

Reply to this Message

JUICE - 08 May 2006 22:12 GMT

Hi,
Thanks for your reply. I have tried
Set ctlText = Me.Controls.Add("VB.TextBox", "ctlText1")

and it has generated the error "invalid use of me keyword"

Reply to this Message

Jezebel - 08 May 2006 23:26 GMT

Is the line of code within a form? If not, instead of Me, you want a
reference to the form.

> Hi,
> Thanks for your reply. I have tried
> Set ctlText = Me.Controls.Add("VB.TextBox", "ctlText1")
>
> and it has generated the error "invalid use of me keyword"

Reply to this Message

Steve Macleod - 10 May 2006 20:59 GMT

ok, thanks for this.
I have attempted to use the form name:
genScriptfrm.Controls.Add("VB.TextBox", "ctlText1")
although this generates an "invalid class string" error.
The code is within a private sub. I am unsure if I must pass a
reference to the form in through the main sub that starts when the
macro is run.

Can anyone advise?

Many, thanks.

Reply to this Message