販売管理ソフトを作る - 「見積一覧」「見積入力」 定数の定義

フリー 販売管理 Excel ユーザフォーム

「見積一覧」「見積入力」 定数の定義

一覧画面と入力画面の共通部分を、共通モジュール「modCommon」を作成し、移動。
■ modCommon



00001 Option Explicit

00002 

00003 'Public Const DEBUG_MODE As Boolean = True

00004 Public Const DEBUG_MODE As Boolean = False

00005 

00006 Public Const MARGIN As Integer = 4

00007 Public Const PADING As Currency = 3 '2.8

00008 Public Const TEXT_PADING As Currency = 18 '21.75

00009 Public Const LINE_HIGHT As Integer = 18

00010 Public Const FONT_SIZE As Currency = 11.25

00011 Public Const FONT_NAME As String = "ＭＳ ゴシック"

00012 Public Const CAPTION_BORDER_COLOR As Long = &HFF8080

00013 Public Const CAPTION_BACK_COLOR As Long = &HFFC0C0

00014 Public Const LABEL_BORDER_COLOR As Long = &HC0C0C0

00015 Public Const LABEL_BACK_COLOR As Long = &H80000016

00016 

00017 Public Const DB_PATH As String = "G\販売管理.mdb"