1Attribute VB_Name = "SetTextBoxFont"
2'*************************************************************************
3'
4'  Licensed to the Apache Software Foundation (ASF) under one
5'  or more contributor license agreements.  See the NOTICE file
6'  distributed with this work for additional information
7'  regarding copyright ownership.  The ASF licenses this file
8'  to you under the Apache License, Version 2.0 (the
9'  "License"); you may not use this file except in compliance
10'  with the License.  You may obtain a copy of the License at
11'
12'    http://www.apache.org/licenses/LICENSE-2.0
13'
14'  Unless required by applicable law or agreed to in writing,
15'  software distributed under the License is distributed on an
16'  "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
17'  KIND, either express or implied.  See the License for the
18'  specific language governing permissions and limitations
19'  under the License.
20'
21'*************************************************************************
22Option Explicit
23
24' We change the font used for text box shapes here for the japanese
25' version, because office 2000 sometimes displays squares instead of
26' chars
27Public Sub SetTextBoxFont()
28    Dim aSheet As Worksheet
29    Dim myShape As Shape
30    Set aSheet = Sheets(1)
31
32    For Each myShape In aSheet.Shapes
33        If myShape.Type = msoTextBox Then
34            myShape.Select
35            With Selection.Characters.Font
36                .Name = "MS PGothic"
37                .Size = 10
38            End With
39        End If
40    Next myShape
41    Range("A1").Select
42End Sub
43
44