Excel VBAã®ãŠå‹‰å¼·ï½œã‚°ãƒãƒ¼ã‚¦ã‚£ãƒ³ãŸã¾ã«ä½¿ã†ã¨ãƒ«ãƒ¼ãƒ—ã‹ã‚‰ã®å–り出ã—ã«æ··ä¹±ã—ã¾ã›ã‚“ã‹(æ±—)？ セル書ãè¾¼ã¿ã‚„値ã®ç¢ºèªå‡¦ç†ãªã©å…¥ã‚Œã‚‹ã¨åˆ†ã‹ã‚Šã«ãã„ã®ã§ã‚·ãƒ³ãƒ—ルã«ã„ãã¾ã—ãŸã€‚ 実際ã®ä½¿ç”¨ã§ã¯å‚ç…§è¨å®šã¾ãŸã¯CreateObjectã‚’ãŠå¿˜ã‚Œãªã。。 (è¿½åŠ )ã™ã¿ã¾ã›ã‚“ã€ã“ã¡ã‚‰å‚ç…§è¨å®šã®ã¿ã§ãã¾ã™ã€‚ ã“ã®ã‚ªãƒ–ジェクトã¯ã€ŒKeyã€ã¨ã€ŒKeysã€ã€ã€ŒItemã€ã¨ã€ŒItemsã€ãŒã‚ã‚Šã€ç´›ã‚‰ã‚ã—ã„ã®ã§æ³¨æ„ã§ã™ã€‚ ‘============================================== ‘Dictionaryã‹ã‚‰ãƒ«ãƒ¼ãƒ—を使ã£ã¦ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã™ã‚‹ ‘============================================== Sub Dictionaryループ() Dim dic As New Dictionary Dim i As Integer dic.Add "ã‚ー1", "アイテム1" dic.Add
{{#tags}}- {{label}}
{{/tags}}