[B! ä¸€è¦§] yuta0121ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

yuta0121 id:yuta0121

ä¸€è¦§ã«é–¢ã™ã‚‹yuta0121ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (2)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

Excel VBAã®ColorIndexãƒ—ãƒãƒ‘ãƒ†ã‚£ã«æŒ‡å®šã§ãã‚‹å€¤ã®ä¸€è¦§:ã‚¨ã‚¯ã‚»ãƒ«ãƒžã‚¯ãƒãƒ»Excel VBAã®ä½¿ã„æ–¹
VBAã§è‰²ã‚’æŒ‡å®šã™ã‚‹ã¨ãã«ã¯ã€ColorIndexãƒ—ãƒãƒ‘ãƒ†ã‚£ã‚„Colorãƒ—ãƒãƒ‘ãƒ†ã‚£ã‚’ä½¿ã†ã‚ã‘ã§ã™ãŒã€ç‰¹ã«ColorIndexãƒ—ãƒãƒ‘ãƒ†ã‚£ã«æŒ‡å®šã§ãã‚‹æ•°å€¤ã¨å®Ÿéš›ã®è‰²ã®å¯¾å¿œé–¢ä¿‚ãŒã‚ã‹ã‚Šã«ãã„ã®ã§ã€ColorIndexé †ã®ä¸€è¦§ã«ã—ã¾ã—ãŸã€‚ ColorIndexã®å€¤ã«ã€Colorãƒ—ãƒãƒ‘ãƒ†ã‚£ã§å–å¾—ã§ãã‚‹å€¤ã®16é€²è¡¨è¨˜ã¨RGB10é€²è¡¨è¨˜ã‚’ä½µè¨˜ã—ã¾ã—ãŸã€‚ ï¼ˆVBAã®ä»•æ§˜ä¸Š16é€²è¡¨è¨˜ã§ã¯RGBã§ã¯ãªãBGRã®é †ã«ãªã£ã¦ã„ã¾ã™ã€‚ä¾‹ãˆã°ã€Œ&H0066FFã€ãªã‚‰ã€ã€Œ00ã€ã¯Bã€ã€Œ66ã€ã¯Gã€ã€ŒFFã€ã¯Rã‚’ç¤ºã—ã¦ã„ã¾ã™ã€‚ï¼‰
yuta0121 2016/11/24
VBA

ä¸€è¦§

è‰²

excel

color
ãƒªãƒ³ã‚¯
Redis ã‚³ãƒžãƒ³ãƒ‰ä¸€è¦§
Redisã®ã‚³ãƒžãƒ³ãƒ‰ã«ã¤ã„ã¦èª¿ã¹ãŸè¨˜äº‹ã®ã¾ã¨ã‚ã§ã™ã€‚ å…¨ã¦ã®é …ç›®ã«å…±é€šã®æ“ä½œ EXISTS ã‚ãƒ¼å€¤ã®å˜åœ¨ãƒã‚§ãƒƒã‚¯ DEL æŒ‡å®šã—ãŸã‚ãƒ¼ã‚’å‰Šé™¤ TYPE æŒ‡å®šã—ãŸã‚ãƒ¼ã®ãƒ‡ãƒ¼ã‚¿ã‚¿ã‚¤ãƒ—å–å¾— KEYS ãƒ‘ã‚¿ãƒ¼ãƒ³ã«ãƒžãƒƒãƒã™ã‚‹ã‚ãƒ¼å–å¾— RANDOMKEY ãƒ©ãƒ³ãƒ€ãƒ ãªã‚ãƒ¼å–å¾— RENAME ã‚ãƒ¼åã®å¤‰æ›´ RENAMENX ã‚ãƒ¼åã®å¤‰æ›´ï¼šé‡è¤‡ãƒã‚§ãƒƒã‚¯ã‚ã‚Š DBSIZE ç™»éŒ²ã•ã‚Œã¦ã„ã‚‹ã‚ãƒ¼æ•°ã‚’å–å¾— EXPIRE æŒ‡å®šã—ãŸã‚ãƒ¼ã®æœ‰åŠ¹æœŸé–“ã‚’æŒ‡å®š TTL æŒ‡å®šã—ãŸã‚ãƒ¼ã®æœ‰åŠ¹æœŸé–“ã‚’ç¢ºèª SELECT ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®åˆ‡ã‚Šæ›¿ãˆ MOVE æŒ‡å®šã—ãŸã‚ãƒ¼ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¤‰æ›´ FLUSHDB é¸æŠžã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’å‰Šé™¤ FLUSHALL å…¨ã¦ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’å‰Šé™¤ æ–‡å—åˆ—ãƒ‡ãƒ¼ã‚¿ã«å¯¾ã™ã‚‹æ“ä½œ SET ãƒ‡ãƒ¼ã‚¿ã®ç™»éŒ² GET ãƒ‡ãƒ¼ã‚¿ã®å–å¾— GETSET æ›´æ–°å‰ã®ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã—ãªãŒã‚‰ãƒ‡ãƒ¼ã‚¿æ›´æ–° MGET è¤‡æ•°ã‚ãƒ¼ã‚’æŒ‡å®š
yuta0121 2016/08/18
redis

ã‚³ãƒžãƒ³ãƒ‰

ä¸€è¦§
ãƒªãƒ³ã‚¯
1

ãŠçŸ¥ã‚‰ã›

ã‚‚ã£ã¨èªã‚€

å…¬å¼Twitter

@hatebu
æœ€æ–°ã®äººæ°—ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®é…ä¿¡

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

jæ¬¡ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kå‰ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

lã‚ã¨ã§èªã‚€

eã‚³ãƒ¡ãƒ³ãƒˆä¸€è¦§ã‚’é–‹ã

oãƒšãƒ¼ã‚¸ã‚’é–‹ã

è¨å®šã‚’å¤‰æ›´ã—ã¾ã—ãŸx

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (6)

ä¸€è¦§ã«é–¢ã™ã‚‹yuta0121ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (2)

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´5æœˆç¬¬4é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´5æœˆç¬¬3é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´5æœˆç¬¬2é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (6)

ä¸€è¦§ã«é–¢ã™ã‚‹yuta0121ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (2)

Excel VBAã®ColorIndexãƒ—ãƒ­ãƒ‘ãƒ†ã‚£ã«æŒ‡å®šã§ãã‚‹å€¤ã®ä¸€è¦§:ã‚¨ã‚¯ã‚»ãƒ«ãƒžã‚¯ãƒ­ãƒ»Excel VBAã®ä½¿ã„æ–¹

Redis ã‚³ãƒžãƒ³ãƒ‰ä¸€è¦§

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2025å¹´5æœˆç¬¬4é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2025å¹´5æœˆç¬¬3é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2025å¹´5æœˆç¬¬2é€±ï¼‰

å…¬å¼Twitter

ã‚­ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (6)

ä¸€è¦§ã«é–¢ã™ã‚‹yuta0121ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (2)

Excel VBAã®ColorIndexãƒ—ãƒãƒ‘ãƒ†ã‚£ã«æŒ‡å®šã§ãã‚‹å€¤ã®ä¸€è¦§:ã‚¨ã‚¯ã‚»ãƒ«ãƒžã‚¯ãƒãƒ»Excel VBAã®ä½¿ã„æ–¹

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´5æœˆç¬¬4é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´5æœˆç¬¬3é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´5æœˆç¬¬2é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹