Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2006

Tip: Looking for answers? Try searching our database.

Control Tool Box

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Epinn - 30 Aug 2006 09:21 GMT
Hi,

I want to learn how to use the elements (e.g. command button, option button,
combo box etc.) in the control tool box.  Can someone point me to some
articles/tutorial?  Don't seem to have much luck with help?  What is the
control tool box for anyway?

Thanks.

Epinn
Bob Phillips - 30 Aug 2006 10:05 GMT
It is a collection of worksheet controls that are event driven. If you
select one and then draw it on a worksheet, double-click the object and you
will be taken to a template event procedure for that control.

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Hi,
>
[quoted text clipped - 6 lines]
>
> Epinn
Epinn - 30 Aug 2006 11:08 GMT
Thanks, but don't understand "event" at all.  Are you talking about VBA,
macro etc.?

I would like to be able to read about some examples.

Epinn

> It is a collection of worksheet controls that are event driven. If you
> select one and then draw it on a worksheet, double-click the object and you
[quoted text clipped - 18 lines]
> >
> > Epinn
Bob Phillips - 30 Aug 2006 12:02 GMT
No, I mean that it responds to events, things that happen. For instance, if
it is a commndbutton, there is a click event associated with it and you can
code that event. A combobox has a click event, but it also has a change
event. You can code to both. Because the controls have programmable events,
it offers greater flexibility.

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Thanks, but don't understand "event" at all.  Are you talking about VBA,
> macro etc.?
[quoted text clipped - 26 lines]
> > >
> > > Epinn
JLatham - 02 Sep 2006 08:14 GMT
"Are you talking about VBA, macro etc.?"

Yes and no - an event, as Bob Phillips is some action that takes place such
as a click on a control or a change in the contents of a cell on a worksheet.
In response to such an event, quite often certain VBA code is excuted.  
Example might be this in response to clicking on a command button:

Sub Command1_Click()
   MsgBox "You clicked Command Button 1"
End Sub

If you're going to use the controls right on an Excel sheet, you may want to
look at the Forms toolbar rather than the Control Toolbox.  They have similar
groups of controls, but the ones from the Forms toolbar are really created to
integrate with worksheets well: you can set up a cell to 'reflect' what
happened to a control, or which item was selected from a list or combo
box(drop down), and even have lists and dropdowns get their contents from a
group of cells on the worksheets.  

Again, as Bob Phillips said, those Forms controls have 'wizards' to make
their set up very easy.  Draw a control on the worksheet, right-click on it
and use Format Control to set the properties.  And [F1] works great while
doing that.

> Thanks, but don't understand "event" at all.  Are you talking about VBA,
> macro etc.?
[quoted text clipped - 26 lines]
> > >
> > > Epinn
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.