question

MA-5779 avatar image
0 Votes"
MA-5779 asked Viorel-1 answered

Number key pad bullet points vba

Hi
Using number key pad one can insert bullets points by using Alt + 254 @ in the custom format.

What would be the equivalent vba code for the above to insert bullet points in existing group of cells without deleting its cell contents?

Many Thanks

office-excel-itprooffice-vba-dev
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@MA-5779
As your issue focus more on VBA code, to better help you, I would add the tag "office-vba-dev".
Thanks for your understanding.

0 Votes 0 ·

1 Answer

Viorel-1 avatar image
0 Votes"
Viorel-1 answered

Check an example:

 Dim r As Range
 Set r = Sheet1.Range("A1:A4") ' sample range
    
 r.NumberFormat = ChrW(&H25A0) & " @"


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.