[ ‰‚ß‚Ä‚Ì•û‚Ö | ˆê——(ÅVXV‡) | ‘S•¶ŒŸõ | ‰ß‹ŽƒƒO ]
@
wƒJƒ^ƒJƒi¨‚Ђ炪‚È‚É•ÏŠ·‚·‚éVBA‹Lq‚ð’ljÁxiNKKj
Private Sub Worksheet_Change(ByVal Target As Range)
Range("B:B").Replace what:="E", Replacement:="", LookAt:=xlPart
End Sub
‚±‚̃`ƒFƒ“ƒWƒCƒxƒ“ƒgƒ}ƒNƒ‚ɃJƒ^ƒJƒi¨‚Ђ炪‚È‚É•ÏŠ·‚·‚é‹Lq‚ð’ljÁ‚µ‚Ä‚‚¾‚³‚¢B
B—ñ‚ɓǂ݉¼–¼‚ŃJƒ^ƒJƒi‚ƂЂ炪‚È‚ª¬Ý‚µ‚Ä‚¢‚Ü‚·
uEv‚̓gƒ‹‹l‚ß‚³‚ê‚Ü‚·B
ƒ Žg—p ExcelFOffice365AŽg—p OSFWindows10 „
uVBA ƒJƒ^ƒJƒi‚ð‚Ђ炪‚È‚É•ÏŠ·v‚È‚Ç‚ÅŒŸõ‚·‚é‚È‚ÇA Ž¿–₳‚ê‚é‘O‚É’²‚ׂĂ݂Ă͂¢‚©‚ªH
‚È‚¨AChangeƒCƒxƒ“ƒgƒvƒƒV[ƒWƒƒ‚Ì‚È‚©‚ŃZƒ‹‚Ì’l‚ð•ÏX‚·‚é‚ÆA ‚»‚ꂪ‚Ü‚½ƒCƒxƒ“ƒg‚𔶂³‚¹‚ÄA‚ ‚éŽí‚̃‹[ƒv‚É‚È‚è‚Ü‚·B EnableEventsƒvƒƒpƒeƒB‚ð‘€ì‚·‚邱‚Æ‚ÅA‚»‚ê‚ð‰ñ”ð‚Å‚«‚Ü‚·B ‚±‚ê‚àŒŸõ‚µ‚Ă݂ĉº‚³‚¢B @ iƒÁj 2022/10/15(“y) 22:34:36
@ iƒÁj 2022/10/15(“y) 22:41:22
yEXCEL VBA | StrConvŠÖ”z•¶Žš—ñ‚̂Ђ炪‚ȂƃJƒ^ƒJƒi‚ð•ÏŠ·‚·‚é | ‚Ђ炿‚ñ‚Ì•”‰®
https://hirachin.com/post-7920/
uVBA Worksheet_Changev‚ÅŒŸõ‚·‚ê‚Ήº‹L‚ªÅ‰‚Ƀqƒbƒg‚µ‚Ü‚·B
‰º‹L‚É“Á’èƒZƒ‹”͈͂̒l‚ð•ÏŠ·‚·‚éƒTƒ“ƒvƒ‹ƒR[ƒh‚ª‚ ‚è‚Ü‚·B
uWorksheet.Change ƒCƒxƒ“ƒg (Excel) | Microsoft Learn
https://learn.microsoft.com/ja-jp/office/vba/api/excel.worksheet.change
ã‹L‚Ì‚Q‚“à—e‚ª—‰ð‚Å‚«‚ê‚ÎAƒR[ƒh‚Í‘‚¯‚é‚Ì‚Å‚ÍH
ƒ`ƒƒƒŒƒ“ƒW‚µ‚Ä‚Ý‚Ä‚‚¾‚³‚¢B
ihatenaj 2022/10/16(“ú) 04:35:06
‚Q‚‚̃Šƒ“ƒNæ‚̃R[ƒh‚ð‘g‚݇‚킹‚é‚ÆA
Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("B:B")) Is Nothing Or Target.Cells.Count > 1 Then Exit Sub Application.EnableEvents = False Target.Value = StrConv(Target.Value, vbHiragana) Application.EnableEvents = True End Sub
•¡”ƒZƒ‹‚ðXVA“\‚è•t‚¯‚É‚µ‚½‚肵‚½ê‡‚ÍAXV‚³‚ê‚È‚¢‚Ì‚ÅA
‚»‚¤‚¢‚¤ê‡‚àl—¶‚·‚é‚È‚çA‚à‚¤‚µC³‚Í•K—vB
ihatenaj 2022/10/16(“ú) 09:06:55
Excel 2019 ‚Ì”z—ñ”Ž®‚¾‚Æ
=CONCAT(UNICHAR(IF(ABS(UNICODE(MID(B2,ROW(OFFSET(A1,0,0,LEN(B2))),1))-12491.5)<43,UNICODE(MID(B2,ROW(OFFSET(A1,0,0,LEN(B2))),1))-96,UNICODE(MID(B2,ROW(OFFSET(A1,0,0,LEN(B2))),1)))))
365 (ŠÂ‹«‚È‚¢‚ñ‚ÅŽQl‚Ü‚Å‚É / let ‚ªŽg‚¦‚ê‚Î 2021 ‚Å‚à’Ê‚é‚©‚ÈH)
CONCAT(UNICHAR(let(cd,UNICODE(MID(B2,sequence(LEN(B2),1)),IF(ABS(cd)-12491.5)<43,cd-96,cd)))
ƒ}ƒNƒ‚Å‚â‚肽‚¢‚Ȃ炱‚Ì”Ž®‚ð evaluate ‚ÅŽÀs‚³‚¹‚Ü‚·‚ËAŽ©•ª‚È‚çB
Sub ƒJƒ^ƒJƒi‚©‚ç‚Ђ炪‚È()
‘ÎÛƒZƒ‹ = "B2"
' (let ‚ªŽg‚¦‚ê‚Î)2021 / 365 (“®ìŠÂ‹«‚È‚µ) ' f = "CONCAT(UNICHAR(let(cd,UNICODE(MID(" & ‘ÎÛƒZƒ‹ & ",sequence(LEN(" & ‘ÎÛƒZƒ‹ & "),1)),IF(ABS(cd)-12491.5)<43,cd-96,cd)))"
' Excel 2019 f = "CONCAT(" & _ "UNICHAR(" & _ "IF(" & _ "ABS(UNICODE(MID(" & ‘ÎÛƒZƒ‹ & ",ROW(OFFSET(A1,0,0,LEN(" & ‘ÎÛƒZƒ‹ & "))),1))-12491.5)<43," & _ "UNICODE(MID(" & ‘ÎÛƒZƒ‹ & ",ROW(OFFSET(A1,0,0,LEN(" & ‘ÎÛƒZƒ‹ & "))),1))-96," & _ "UNICODE(MID(" & ‘ÎÛƒZƒ‹ & ",ROW(OFFSET(A1,0,0,LEN(" & ‘ÎÛƒZƒ‹ & "))),1))" & _ ")" & _ ")" & _ ")"
Debug.Print Evaluate(f)
End Sub
‚ AƒGƒ‰[‚É‚È‚ç‚È‚¢•ÛØ‚Í‚Å‚«‚Ü‚¹‚ñB
‚µ‚©‚µVBA‚Í‚¢‚ë‚¢‚ë‚Æ–Ê“|‚¾‚È‚Ÿ...JS‚È‚çˆês‚Å‚Å‚«‚½‹C‚ª‚·‚é‚ñ‚¾‚¯‚Ç
i‚Æ‚è‚ ‚¦‚¸‘‚j 2022/10/16(“ú) 09:34:13
[ ˆê——(ÅVXV‡) ]
YukiWiki 1.6.7 Copyright (C) 2000,2001 by Hiroshi Yuki.
Modified by kazu.