VBA用户表格中的普通话/中文标签？ [英] Mandarin/Chinese in labels in VBA userforms?

问题描述

我可以在普通话中的VBA用户表格的标签中写文字吗？

我尝试将字体从Tahoma / Western Script更改为例如@ FangSong / CHINESE_BIG5但它没有效果。

我还没有安装中文语言包（会等到我真正完成作业）并期望这会有所作为。

任何有此领域经验的人？

提前致谢！

：o ）

解决方案

你可以使用它:(这是特殊符号的代码）

Chr（）与（）的符号的unicode号之间，如果你不知道unicode号，你可以去你的笔记本电脑上的特殊标志程序或者你可以使用代码：

- 首先你选择想知道

的unicode的字符然后你运行这段代码

 dim sign as string 
 
 sign = activewindow.selection 
 
 msgbox cstr（asc（sign））
 
 

与制作转换器的方式相同，是否更改了键盘上的每个字母（a，b，c）通过普通话标志

但是：你的普通话/单词可能没有unicode标志，在这种情况下，这整个程序将无法正常工作

Can I write text in a label in a VBA userform in mandarin?

I have tried changing the font from Tahoma/Western Script to e.g. @FangSong/CHINESE_BIG5 but it has no effect.

I have not yet installed a chinese language pack (will wait till I actually get the assignment) and expect that that will make a difference.

Anyone with experience in this field?

Thanks in advance!

:o)

解决方案

you can use this: (it's the code for special sign's)

Chr() with between the () the unicode number of the sign, if you don't know the unicode number, you can go to the special sign program that is normally on your laptop or you can use the code:

- first you select the character you want to know the unicode of

then you run this code

dim sign as string

sign = activewindow.selection

msgbox cstr(asc(sign))

in the same way you can make a convertor, were you change every letter (a, b, c) on your keyboard by a mandarin sign

BUT: it can be that there is no unicode sign for your mandarin letters/words, in that case this whole procedure won't work

这篇关于VBA用户表格中的普通话/中文标签？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！