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 / October 2006

Tip: Looking for answers? Try searching our database.

Dropdowns

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dinesh - 12 Oct 2006 14:27 GMT
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.
Dave Peterson - 12 Oct 2006 14:59 GMT
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.

Signature

Dave Peterson

Dinesh - 13 Oct 2006 11:30 GMT
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


Rate this thread:






 
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.