Excel add-in for Unicode string in vietnamese

Hướng dẫn Tiếng Việt

Informations

Add-in: vbaVanXuan
Author: vietcom
License: Freeware
Version: 0.9 (02 Oct 2008)

Description

This add-in support changecase procedure for Unicode string in vietnamese and support convert amount of money in number to string

Setup

This add-in is tested only on Microsoft Excel 2002 (Excel XP), for other Excel version, this setup maybe is not correct and this add-in maybe does'nt work!
  1. For Excel XP, folder of add-in is C:\Documents and Settings\<user-name>\Application Data\Microsoft\AddIns, with <user-name> is windows login name of user.
    Copy file vbaVanXuan.xla to the folder of add-in.
  2. Open Excel, select menu Tools/Add-Ins..., check the checkbox beside VBAVanXuan, then OK.
    SelectAdd-in

How to use

Change selected cells to UPPERCASE

Press Ctrl + Shift + U.
First Select Press Result
first select Ctrl + Shift + U upcase

Change selected cells to LOWERCASE

Press Ctrl + Shift + L.
First Select Press Result
first select Ctrl + Shift + L lower

Change selected cells to PROPERCASE

Press Ctrl + Shift + P.
First Select Press Result
first select Ctrl + Shift + P proper

Convert amount to string

Use function vxMoney(amount). The amount must be equal or less than 1E+15.
Example 1: =vxMoney(100) has the result is Một trăm đồng
Example 2:
Formula Result
Example2 Example2_2

Auto convert amount to string

Select two cells, one has amount and other is blank, then press Ctrl + Shift + M.
Select Press Result
money1 Ctrl + Shift + M money2
money1 Ctrl + Shift + M money2