質問するログイン新規登録

回答編集履歴

2

修正

2021/09/22 03:06

投稿

jinoji
jinoji

スコア4592

answer CHANGED
@@ -13,7 +13,7 @@
13
13
  Dim c As Range
14
14
  For Each c In 盤
15
15
  Select Case c.Value
16
- Case "", "銀", "パール"
16
+ Case "", "と", "圭", "杏", "馬", "竜", "銀", "", "桂", "香", "角", "飛", "王", "金"
17
17
  c.Orientation = 90
18
18
  c.Font.Name = "@游ゴシック"
19
19
  Case Else

1

追記

2021/09/22 03:06

投稿

jinoji
jinoji

スコア4592

answer CHANGED
@@ -4,4 +4,41 @@
4
4
  c.Font.Name = "@游ゴシック"
5
5
  End Function
6
6
 
7
+ ```
8
+
9
+ ---
10
+ 後手の駒だけ漢字変換済みなら
11
+ ```vba
12
+ Function 後手反転(盤 As Range)
13
+ Dim c As Range
14
+ For Each c In 盤
15
+ Select Case c.Value
16
+ Case "金", "銀", "パール"
17
+ c.Orientation = 90
18
+ c.Font.Name = "@游ゴシック"
19
+ Case Else
20
+ c.Orientation = 0
21
+ c.Font.Name = "游ゴシック"
22
+ End Select
23
+ Next
24
+ End Function
25
+ ```
26
+
27
+ 漢字に変換する前に書式設定するなら
28
+ ```vba
29
+ Function 後手反転(盤 As Range)
30
+ Dim c As Range
31
+ For Each c In 盤
32
+ If c.Value = UCase(c.Value) Then
33
+ '大文字なら先手
34
+ c.Orientation = 0
35
+ c.Font.Name = "游ゴシック"
36
+ Else
37
+ '小文字なら後手
38
+ c.Orientation = 90
39
+ c.Font.Name = "@游ゴシック"
40
+ End If
41
+ Next
42
+ End Function
43
+
7
44
  ```