Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,365
Default adding multiple checkboxes in a single cell

Not really, not the way I think you mean. But remember that one box has two
conditions: checked and not checked. So you could simply put one box in the
cell and set it up so that Checked means Permanent Employee and unchecked
means not permanent employee (contractor/temp/etc).

Get a checkbox, either from the Controls Toolbox or (I prefer) the Forms
toolbox (View | Toolbars to select one or the other of them) and in the
properties for the control, you can set a Cell Link - that cell will reflect
the status of the check box. Then it's easy to check the value in that cell
to see if the person is an employee or not - the values would be TRUE for is
employee, FALSE for is not.

Trick: place the checkbox right on top of the cell that you make the linked
cell then set the cell's font color to the same as the background color and
you won't see the TRUE/FALSE words in the cell, but they'll still be there
for examination and testing. You'll just see the checkbox itself (you can
empty out the text that goes with the label for it).

I hope you find that this is at least a little helpful in your search for a
solution.


"Pat" wrote:

I want to add 2 checkboxes in one cell, similar to a yes/no checkbox but name
one contract and one permanent so that the person entering the data chooses
either or in that cell in order to identify if an employee is a permanent
employee or not. Can this be done in excel?
--
Thanks, Pat


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple cell values to be drawn from single cell/id. El Shish Excel Discussion (Misc queries) 9 August 18th 06 04:30 PM
Multiple dates, times, or formulas in a single cell PM-S Excel Discussion (Misc queries) 2 January 12th 06 04:19 AM
Can multiple cell results be displayed in a single cell? FuadsCurse Excel Discussion (Misc queries) 2 May 18th 05 05:33 PM
Toggle multiple values in single cell Chandni Excel Worksheet Functions 5 February 10th 05 12:48 AM
Can vlookup return multiple matches in a single cell? cchristensen Excel Discussion (Misc queries) 3 December 2nd 04 01:56 AM


All times are GMT +1. The time now is 05:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"