Hi there!
I've inserted several ActiveX Control text boxes into an excel form. A
couple of them are too small and I need to make them bigger but I can't grab
anything to drag them.
Help!?
Not an expert so please keep it somewhat simple.
Thanks,
Mary
--
MT

Mary

Click on View, Toolbars, Control Toolbox and click on the Top left icon. It
should change in and out of design mode. Once in design mode you should be
able to change the size of your active x controls. Then you need to click
the icon again to get out of design mode.

Hope this helps.

Dave

"Mary Thomas" wrote in message
...
Hi there!
I've inserted several ActiveX Control text boxes into an excel form. A
couple of them are too small and I need to make them bigger but I can't
grab
anything to drag them.
Help!?
Not an expert so please keep it somewhat simple.
Thanks,
Mary
--
MT

Worked great Dave, Thanks:-)
--
MT


"Dave" wrote:

Mary

Click on View, Toolbars, Control Toolbox and click on the Top left icon. It
should change in and out of design mode. Once in design mode you should be
able to change the size of your active x controls. Then you need to click
the icon again to get out of design mode.

Hope this helps.

Dave

"Mary Thomas" wrote in message
...
Hi there!
I've inserted several ActiveX Control text boxes into an excel form. A
couple of them are too small and I need to make them bigger but I can't
grab
anything to drag them.
Help!?
Not an expert so please keep it somewhat simple.
Thanks,
Mary
--
MT

Mary

Glad to help.

Dave

"Mary Thomas" wrote in message
...
Worked great Dave, Thanks:-)
--
MT


"Dave" wrote:

Mary

Click on View, Toolbars, Control Toolbox and click on the Top left icon.
It
should change in and out of design mode. Once in design mode you should
be
able to change the size of your active x controls. Then you need to
click
the icon again to get out of design mode.

Hope this helps.

Dave

"Mary Thomas" wrote in message
...
Hi there!
I've inserted several ActiveX Control text boxes into an excel form. A
couple of them are too small and I need to make them bigger but I can't
grab
anything to drag them.
Help!?
Not an expert so please keep it somewhat simple.
Thanks,
Mary
--
MT

Dave,

I'm trying to add an ActiveX control Text Box to a sheet form in Excel 2007.
I can add the ActiveX Text Box control from the Developer menu "Insert" set
of ActiveX choices, and then I can go into properties and set the "Linked"
property to a particular cell in the spreadsheet. This works dandy, as when
I type anything in the "Data," "Text" property within the properties setup, I
see the text populating into the Linked Cell I designated. What has me
totally stumped is that once I close the properties box and go back to the
sheet form, I cannot--as a user--type anything into the text box. Every time
I click on it, the ActiveX box simply behaves as though it is an object. The
point of my putting the text box there is so that users of the form can enter
text for "Other" conditions which canot be captured by other questions on the
form.

How do I get this ActiveX control Text Box to allow Input by the user typing
directly into it? For now, the ActiveX text box seems to be behaving as a
text box formatted for "display only," such as the "Home Phone" text box
label that might be situated next to another text box into which the user CAN
type their home phone number. I need to be able to format this ActiveX text
box so that the user CAN type into it.

Help!

Thanks,

Karen

"Dave" wrote:

Mary

Glad to help.

Dave

"Mary Thomas" wrote in message
...
Worked great Dave, Thanks:-)
--
MT


"Dave" wrote:

Mary

Click on View, Toolbars, Control Toolbox and click on the Top left icon.
It
should change in and out of design mode. Once in design mode you should
be
able to change the size of your active x controls. Then you need to
click
the icon again to get out of design mode.

Hope this helps.

Dave

"Mary Thomas" wrote in message
...
Hi there!
I've inserted several ActiveX Control text boxes into an excel form. A
couple of them are too small and I need to make them bigger but I can't
grab
anything to drag them.
Help!?
Not an expert so please keep it somewhat simple.
Thanks,
Mary
--
MT

it was good help... thanks.

"Dave" wrote:

Mary

Click on View, Toolbars, Control Toolbox and click on the Top left icon. It
should change in and out of design mode. Once in design mode you should be
able to change the size of your active x controls. Then you need to click
the icon again to get out of design mode.

Hope this helps.

Dave

"Mary Thomas" wrote in message
...
Hi there!
I've inserted several ActiveX Control text boxes into an excel form. A
couple of them are too small and I need to make them bigger but I can't
grab
anything to drag them.
Help!?
Not an expert so please keep it somewhat simple.
Thanks,
Mary
--
MT

Mary,

If you're using Excel 2007, click on the Developer tab, and then, in the
Active X controls part of the buttons ribbon click on "Design Mode". It's
the second button from the left in that section. Then when you're done,
click on the Design mode button again, to turn off design mode. I've
noticed, however, that if you click once on the text box with the right-click
button suppressed, it will often go into design mode (even when not in Design
Mode). Maybe this is why the text box in Excel 207 is so unstable. When I
tested a form I designe din Excel 2007, a lot of my test group could not writ
ein the active X text box, even though it functioned for me perfectly. They
were all also using Excel 2007. Another thing to keep in mind when opting to
use the Active X text box control in Excel 2007 is that it doesn't translate
functionally into Excel 2003. The drop-downs do. What I ended up doing is
eliminating all of the Active X text boxes and using a blank cell instead. I
then used dynamic linking to get the data from the blank cell to where I
wanted to populate it into a hidden row for transport into a master workbook.

I hope this is helpful.

Karen

"Mary Thomas" wrote:

Hi there!
I've inserted several ActiveX Control text boxes into an excel form. A
couple of them are too small and I need to make them bigger but I can't grab
anything to drag them.
Help!?
Not an expert so please keep it somewhat simple.
Thanks,
Mary
--
MT