Johniny

Unicode in VBA

Mar 11th, 2020
469
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub formatToCzech()
  2.     Selection.NumberFormat = "#,##0 [$K" & ChrW(269) & "-cs-CZ]" 'napíše Kc správne s diakritikou na zaklade Unicode kodu
  3. End Sub
  4.  
  5. 'urobene na zaklade tohto: http://dailydoseofexcel.com/archives/2010/11/19/unicode-and-vbas-chrw-and-ascw-functions/
  6. 'unicode kod pre dany znak mozem zistit s excel funkciou UNICODE() !!!
RAW Paste Data