To get a handle on the Drawing Toolbar, the Control Toolbar and the Forms
Toolbar, I thought I'd take each similar control and look closer at each and
how one needs to understand the "different" inter-workings of each.

I thought I's begin with the Text box,
A i begin I'm already confused -
The Drawing TB - OK
The Control TB - OK
The Forms TB - No Textbox - but I see the Edit Box? - which is Grayed-Out...
What's going on? - I've checked in a couple of my Excel books but don't
see anything discussing this point. Can some one get me past this point, and
better point me in some direction or source that I might COMPLETE my
Contrasting research of these 3 Toolbars (from the programming poin tof view).

Thanks,

Jim

I don't have any link to point you to, but insert an "MS Excel 5.0 Dialog" sheet
and you'll see that edit boxes have a home.



JMay wrote:

To get a handle on the Drawing Toolbar, the Control Toolbar and the Forms
Toolbar, I thought I'd take each similar control and look closer at each and
how one needs to understand the "different" inter-workings of each.

I thought I's begin with the Text box,
A i begin I'm already confused -
The Drawing TB - OK
The Control TB - OK
The Forms TB - No Textbox - but I see the Edit Box? - which is Grayed-Out...
What's going on? - I've checked in a couple of my Excel books but don't
see anything discussing this point. Can some one get me past this point, and
better point me in some direction or source that I might COMPLETE my
Contrasting research of these 3 Toolbars (from the programming poin tof view).

Thanks,

Jim

--

Dave Peterson

Thanks Dave,
But how do I Insert a "MS Excel 5.0 Dialog" Sheet? At the Menu (2003) I
went to Insert - poked around but came up with nothing legitimate to select.
Can you clarify how to Insert this?

"Dave Peterson" wrote:

I don't have any link to point you to, but insert an "MS Excel 5.0 Dialog" sheet
and you'll see that edit boxes have a home.



JMay wrote:

To get a handle on the Drawing Toolbar, the Control Toolbar and the Forms
Toolbar, I thought I'd take each similar control and look closer at each and
how one needs to understand the "different" inter-workings of each.

I thought I's begin with the Text box,
A i begin I'm already confused -
The Drawing TB - OK
The Control TB - OK
The Forms TB - No Textbox - but I see the Edit Box? - which is Grayed-Out...
What's going on? - I've checked in a couple of my Excel books but don't
see anything discussing this point. Can some one get me past this point, and
better point me in some direction or source that I might COMPLETE my
Contrasting research of these 3 Toolbars (from the programming poin tof view).

Thanks,

Jim

--

Dave Peterson

Never mind Dave - I found it by Right-Clicking on a Sheet-Tab - getting the
Shortcut menu - there the Insert... MS Excel 5.0 Dialog... I'm Home !!

"Dave Peterson" wrote:

I don't have any link to point you to, but insert an "MS Excel 5.0 Dialog" sheet
and you'll see that edit boxes have a home.



JMay wrote:

To get a handle on the Drawing Toolbar, the Control Toolbar and the Forms
Toolbar, I thought I'd take each similar control and look closer at each and
how one needs to understand the "different" inter-workings of each.

I thought I's begin with the Text box,
A i begin I'm already confused -
The Drawing TB - OK
The Control TB - OK
The Forms TB - No Textbox - but I see the Edit Box? - which is Grayed-Out...
What's going on? - I've checked in a couple of my Excel books but don't
see anything discussing this point. Can some one get me past this point, and
better point me in some direction or source that I might COMPLETE my
Contrasting research of these 3 Toolbars (from the programming poin tof view).

Thanks,

Jim

--

Dave Peterson

The forms textbox is something totally different. Whereas the other two can
be referred to as labels, the forms textbox is inserted on a form, and then
used to enter text, which is then recorded at a predefined spot in the
worksheet, either by setting the control source, or by running a macro to
transfer this data. To see how it works, open a blank worksheet, click
<Alt<F11 to go to VBA. Now click on Insert, Form. Click the textbox icon,
and draw a textbox on the form. You will notice that it appears sunken. It
contains no text however. You can name this box, set a variety of properties
for the textbox. Without doing anything of the sort, click the run icon - a
small right arrow, and you will be taken back to the sorksheet, with the form
superimposed on the sheet. The cursor will flash inside the textbox, and you
can type whatever you want in there. At this stage nothing will happen with
whatever you have type, but you will clearly see the difference between this
and a drawing textbox.

--
HTH

Kassie

Replace xxx with hotmail


"JMay" wrote:

To get a handle on the Drawing Toolbar, the Control Toolbar and the Forms
Toolbar, I thought I'd take each similar control and look closer at each and
how one needs to understand the "different" inter-workings of each.

I thought I's begin with the Text box,
A i begin I'm already confused -
The Drawing TB - OK
The Control TB - OK
The Forms TB - No Textbox - but I see the Edit Box? - which is Grayed-Out...
What's going on? - I've checked in a couple of my Excel books but don't
see anything discussing this point. Can some one get me past this point, and
better point me in some direction or source that I might COMPLETE my
Contrasting research of these 3 Toolbars (from the programming poin tof view).

Thanks,

Jim

Thanks Kassie, But you seem to be focusing on the Active-X textbox, and not
the Forms "Edit Box" -- which is what I'm really trying to figure out it's
purpose and position in the mix. Still confused...

"Kassie" wrote:

The forms textbox is something totally different. Whereas the other two can
be referred to as labels, the forms textbox is inserted on a form, and then
used to enter text, which is then recorded at a predefined spot in the
worksheet, either by setting the control source, or by running a macro to
transfer this data. To see how it works, open a blank worksheet, click
<Alt<F11 to go to VBA. Now click on Insert, Form. Click the textbox icon,
and draw a textbox on the form. You will notice that it appears sunken. It
contains no text however. You can name this box, set a variety of properties
for the textbox. Without doing anything of the sort, click the run icon - a
small right arrow, and you will be taken back to the sorksheet, with the form
superimposed on the sheet. The cursor will flash inside the textbox, and you
can type whatever you want in there. At this stage nothing will happen with
whatever you have type, but you will clearly see the difference between this
and a drawing textbox.

--
HTH

Kassie

Replace xxx with hotmail


"JMay" wrote:

To get a handle on the Drawing Toolbar, the Control Toolbar and the Forms
Toolbar, I thought I'd take each similar control and look closer at each and
how one needs to understand the "different" inter-workings of each.

I thought I's begin with the Text box,
A i begin I'm already confused -
The Drawing TB - OK
The Control TB - OK
The Forms TB - No Textbox - but I see the Edit Box? - which is Grayed-Out...
What's going on? - I've checked in a couple of my Excel books but don't
see anything discussing this point. Can some one get me past this point, and
better point me in some direction or source that I might COMPLETE my
Contrasting research of these 3 Toolbars (from the programming poin tof view).

Thanks,

Jim