excel, SELECTING MULTIPLE TICK/CHECK BOX

microsoft.public.mac.office.excel - Microsoft products for Macintosh


excel >> SELECTING MULTIPLE TICK/CHECK BOX

by casper » Thu, 13 Nov 2008 01:37:50 GMT

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi, How can I select several tick/check boxes at one time? I tired using the drawing toolbar but I can not select several check boxes.

Thanks,

Casper
Top

excel >> SELECTING MULTIPLE TICK/CHECK BOX

by Bob Greenblatt » Thu, 13 Nov 2008 04:30:06 GMT


On 11/12/08 12:37 PM, in article XXXX@XXXXX.COM ,


Try shift-option

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom
Top

excel >> SELECTING MULTIPLE TICK/CHECK BOX

by Phillip Jones, C.E.T. » Sun, 16 Nov 2008 00:21:46 GMT

another way to to select multiple boxes that are next to each other
vertical, horizontally or both:

*Vertically*:

click in first box hold shift key down then drag mouse up or down until
desire box is reached.

*Horizontally*:

click first desired box, then hold shift key down and drag right or left
until desired cell is reached.

*both directions at same time*:

Click in first cell, them drag diagonally in desired direction, until
desired group of cells is selected.

Make sure you hold down shift key while you are Dragging else you will
end up move (shifting cells), in direction of drag.

When finished selecting group then drag to new position.




--
------------------------------------------------------------------------
Phillip M. Jones, CET mailto: XXXX@XXXXX.COM
If it's "fixed", don't "break it"! http://www.vpea.org
http://www.phillipmjones.net
G4-500 Mac 1.5 GB RAM OSX.3.9 G4-1.67 GB PowerBook 17" 2GB RAM OSX.4.11
------------------------------------------------------------------------
Top
Similar Threads

1. Tick Box/Check Box - Excel

2. Check Box/Tick Box 

I acquired this from one of BP's post. Help is required to fine tune the 
codes. Thanks.


Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As 
Boolean)
Const WS_RANGE As String = "E02:E22"

If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then
With Target
If .Value <> "X" Then
.Font.Name = "Arial"
.Value = "X"

Range("B7").Select
ActiveCell.FormulaR1C1 = _
        
"=IF(ISERROR(VLOOKUP(""X"",R[-2]C[3]:R[15]C[12],10,FALSE)),"""",VLOOKUP(""X"",R[-2]C[3]:R[15]C[12],10,FALSE))"
    Range("B7").Select
    Selection.Copy
    Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
        False, Transpose:=False
    Application.CutCopyMode = False
    Range("B3").Select
'.Offset(2, -3).FomulaFormat = ""

Else
.Value = ""
'.Offset(0, 1).Value = ""
Range("B7").Select
    Selection.ClearContents
    Range("B3").Select

End If
End With
End If

End Sub

3. [VBA] Check/TIck the selected Item List in Pivot Table - Excel

4. Check/TIck the selected Item List in Pivot Table 

anyone???

5. Allowing only 1 check box to be ticked - Excel

6. How to create a x mark in the check box instead of tick 

Another question. How to create a x mark in the check box instead of tick

"RobN" wrote:

> Joergiman,
> 
> On the Menu bar select Developer, then Insert and double click the Checkbox 
> in the Form Controls section. (Or single click and draw the box where you 
> want it on the spreadsheet.
> 
> Rob
> 
> "Narnimar" < XXXX@XXXXX.COM > wrote in message 
> news: XXXX@XXXXX.COM ...
> > How to insert a check box it in Excel 2007?
> >
> > "Norman Jones" wrote:
> >
> >> Hi Joergiman,
> >>
> >> View | Toolbars | Forms | Double click the checkbox | click the 
> >> worksheet.
> >> Click the toolbar checkbox | Close the toolbar
> >>
> >>
> >> ---
> >> Regards,
> >> Norman
> >>
> >>
> >> "joergieman" < XXXX@XXXXX.COM > wrote in message
> >> news: XXXX@XXXXX.COM ...
> >> >A want to insert a check box that can be toggled on and off by clicking 
> >> >on
> >> >it.
> >>
> >>
> >> 
> 
> 
>

7. How do I enter ticks in Excel 97 or check boxes - Excel

8. Check/Tick box's and Mandatory cells 

I have 2 questions;
1. I have added check box's e.g Yes No onto a spreadsheet but you can tick 
both of these. What i am after is to only be able to tick one or the other 
but not both. Can anyone help?
2. I need to make some parts of my spreadsheet mandatory but i have no idea 
on how to do this??? I been through the help files but can not find anything 
about this. Help on this would be great. Thanks