#1   Report Post  
Old January 5th 10, 06:52 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2010
Posts: 32
Default Tick mark

Hi How do i add tick mark in excel sheet?i know its in symbol but i want to
prepare yes or no tick mark...

  #2   Report Post  
Old January 5th 10, 07:11 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 15,768
Default Tick mark

See this:

http://groups.google.com/group/micro...75653838?tvc=2

--
Biff
Microsoft Excel MVP


"Rohinikumar" wrote in message
...
Hi How do i add tick mark in excel sheet?i know its in symbol but i want
to
prepare yes or no tick mark...



  #3   Report Post  
Old January 5th 10, 07:46 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 2,836
Default Tick mark

Hummmmmmm, not sure what you're doing, but try this:

Right-click the sheet where you want this; paste into the window that opens:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Cancel = True
If Not Intersect(Target, Range("A1:AZ100")) Is Nothing Then
If Target = "P" Then
Target = vbNullString
ElseIf Target = vbNullString Then
Target = "P"
Else
End If
End If
End Sub

Format text as Wingdings 2!!
Double-click any cell to add check marks.


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Rohinikumar" wrote:

Hi How do i add tick mark in excel sheet?i know its in symbol but i want to
prepare yes or no tick mark...

  #4   Report Post  
Old January 5th 10, 08:30 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,909
Default Tick mark

Private Sub Worksheet_BeforeDoubleClick(ByVal _
Target As Range, Cancel As Boolean)
If Target.Cells.Count 1 Then Exit Sub
With Target
.Font.Name = "Marlett"
.Font.Size = 12
.Value = "a"
End With
Cancel = True
End Sub

Right-click on the sheet tab and "View Code"

Copy/paste the code into that sheet module.


Gord Dibben MS Excel MVP


On Mon, 4 Jan 2010 21:52:01 -0800, Rohinikumar
wrote:

Hi How do i add tick mark in excel sheet?i know its in symbol but i want to
prepare yes or no tick mark...




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
tick mark.! via135 Excel Discussion (Misc queries) 3 September 15th 09 09:13 PM
Tick Mark Label funkev123 Charts and Charting in Excel 2 October 14th 08 10:07 PM
not able to see tick mark label e57 Charts and Charting in Excel 4 August 29th 08 02:22 AM
How can I add active tick mark/check mark boxes in excel? gerberelli Excel Discussion (Misc queries) 2 May 3rd 08 05:16 PM
tick mark labels Debrane Charts and Charting in Excel 9 July 19th 05 02:53 AM


All times are GMT +1. The time now is 06:42 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017