_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ _/ _/ [ Software Name ] _/ ktMsgBoxAddin Ver3.40 in English _/ [ Software Kind ] _/ FREEWARE _/ [ Development Environment ] _/ Windows 10 & Excel 2003SP3/2007SP3/2010SP2/2016 _/ [ Operative Environment ] _/ Windows98SE and later, both 32 bits & 64 bits are supported. _/ Excel2000 and later _/ [ Developer ] _/ Keiichi Tsunoda (AddinBox) (Addinbox@h4.dion.ne.jp) _/ URL: http://addinbox.sakura.ne.jp/index.htm (Japanese Only) _/ http://addinbox.sakura.ne.jp/ktMsgBox_Series_English.htm _/ _/ Old URL: http://www.h3.dion.ne.jp/~sakatsu/index.htm (Japanese Only) _/ _/ [ Exemption From Responsibility ] _/ The author shall assume no responsibility _/ for any damage which may be caused by using this software, _/ [ Redistribution ] _/ Redistribution of the distribution file is allowed for free _/ as long as the contents are NOT changed in any way. _/ [ Reproduction ] _/ I forbid it to release a distribution file without permission on _/ your websites. When you introduce this software, please guide the _/ following website by a link. _/ Site name : AddinBox _/ URL : http://addinbox.sakura.ne.jp/ktMsgBox_Series_English.htm _/ [ Versions History ] _/ 30 July 2002 Ver 1.00 (Japanese Version only) _/ 18 Oct. 2002 Ver 2.00 (Japanese Version only) _/ 10 Nov. 2002 Ver 3.00 (Japanese Version only) _/ 22 Dec. 2002 Ver 3.10 (Japanese Version only) _/ 14 Jan. 2003 Ver 3.10 in English (1st English version) _/ 3 Apr. 2003 Ver 3.11 in English _/ 10 Jun. 2003 Ver 3.12 in English _/ 28 Jun. 2003 Ver 3.13 in English _/ 20 Sep. 2011 Ver 3.20 in English _/ 19 Sep. 2015 Ver 3.30 in English _/ 16 Apr. 2018 Ver 3.40 in English _/ [ Other Information ] _/ This Software has been thoroughly checked with "TrendMicro Virus Buster Cloud" _/ and it contains no Viruses, Malware, Spyware or Sellware of any kind. _/ _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ This Distribution File includes a Demonstration Workbook (ktMsgBox_Demo.xls), which is self-contained so you don't need to set up the ktMsgBoxAddin.xla. ---------------------------------------------------------------------------- << Special Features >> 1. The basic Syntax of ktMsgBox inherits an interface of MsgBox of the VBA function. The only difference is the function name of "MsgBox" and "ktMsgBox". You only do this small change and can use ktMsgBox. 2. This Add-In have included two Versions. The 1st one is called "ktMsgBox" and it has same interface as MsgBox, and the 2nd one is called "ktMsgBoxEX" which is an Extended Version. 3. Just as in the case of MsgBox, when you change the setting of "Screen Properties" in the Control Panel, this will also define the fixed Font which will be used by ktMsgBox. 4. The following settings are impossible to define with MsgBox, but ktMsgBox allows to set them through the corresponding arguments: a. Display Position b. Font Family (Arial, Tahoma, etc.) c. Font Color and Background Color d. Font Size e. Bold Style (these features are only enabled in ktMsgBoxEX) f. Font and Font Color set by line. (these features are only enabled in ktMsgBoxEX) 5. This Add-In has a built-in Chime Function, which you may use it to get the User's attention. 6. You may change the Icon to display and the Wave sound to play to your own. a. This makes it possible to display your Company's Logo (or whatever you wish). b. You could also save a Voice Wave File saying something as: "I found an Error!" or "All the Processing has been done!" so you may have a Message Box with your own voice! c. There are 17 built-in Icons which may be specified for use. (the 4 Standard Icons of MsgBox plus 13 additional icons of ktMsgBoxAddin) 7. The Button's Caption may be set to anything through the User Definition Button feature. The User's Default Button may be set to be any Button from the 1st to the 4th. And the Button Caption may also be defined as something such as "Yes_To_All". 8. A TextBox for may be specified to allow entering text and, if this feature is used, ktMsgBox becomes an alternative for the InputBox function, which, additionally, allows you to use the following features which do not exist in the InputBox Function: a. The Width of the Text Box may be specified. b. In addition to Characters entry, you may also specify attributes for a Numerical or Date value. c. It is also possible to use Password feature which replaces all typed character by "*", hiding them. 9. A Background Image may be specified. In this case, the window size may be specified to fit so the image will be displayed complete.(Usually, the window size is made to fit the length of the text automatically.) 10. It is possible to have ktMsgBox close automatically after displaying for a few seconds. 11. You may also display HyperLink Messages both for URL Addresses such as (http://...) as for Email Addresses (mailto:...). 12. There are many Arguments in ktMsgBox, but most may be ommitted, filling in only those Arguments which you decide to use. Furthermore, if you use our "ktMsgBox Wizard", the Macro Code for the Message Box will be interactively completed for you. 13. --- Ver 3.40 Changes --- (1) Beep sound processing when displaying MsgBox has been changed. I changed the way of specifying the sound set in [Control Panel / Sound] from the way of directly specifying the sound file in the [Windows\Media] directory with the file name. (2) When Width / Height of UserForm was dynamically set in Excel2016, it corresponded to a bug that was narrower (7.5 p) than in earlier versions. [ UserForm is shorter and narrower than in earlier versions of Excel ] https://support.microsoft.com/en-us/help/3156159 ---------------------------------------------------------------------------- << How To Use >> The Help Document (ktMsgBox_Help.chm) has detailed explanation. Please read that one. First of all, you must perform the Add-In Registration in Excel in order to use ktMsgBox add-in. And, you set reference to ktMsgBoxAddin.xla in a Workbook using "ktMsgBox" or "ktMsgBoxEX". (ktMsgBox add-in is available in the Reference Setting only without the Add-In Registration.) 1. Extract the distribution file on your PC. You will find it contains: a. ktMsgBox_ReadMe.txt (This Text File) b. ktMsgBoxAddin.xla (The Excel Add-In) c. ktMsgBox_Help.chm (The Help File in HTML Format) d. ktMsgBoxDemo.xls (Self-contained Workbook for demonstration) e. AddinBox.gif (The image for the opening message with ktMsgBoxDemo.xls) Note: The file that you downloaded from the network may be blocked by security. The each files that you extracted may be blocked by security, too. If so, please use the [Unblock] Button in the Properties Window to make it usable. 2. Save ktMsgBoxAddin.xla to your Add-in Directory. You may save the other files in any directory you wish. Please save AddinBox.gif and ktMsgBox_Help.chm in the folder same as ktMsgBoxDemo.xls. 3. -- Add-In Registration -- Open New Workbook, and Load Add-In Applications. -- Excel2000 to Excel2003 -- a. On the [Tools] menu, click [Add-Ins]. b. In the Add-Ins available box, select the check box next to ktMsgBoxAddin and click [OK]. -- Excel2007 and later -- a. Click [Office Button / File Tab] , and then click [Excel Options]. b. Click [Add-Ins] Section. c. In the Manage Box, select [Excel Add-ins] and click [Go]. d. In the Add-Ins available box, select the check box next to [ktMsgBoxAddin] and click [OK]. 4. -- Set reference to ktMsgBoxAddin.xla in VBA-Project -- a. Open the Workbook in which you want to use these Functions. b. In the Visual Basic Editor, Select [Tools / References...] on the Main Toolbar. c. If the "ktMsgBoxAddin" appears in the Available References List, select its check box, if not, use the [Browse] Button to find "ktMsgBoxAddin.xla" and include it (make sure the Type is "Microsoft Excel Files (*.xlsm, *.xlam, *.xls, *.xla)" so it will appear). ktMsgBox and ktMsgBoxEX will be available in VBA as soon as you finish the above-mentioned steps. Note: "Source Code Generation Wizard" is included in the ktMsgBoxDemo.xls. You may easily create the needed Code using the Wizard without learning all the syntax and rules. ---------------------------------------------------------------------------- << Add-In Directories >> There are two Directories for saving Add-Ins. ktMsgBoxAddin will appear in the Add-Ins Registration Dialog List once you store it in either Directory. ktMsgBoxAddin does not include a Worksheet Function. It is only VBA Function. Therefore, you may save ktMsgBoxAddin.xla in either the Office Add-In Directory or the User's Add-In Directory. 1. Office Application Add-Ins Directory ("Library" directory) a. This is the Library Directory within the Office Directory. It is the same Directory in which the "Analysis Tool Add-In" resides. You can get the Path of your PC by follows. -- VBA Macro -- MsgBox Application.LibraryPath -- Immediate Window of VBE -- Type the following Instruction in the Immediate Window of the Visual Basic Editor and hitting Return: ? Application.LibraryPath b. In Windows Vista and later, it is a Directory handled by the UAC (User Account Control), therefore it will be necessary to turn off UAC in Admin User before saving the Add-In. [ What is User Account Control? ] http://windows.microsoft.com/en-us/windows7/What-is-User-Account-Control c. The Directory is the same in every Version of Windows. However, Directories differ according to the Excel Version. -- for Excel 2003 -- C:\Program Files\Microsoft Office\Office11\Library -- for Excel 2007 -- C:\Program Files\Microsoft Office\Office12\Library -- for Excel 2010 -- C:\Program Files\Microsoft Office\Office14\Library -- for Excel 2013/2016 -- In Excel2013/2016, the path varies according to an installation method. [ by Windows installer ] C:\Program Files\Microsoft Office\Office15\Library [ Pre-Install or Click-To-Run ] C:\Program Files\Microsoft Office 15\Root\Office15\Library (Note) In Excel 2016, the part of "Office15" changes to "Office16". -- In the case of Windows(64bit) -- Excel(32 bit) --> C:\Program Files (x86)\..... Excel(64 bit) --> C:\Program Files\..... d. It is necessary to save the Add-In in this Directory to be able to use in a Cell as a Workbook Function. (ktMsgBoxAddin does not include a Worksheet Function. It is only VBA Function.) 2. User's Add-Ins Directory a. This is the Microsoft Add-Ins Directory which is selected as default when you save a File as an Add-In (*.xla , *.xlam) in the "Save As" dialog box. You can get the Path of your PC by follows. -- VBA Macro -- MsgBox Application.UserLibraryPath -- Immediate Window of VBE -- Type the following Instruction in the Immediate Window of the Visual Basic Editor and hitting Return: ? Application.UserLibraryPath b. In Windows Vista and later, this Directory which is not controlled by the UAC (User Account Control). However, it is a Hidden Directory and, therefore it is necessary to turn on the [Show hidden files, folders, and drives] in the Folder Options Control Panel. c. This is a common Directory for every Version of Excel. However, Directories are different according to the Windows Version and, furthermore, there is a specific Directory for each User registered by the Operative System. -- for Windows XP -- C:\Documents and Settings\USERNAME\Application Data\Microsoft\Addins -- for Windows Vista and later -- C:\Users\USERNAME\AppData\Roaming\Microsoft\Addins ---------------------------------------------------------------------------- << History >> -- 14 Apr. 2018 v3.40 (in English) -- (1) Beep sound processing when displaying MsgBox has been changed. I changed the way of specifying the sound set in [Control Panel / Sound] from the way of directly specifying the sound file in the [Windows\Media] directory with the file name. (2) When Width / Height of UserForm was dynamically set in Excel2016, it corresponded to a bug that was narrower (7.5 p) than in earlier versions. [ UserForm is shorter and narrower than in earlier versions of Excel ] https://support.microsoft.com/en-us/help/3156159 -- 19 Sep. 2015 v3.30 (in English) -- (1) I added "ktCell2Position" function. This function converts the screen coordinate of the Cell into the value of Top/Left for UserForm. You can display ktMsgBox/ktMsgBoxEX at the position of the designated Cell by using this function together. (2) It became able to appoint "Empty" with the Top/Left argument of the ktMsgBox/ktMsgBoxEX function. (3) I changed the file name of the Demonstration Workbook from ktMsgBoxTrial.xls to ktMsgBoxDemo.xls. -- 20 Sep. 2011 v3.20 (in English) -- (1) The Add-In now supports Windows x64 & Excel x64. (2) I changed the Help File to a CHM File (HTML Help File). -- 28 Jun. 2003 v3.13 (in English) -- (1) In Excel 2002, there was a fault which became a Runtime Error when Excel started after the Add-In registration. Through changing the way of getting the Fonts List (which was the cause), it was solved. -- 10 Jun. 2003 v3.12 (in English) -- (1) I added the ktMsgBox_Note.txt to the distribution file. (2) In case of Excel 97, I corrected the operation of the color setting form in the ktMsgBox Wizard because it had a flaw. (3) In Excel 2000 and later, I canceled the IntelliSense (Auto-Complete) of the Button argument, because an enumeration type is not usable in Excel97. -- 3 Apr. 2003 v3.11 (in English) -- (1) There was a fault in the ktMsgBox Wizard in the ktMsgBoxDemo.xls, which produced an error when choosing a color from the Web Safe Colors in the Color Name Dialog, so I corrected this. (2) When using Windows XP (or WindowStyle:XP_Mode), the Command Button was located much too close to the bottom of the UserForm, which caused the height of the Title-Bar of WindowsXP (or WindowsStyle:XP_Mode) to be located higher than the WindowsXP (Classic_Mode)/98/ME/NT/2000. This bug has been corrected. -- 14 Jan. 2003 v3.10 (in English) -- (1) This is the first Version in English -- 22 Dec. 2002 v3.10 (in Japanese) -- -- 7 Nov. 2002 v3.00 (Japanese) -- -- 18 Oct. 2002 Ver2.00 (in Japanese) -- -- 30 July 2002 Ver1.00 (in Japanese) -- ---------------------------------------------------------------------------- << Special Thanks >> When developing the English version, I had Colo's help with the English translation. When checking the Add-In's operation in x64, I had the assistance of Kinuyo & Asami. When reviewing the English sentences such as the Help Documents, I had the assistance of Ricardo A. Badani. -------------------------------------------------------------------- In order to get the "Fixed Font information" from the "Display Properties", I used Code from the Website noted below: --- Heropa's Homepage --- (Japanese only) http://plaza5.mbn.or.jp/~heropa/ // VB Tips/Acquisition of information of font of non-client area // -------------------------------------------------------------------- In order to get the Installed Fonts List, I used Code from the Website noted below: --- The Spreadsheet Page (J.Walk & Associates) --- http://j-walk.com/ss/ // Getting a List of Installed Fonts // http://j-walk.com/ss/excel/tips/vbafunctions.htm ======================================================================================