|
-
Mar 2nd, 2010, 12:32 PM
#1
Thread Starter
Addicted Member
[RESOLVED] put tick mark in the cell
COLUMN l A has text format
and put tick mark through macro
if i put Cell(1, "A") .VALUE = "Ö"
but it put the same vlaue "Ö" here instead tick mark.
pl help.
-
Mar 2nd, 2010, 12:48 PM
#2
Re: put tick mark in the cell
Try This
Code:
Sub Sample()
ActiveCell.Value = "ü"
ActiveCell.Characters.Font.Name = "Wingdings"
End Sub
A good exercise for the Heart is to bend down and help another up...
Please Mark your Thread " Resolved", if the query is solved
MyGear:
★ CPU ★ Ryzen 5 5800X
★ GPU ★ NVIDIA GeForce RTX 3080 TI Founder Edition
★ RAM ★ G. Skill Trident Z RGB 32GB 3600MHz
★ MB ★ ASUS TUF GAMING X570 (WI-FI) ATX Gaming
★ Storage ★ SSD SB-ROCKET-1TB + SEAGATE 2TB Barracuda IHD
★ Cooling ★ NOCTUA NH-D15 CHROMAX BLACK 140mm + 10 of Noctua NF-F12 PWM
★ PSU ★ ANTEC HCG-1000-EXTREME 1000 Watt 80 Plus Gold Fully Modular PSU
★ Case ★ LIAN LI PC-O11 DYNAMIC XL ROG (BLACK) (G99.O11DXL-X)
★ Monitor ★ LG Ultragear 27" 240Hz Gaming Monitor
★ Keyboard ★ TVS Electronics Gold Keyboard
★ Mouse ★ Logitech G502 Hero
-
Mar 2nd, 2010, 01:00 PM
#3
Thread Starter
Addicted Member
Re: put tick mark in the cell
Kool
i want v tick mark
it puts x one
-
Mar 2nd, 2010, 01:05 PM
#4
Re: put tick mark in the cell
Show me the code that you are using...
A good exercise for the Heart is to bend down and help another up...
Please Mark your Thread " Resolved", if the query is solved
MyGear:
★ CPU ★ Ryzen 5 5800X
★ GPU ★ NVIDIA GeForce RTX 3080 TI Founder Edition
★ RAM ★ G. Skill Trident Z RGB 32GB 3600MHz
★ MB ★ ASUS TUF GAMING X570 (WI-FI) ATX Gaming
★ Storage ★ SSD SB-ROCKET-1TB + SEAGATE 2TB Barracuda IHD
★ Cooling ★ NOCTUA NH-D15 CHROMAX BLACK 140mm + 10 of Noctua NF-F12 PWM
★ PSU ★ ANTEC HCG-1000-EXTREME 1000 Watt 80 Plus Gold Fully Modular PSU
★ Case ★ LIAN LI PC-O11 DYNAMIC XL ROG (BLACK) (G99.O11DXL-X)
★ Monitor ★ LG Ultragear 27" 240Hz Gaming Monitor
★ Keyboard ★ TVS Electronics Gold Keyboard
★ Mouse ★ Logitech G502 Hero
-
Mar 2nd, 2010, 01:13 PM
#5
Thread Starter
Addicted Member
Re: put tick mark in the cell
ActiveCell.Value = "b"
ActiveCell.Characters.Font.Name = "Wingdings"
if i use this one it shows as tick mark
-
Mar 2nd, 2010, 01:18 PM
#6
Thread Starter
Addicted Member
Re: [RESOLVED] put tick mark in the cell
sorry i am wrong, it works great. thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|