VBA need arrow

[sksanjeev786]

Hi Team,

I need arrow instead of p,q r font (Wingding)
can you please see the attaced file.

Book1
	E	F	G	H	I	J	K	L	M	N	O
5											p
6											r
7											q
8
9	Brand Favorability	66%	5.8 p	66%	-0.6 q	0%	0.0
10	Consideration Intent	66%	3.7	66%	-4.1	0%	0.0
11	Consideration First Choice	13%	-3.2	16%	-2.3	0%	0.0
12	Purchase Intent	63%	4.4	51%	3.3	0%	0.0
13	BA: Is a brand for me	61%	5.6 r	49%	0.8	0%	0.0
14	Additional Brand Metrics
Sheet1

 

[Micron]

Then set the font to one of the Wingdings font sets?

p r q

 

[sksanjeev786]

Then set the font to one of the Wingdings font sets?

p r q

View attachment 77009

Yes you are right..

 

[Micron]

Please mark you thread as solved if you have a solution.
Thanks.
P.S. forgot to say that I used Wingdings 3 and formatted the character colours individually.

 

[sksanjeev786]

Please mark you thread as solved if you have a solution.
Thanks.
P.S. forgot to say that I used Wingdings 3 and formatted the character colours individually.

Hi
I didn't get the solution as my data are in columns G and I and i need the letters p,q r to be changed as arrows beside data.
Same how i have shown in the image.

Regards
Sanjeev

 

[Micron]

That is the solution?? You only set p character to be Wingdings font.

 

[sksanjeev786]

That is the solution?? You only set p character to be Wingdings font.

View attachment 77012

Hi Micron,

If i set up the wingding font under the cell i am getting below data
please see the image mentioned below

 

[Micron]

You don't set it for the CELL you set it for the one character.

 

[sksanjeev786]

That is the solution?? You only set p character to be Wingdings font.

View attachment 77012

Hi Micron,

If i set up the wingding font under the cell i am getting below data
please see the image mentioned below
View attachment 77013

You don't set it for the CELL you set it for the one character.

okay! can you please help me on above thing hope you understand scenario what i am looking for

I need data and arrows in the same cell.

 

[Micron]

I have explained this at least twice already and posted pictures that seem to show what you want. If the pics I posted don't show you want you want then you have to explain why.

I select/highlight "p" character...

I choose Wingdings3 and green ...

result:

If that's not what you want then you need to explain why. If it is what you want then you need to do the same.