回答編集履歴
1
追記
answer
CHANGED
|
@@ -1,3 +1,21 @@
|
|
|
1
1
|
入力値ならTarget.Value
|
|
2
2
|
単純に左をさすならTarget.Offset(, -1).Value
|
|
3
|
-
ですが、他にも色々問題はありそう。
|
|
3
|
+
ですが、他にも色々問題はありそう。
|
|
4
|
+
|
|
5
|
+
---
|
|
6
|
+
|
|
7
|
+
```vba
|
|
8
|
+
Private Sub Worksheet_Change(ByVal Target As Range)
|
|
9
|
+
Application.EnableEvents = False
|
|
10
|
+
|
|
11
|
+
With Target
|
|
12
|
+
If .Column = 3 And .Row > 1 And .Value <> "" Then
|
|
13
|
+
If InStr(.Value, "(") = 0 Then
|
|
14
|
+
.Value = "(" & .Offset(0, -1).Value & ")" & .Value
|
|
15
|
+
End If
|
|
16
|
+
End If
|
|
17
|
+
End With
|
|
18
|
+
|
|
19
|
+
Application.EnableEvents = True
|
|
20
|
+
End Sub
|
|
21
|
+
```
|