dropdown wingdings list?

[John Caines]

Hello All.
I attach a screenshot here of my problem,, if somebody can help me with a solution to this please as I just can't see why it's not showing correctly?

Basically, I wanted to create a drop down menu with either a tick or a cross.

What's happened though as I hope you can see,,,
because the cells are formatted to wingding,, the cross or tick insert ok,
but the drop down for some reason shows a P or a O ???????????

Anybody help me out here please?

I can't seem to get over it?

Not sure what to do.

If somebody can help I would be most grateful.

Many thanks for all your time.
John Caines

 

[dave3009]

Don't use Wingdings!

Use Insert>>Symbol>>Character Code:2713 (check) and the next cell Character Code:2715 (cross)

Use this as your validation list

 

[JoeMo]

I don't know a direct fix, but here's a possible work around in the meantime.
Cells J11:J12 are the input cells for the drop down. L11:M12 is a lookup table. Your drop down will now have two choices: "check mark" and "X mark"

Excel Workbook
	G	H	I	J	K	L	M	N
10
11				check mark		P	check mark
12				X mark		O	X mark
13
14
Sheet1

Looks like Dave has a real fix!

 

[John Caines]

Many thanks Dave3009 & Joemo,

1st Dave3009,,

I can't get your suggestion to work Dave????????
You say:
Use Insert>>Symbol>>Character Code:2713 (check) and the next cell Character Code:2715 (cross)

Basically I created a Name in the name manager,,, for cell range, C20:C22
That house a blank cell, then a tick & a cross in the last cell.
This Name,, I've used in the data validation.

Thing is,, I did use ;
INSERT>SYMBOL>WINGDINGS2> CHARACTER CODE 80
(The above is for the tick)
&
INSERT>SYMBOL>WINGDINGS2> CHARACTER CODE 79
(For the cross)

The cells range that this name range is for is R26:AC5025
(I formatted all these cells as Wingdings 2)


Sorry Dave 3009,, can you explain how you are doing it,,
inserting Character Code:2713,,, from my above scenario??
As I can't see how to do it.??

Sorry,, Joe Mo,, I'll look at your solution now.

Many thanks too you both.
BRB
Many Thanks
John Caines

#####Just To Add Dave###

I have tried formatting name range (Tick_Cross) to Calbri font,,
then going to insert>Symbol> then chose 2713,, but I got a funny looking M with a squiggly bit on the bottom right of it

 

[John Caines]

Sorry JoeMo,,
My named range is like 15 rows away,,

Not sure how to recode it for this?
& I have quite a lot of cells that need the drop down,,
Range:
R26:AC5025

 

[dave3009]

Inserting a character is not the same a dressing up a letter as a character.

Cell C20: leave blank
Cell C12: Insert>>Symbol>>2713
Cell C22: Insert>>Symbol>>2715

Now name cells C20:C22 to your desired name.

You'll get your desired - ✓ or ✕ - in the dropdown.

 

[John Caines]

Dave,,,
Sorry mate,, but still not got it,,,

Give me 5 minutes,,
I'll do a very quick Camtasia screen video,,,

I'll show you exactly.


Bloody excel!!!
(Well,, me really).

Thanks for your reply
5 mins

 

[John Caines]

Hi Dave3009,,
A raw video screencam,
http://dl.dropbox.com/u/16052166/excel_for_dave.zip

That's the download link to my screencam

It will open in a webpage,,
or just look in the folder for the mp4 file.

It's only a shot vid,,
but you'll hopefully see my problem.

Many thanks for your help Dave,

I just don't see what I'm doing wrong

All the best
john caines

(I'm using excel 2010)

 

[dave3009]

[img=http://img845.imageshack.us/img845/9757/onebd.th.png]
[img=http://img204.imageshack.us/img204/9487/twons.th.png]
[img=http://img72.imageshack.us/img72/1933/threez.th.png]
[img=http://img194.imageshack.us/img194/5373/fours.th.png]
[img=http://img12.imageshack.us/img12/46/fivef.th.png]

 

[John Caines]

ARIAL UNICODE MS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
DINGBATS!!!!!!!!!!!!!!!!!!!!!!!!!


that's what I needed Dave 3009!!
Many thanks for that..

It's funny how excel never picked it up from me just inserting the character numbers when I was in the symbols ??

Heyho...
Sorted now

many thanks again Dave.
I'll get cracking on my spreadsheet again.

All the best,,
& thanks again.

A very grateful

John Caines