2015年9月28日 星期一

VBA 特別字附處理 

VBA 特別字附處理
 
VBA Character Codes and Character Constants         
Code                   Character         
Chr(9)                 Tab         
Chr(10)                Line-feed        
Chr(11)                Soft return (Shift+Enter)        
Chr(12)                Page break        
Chr(13)                Carriage return        
Chr(13) + Chr(10)      Carriage return/line-feed combination        
Chr(14)                Column break        
Chr(34)                Double straight quotation marks ('')        
Chr(39)                Single straight quote mark/apostrophe (')        
Chr(145)               Opening single smart quotation mark (')        
Chr(146)               Closing single smart quotation mark/ apostrophe (')        
Chr(147)               Opening double smart quotation mark (")        
Chr(148)               Closing double smart quotation mark (")        
Chr(149)               Bullet        
Chr(150)               En dash        
Chr(151)               Em dash 
 
 
more:
http://www.asciitable.com/ 
 
reference:
http://www.java2s.com/Code/VBA-Excel-Access-Word/Data-Type-Functions/UsingtheChrFunctionandConstantstoEnterSpecialCharactersinaString.htm
張貼者： 於
標籤：

1 則留言:

Blogger 提到...

As stated by Stanford Medical, It's really the ONLY reason women in this country get to live 10 years longer and weigh an average of 19 KG less than we do.

(And realistically, it has totally NOTHING to do with genetics or some secret exercise and EVERYTHING to do with "HOW" they are eating.)

BTW, I said "HOW", and not "what"...

CLICK this link to discover if this easy quiz can help you find out your real weight loss potential

2020年3月6日 下午5:36

張貼留言

訂閱： 張貼留言 (Atom)