[ 15 Sep. 2016 ]  AddinBox site moved from [ DION ] to [ SAKURA ].
[ (Old)  http://www.h3.dion.ne.jp/~sakatsu/...  ( Archive ) (New)  http://addinbox.sakura.ne.jp/...   ]

 

The following is the list of the contents which have translated into English
in the AddinBox site.

Because I who am poor at English am translating into English while using
translation software,  there may be an odd expression.

When you send e-mail to me, please do not use abbreviation expression used
well by e-mail etc. Please write by simple expression which can be translated
with translation software.
      Mail to : addinboxNOSPAM@h4.dion.ne.jp
                    ( Remove NOSPAM from the addresses before sending. )

( Note )
    If warning of "<file name> is not commonly downloaded and could be dangerous"
    is given by the downloading of the file, ....


The following software works in [ x64 ] (Windows & Excel).

1. National holiday in Japan
    Introduction of the kind of national holiday in Japan and holiday logic.

2. ktMsgBox Add-in Ver3.40    ( 16 Apr 2018 , Update )
    The add-in which substitutes for MsgBox which can specify a font, a display
    position, etc.
    ( Figure-1 , Figure-2 )

3. Calendar class Add-in Ver1.20
    The add-in which creates on UserForm the calendar control which needs
    neither ACCESS nor VisualBasic.
    You only prepare Frame Control. A class module elaborates a calendar form
    of the DTPicker/MonthView-style there.
    ( Figure-1 , Figure-2 )

4. ktDATEDIF function
    The bug exists in the DATEDIF function of Excel. Moreover, the bug has
    deteriorated further by Excel2007.
    This ktDATEDIF function is made in accordance with the rule of a correct
    periodic accounting.
    In addition, this page comments on DAYS360(NASD),YEARFRAC(NASD),
    YEARFRAC(Act/Act).

5. Breakthrough in the Pseudo-Control-Array ( clsBpca Ver 4.0 )    ( 1 Sep 2020 , Update )
    The document which explains technique to realize Control-Array (including
    the event handling) at the same level as VB with a class module in VBA.

6. ToggleLabel-Button class ( clsBpcaTglLbl Ver 4.1 )  ( Figure )
    Flag type button only with good points of Toggle, Option and CheckBox.

7. Focus changes without passing Exit event  
    In the situation that the focus changes from inside to outside of Frame control,
    Exit event of TextBox control in Frame control may not fire.

8. WEEKNUM function and ISO8601 week-numbering  
    It is explanation of the week number of WEEKNUM function of Excel and ISO
    standard (ISO8601). I introduce the formula to calculate the week number of
    ISO8601 by standard functions.

9. Focus Check class ( clsBpcaFocus  Ver 1.5 )
    The class which detects focus movement (change of ActiveControl) without using Enter/Exit event.

10. DTPicker control of Windows is usable in API (Ver 3.3)
    [VB & mscomclt2.ocx unnecessary]
    DTPicker control is the common control that Windows(IE) has.
    Even if it does not have VisualBasic (ActiveX control), you can use it in VBA by API.
    I conceal difficult processing to call API in a class module.
    You can use DTPicker control of Windows just to prepare ComboBox control as the base.
    ( Figure-1 , Figure-2 )

    (Now Translating ... )

11. MonthView control of Windows is usable in API (Ver 1.2)
    [VB & mscomclt2.ocx unnecessary]
    MonthView control is the common control that Windows(IE) has.
    Even if it does not have VisualBasic (ActiveX control), you can use it in VBA by API.
    I conceal difficult processing to call API in a class module.
    You can use MonthView control of Windows just to prepare Label control as the base.
    ( Figure-1 , Figure-2 )

    (Now Translating ... )


12. CommandBar Menu & Add-in Tab with add-in of Excel2013/2016.  
    This is a procedure manual for trouble-free operation of CommandBar menu ( Add-in Tab )
    created by Add-in book in SDI ( Single Documents Interface ) environment of Excel2013 /
    2016. Please note that in the case of "Save type menu ( Temporay: = False )", differences in
    execution procedure of add-in registration / cancellation cause troubles that are not reflected
    as expected.

[ AddinBox Home (Japanese) ]

AddinBox ( K.Tsunoda in Japan ) CopyRight(C) 2005 Allrights Reserved.