Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Control Tool Box
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Control Tool Box
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. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Epinn" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Control Tool Box
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 "Bob Phillips" wrote in message ... 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. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Epinn" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Control Tool Box
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. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Epinn" wrote in message ... 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 "Bob Phillips" wrote in message ... 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. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Epinn" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Control Tool Box
"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. "Epinn" wrote: 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 "Bob Phillips" wrote in message ... 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. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Epinn" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scroll bars without control tabs | Excel Worksheet Functions | |||
MultiPage control | Excel Worksheet Functions | |||
ActiveX control with chart | Charts and Charting in Excel | |||
Excel 2003 Tool Bar | Excel Discussion (Misc queries) | |||
Copying list-box control | Excel Discussion (Misc queries) |