注æ
ãã®ãã¼ã¸ã«ã¢ã¯ã»ã¹ããã«ã¯ãæ¿èªãå¿ è¦ã§ãã ãµã¤ã³ã¤ã³ã¾ãã¯ãã£ã¬ã¯ããªã®å¤æ´ã試ããã¨ãã§ãã¾ãã
ãã®ãã¼ã¸ã«ã¢ã¯ã»ã¹ããã«ã¯ãæ¿èªãå¿ è¦ã§ãã ãã£ã¬ã¯ããªã®å¤æ´ã試ããã¨ãã§ãã¾ãã
æå®ãã ListFormat ãªãã¸ã§ã¯ãã®ç¯å²å ã®æåã®æ®µè½ã®ãªã¹ãã®å¤ã®è¡¨ç¤ºå½¢å¼ãè¡¨ã æåå ãè¿ãã¾ãã ä¸è¦§ãã¢ã«ãã¡ãããé ã§ 2 çªç®ã®æ®µè½ãè¿ããªã©ã® B ã§ãã
æ§æ
å¼ã ListString
å¼ 'ListFormat' ãªãã¸ã§ã¯ããè¿ãå¼ã
注é
è¡é æåä»ãã®ç®æ¡æ¸ãã§ã¯ãæååã表示ããããã«æ£ãããã©ã³ããé©ç¨ããå¿ è¦ãããã¾ãã é常ã¯ãSymbol ã¾ã㯠Wingdings ãã©ã³ãã使ç¨ãã¾ãã
ListValue ããããã£ã使ç¨ãã¦ã段è½ã®æ°å¤ãåå¾ãã¾ãã
ä¾
次ã®ä½¿ç¨ä¾ã¯ã鏿ç¯å²å ã®æåã®æ®µè½ã®æ°å¤ã¨ãã®æ°å¤ã«å¯¾å¿ããæååã®ä¸¡æ¹ã表示ãã¾ãã
v = Selection.Range.ListFormat.ListValue
lstring = Selection.Range.ListFormat.ListString
MsgBox "List value " & v _
& " is represented by the string " & lstring
é¢é£é ç®
ãµãã¼ãã¨ãã£ã¼ãããã¯
Office VBA ã¾ãã¯ãã®èª¬ææ¸ã«é¢ããã質åããã£ã¼ãããã¯ãããã¾ããï¼ ãµãã¼ãã®åãæ¹ããã³ãã£ã¼ãããã¯ããå¯ãããã ãæ¹æ³ã®ã¬ã¤ãã³ã¹ã«ã¤ãã¦ã¯ãOffice VBA ã®ãµãã¼ãããã³ãã£ã¼ãããã¯ãåç §ãã¦ãã ããã