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 / January 2005

Tip: Looking for answers? Try searching our database.

Use of Control Tools

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kathy - 25 Jan 2005 16:17 GMT
Two questions:

1) How do I add check boxes to items?  I see the check box on the Control
Toolbar but how do I add them to cells?  Does the worksheet need to be
protected first?

2) There is a drop down list of items already in a cell on the spreadsheet.  
It is not visible until one clicks the cell. Then you see the arrow and the
list.  I would like to get into the list to put a value at the top that says
"choose an option" AND have that option show so that people know to click the
cell.  Again, do I need to protect the worksheet?

Thanks very much,
Kathy
Harald Staff - 25 Jan 2005 21:45 GMT
Hi Kathy

You can not put controls in cells. Controls float above the worksheet and
may or may not connect their results and behavior to the underlying cells.
So you can make something that looks like checkboxes in cells, or cells that
look like ckeckboxes, but it grows messy pretty fast and will be very
awkward to operate from a keyboard.

The dropdown list is Data validation. See
http://www.contextures.com/xlCondFormat01.html on this, it's very useful.

HTH. Best wishes Harald

> Two questions:
>
[quoted text clipped - 10 lines]
> Thanks very much,
> Kathy
Harald Staff - 25 Jan 2005 21:51 GMT
> The dropdown list is Data validation. See
> http://www.contextures.com/xlCondFormat01.html on this, it's very useful.

Apologies for the wrong link, a "copy" action didn't do the job. Should be
http://www.contextures.com/xlDataVal01.html

Harald
Kathy - 26 Jan 2005 01:03 GMT
THANKS VERY MUCH, THIS HIT THE SPOT!  

Kathy

> > The dropdown list is Data validation. See
> > http://www.contextures.com/xlCondFormat01.html on this, it's very useful.
[quoted text clipped - 3 lines]
>
> Harald
Harald Staff - 26 Jan 2005 18:59 GMT
Cool, thanks for the feedback!
Best wishes Harald

> THANKS VERY MUCH, THIS HIT THE SPOT!
 
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.