Dropdowns

D

Dinesh

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.
 
D

Dave Peterson

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"
 
D

Dinesh

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
 
D

Dave Peterson

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).
 
Top