One way to find out is to show the Forms toolbar. Drag a couple of those
checkboxes/optionbuttons (with groupboxes??)/dropdowns to a test worksheet.
Rightclick on any of them and look at all the tabs under "format control"
> I have seen some files in which there are dropdown and options buttons. But
> they are not operating with macros. They are just linked to some cells. How
> to create such dropdowns and option buttons.
Thank you very much it solved my query. In fact initially I was trying it
with the control toolbox options which looks similar to forms toolbar and are
connected to the macros.
Dinesh
> One way to find out is to show the Forms toolbar. Drag a couple of those
> checkboxes/optionbuttons (with groupboxes??)/dropdowns to a test worksheet.
[quoted text clipped - 4 lines]
> > they are not operating with macros. They are just linked to some cells. How
> > to create such dropdowns and option buttons.
Dave Peterson - 13 Oct 2006 14:41 GMT
If you use the controls from the control toolbox toolbar, you can click on the
design mode button (also on that toolbar) and then rightclick and choose
properties.
You can see linked cells and listfillranges for many of those controls.
The controls from the control toolbox toolbar react to many more events than the
controls from the Forms toolbar. But you can assign a macro to the controls
from the Form toolbar (as well as shapes from the Drawing toolbar or pictures
inserted into a worksheet).
I've found that for lots of stuff, the controls from the Forms toolbar are
better behaved and sufficient for what I want (and easier to use).
> Thank you very much it solved my query. In fact initially I was trying it
> with the control toolbox options which looks similar to forms toolbar and are
[quoted text clipped - 14 lines]
> >
> > Dave Peterson

Signature
Dave Peterson