VBA, MS Access MS Access в примерах

MS Excel - Модуль констант со значениями

Будет полезно при использовании записанных макросов из MS Excel

Содержимое выглядит так:

Public Const xl24HourClock = 33
Public Const xl3DArea = -4098
Public Const xl3DAreaStacked = 78
Public Const xl3DAreaStacked100 = 79
Public Const xl3DBar = -4099
Public Const xl3DBarClustered = 60
Public Const xl3DBarStacked = 61
Public Const xl3DBarStacked100 = 62
Public Const xl3DColumn = -4100
Public Const xl3DColumnClustered = 54
Public Const xl3DColumnStacked = 55
Public Const xl3DColumnStacked100 = 56
Public Const xl3DEffects1 = 13
Public Const xl3DEffects2 = 14
Public Const xl3DLine = -4101
Public Const xl3DPie = -4102
Public Const xl3DPieExploded = 70
Public Const xl3DSurface = -4103
Public Const xl4DigitYears = 43
Public Const xlA1 = 1
Public Const xlAbove = 0
Public Const xlAbsolute = 1
Public Const xlAbsRowRelColumn = 2
Public Const xlAccounting1 = 4
Public Const xlAccounting2 = 5
Public Const xlAccounting3 = 6
Public Const xlAccounting4 = 17
Public Const xlAdd = 2
Public Const xlAddIn = 18
Public Const xlADORecordset = 7
Public Const xlAll = -4104
Public Const xlAllAtOnce = 2
Public Const xlAllChanges = 2
Public Const xlAllExceptBorders = 7
Public Const xlAllFaces = 7
Public Const xlAllTables = 2
Public Const xlAlternateArraySeparator = 16
...


и т.д (1 500 строк) ниже.




Скачать

Файл модуля (BAS) ( 11 kB) Константы MS Excel


Назад ToTop
L.E. 28.08.2018
Рейтинг@Mail.ru