六十四位Office中API函数声明语句第59讲

VBA语言专家 2021-06-28

162

【分享成果，随喜正能量】一念清净，这世界月朗风清，一念障碍，这世间迷惑重重，尘世可以喧嚣，自心还要明朗。进取精进之心要无相。

跟我学VBA，我这里专注VBA, 授人以渔。我98年开始，从源码接触VBA已经20余年了，随着年龄的增长，越来越觉得有必要把这项技能传递给需要这项技术的职场人员。希望和数据打交道的朋友，都来学习VBA,利用VBA,起码可以提高自己的工作效率，可以有时间多陪陪父母，多陪陪家人，何乐而不为呢？

这讲我们继续学习64位Office API声明语句学习之50讲，这些内容是MS的权威资料，看似枯燥，但对于想学习API函数的朋友是非常有用的。

Const WM_GETDLGCODE = &H87

Const WM_NCMOUSEMOVE = &HA0

Const WM_NCLBUTTONDOWN = &HA1

Const WM_NCLBUTTONUP = &HA2

Const WM_NCLBUTTONDBLCLK = &HA3

Const WM_NCRBUTTONDOWN = &HA4

Const WM_NCRBUTTONUP = &HA5

Const WM_NCRBUTTONDBLCLK = &HA6

Const WM_NCMBUTTONDOWN = &HA7

Const WM_NCMBUTTONUP = &HA8

Const WM_NCMBUTTONDBLCLK = &HA9

Const WM_KEYFIRST = &H100

Const WM_KEYDOWN = &H100

Const WM_KEYUP = &H101

Const WM_CHAR = &H102

Const WM_DEADCHAR = &H103

Const WM_SYSKEYDOWN = &H104

Const WM_SYSKEYUP = &H105

Const WM_SYSCHAR = &H106

Const WM_SYSDEADCHAR = &H107

Const WM_KEYLAST = &H108

Const WM_INITDIALOG = &H110

Const WM_COMMAND = &H111

Const WM_SYSCOMMAND = &H112

Const WM_TIMER = &H113

Const WM_HSCROLL = &H114

Const WM_VSCROLL = &H115

Const WM_INITMENU = &H116

Const WM_INITMENUPOPUP = &H117

Const WM_MENUSELECT = &H11F

Const WM_MENUCHAR = &H120

Const WM_ENTERIDLE = &H121

Const WM_CTLCOLORMSGBOX = &H132

Const WM_CTLCOLOREDIT = &H133

Const WM_CTLCOLORLISTBOX = &H134

Const WM_CTLCOLORBTN = &H135

Const WM_CTLCOLORDLG = &H136

Const WM_CTLCOLORSCROLLBAR = &H137

Const WM_CTLCOLORSTATIC = &H138

Const WM_MOUSEFIRST = &H200

Const WM_MOUSEMOVE = &H200

Const WM_LBUTTONDOWN = &H201

Const WM_LBUTTONUP = &H202

Const WM_LBUTTONDBLCLK = &H203

Const WM_RBUTTONDOWN = &H204

Const WM_RBUTTONUP = &H205

Const WM_RBUTTONDBLCLK = &H206

Const WM_MBUTTONDOWN = &H207

Const WM_MBUTTONUP = &H208

Const WM_MBUTTONDBLCLK = &H209

Const WM_MOUSELAST = &H209

Const WM_PARENTNOTIFY = &H210

Const WM_ENTERMENULOOP = &H211

Const WM_EXITMENULOOP = &H212

Const WM_MDICREATE = &H220

Const WM_MDIDESTROY = &H221

Const WM_MDIACTIVATE = &H222

Const WM_MDIRESTORE = &H223

Const WM_MDINEXT = &H224

Const WM_MDIMAXIMIZE = &H225

Const WM_MDITILE = &H226

Const WM_MDICASCADE = &H227

Const WM_MDIICONARRANGE = &H228

Const WM_MDIGETACTIVE = &H229

Const WM_MDISETMENU = &H230

Const WM_DROPFILES = &H233

Const WM_MDIREFRESHMENU = &H234

Const WM_CUT = &H300

Const WM_COPY = &H301

Const WM_PASTE = &H302

Const WM_CLEAR = &H303

Const WM_UNDO = &H304

Const WM_RENDERFORMAT = &H305

Const WM_RENDERALLFORMATS = &H306

Const WM_DESTROYCLIPBOARD = &H307

Const WM_DRAWCLIPBOARD = &H308

Const WM_PAINTCLIPBOARD = &H309

Const WM_VSCROLLCLIPBOARD = &H30A

Const WM_SIZECLIPBOARD = &H30B

Const WM_ASKCBFORMATNAME = &H30C

Const WM_CHANGECBCHAIN = &H30D

Const WM_HSCROLLCLIPBOARD = &H30E

Const WM_QUERYNEWPALETTE = &H30F

Const WM_PALETTEISCHANGING = &H310

Const WM_PALETTECHANGED = &H311

Const WM_HOTKEY = &H312

Const WM_PENWINFIRST = &H380

Const WM_PENWINLAST = &H38F

' NOTE: All Message Numbers below 0x0400 are RESERVED.

' Private Window Messages Start Here:

Const WM_USER = &H400

' WM_SYNCTASK Commands

Const ST_BEGINSWP = 0

Const ST_ENDSWP = 1

' WM_NCHITTEST and MOUSEHOOKSTRUCT Mouse Position Codes

Const HTERROR = (-2)

Const HTTRANSPARENT = (-1)

Const HTNOWHERE = 0

Const HTCLIENT = 1

Const HTCAPTION = 2

Const HTSYSMENU = 3

Const HTGROWBOX = 4

Const HTSIZE = HTGROWBOX

Const HTMENU = 5

Const HTHSCROLL = 6

Const HTVSCROLL = 7

Const HTMINBUTTON = 8

Const HTMAXBUTTON = 9

Const HTLEFT = 10

Const HTRIGHT = 11

Const HTTOP = 12

Const HTTOPLEFT = 13

Const HTTOPRIGHT = 14

Const HTBOTTOM = 15

Const HTBOTTOMLEFT = 16

Const HTBOTTOMRIGHT = 17

Const HTBORDER = 18

Const HTREDUCE = HTMINBUTTON

第1套教程：VBA代码解决方案

第2套教程：VBA数据库解决方案

第3套教程：VBA数组与字典解决方案

第4套教程：VBA代码解决方案之视频（第一套的视频讲解）

第5套教程：VBA中类的解读和利用

第6套教程：VBA信息获取与处理

第7套教程：VBA之EXCEL应用

第8套教程：VBA之Word应用（最新推出）

上述教程的学习顺序：

① 7→1→3→2→6→5或者7→4→3→2→6→5。

② 7→8

l如何学习VBA呢? 概括的说就是: 学习过程中要信、解、受、持，更要有回向的业力。无论您在学习的任何阶段，都要对照教程的知识点加持自己的实际工作，总会有丰厚的收获。

数据库

文章转载自VBA语言专家，如果涉嫌侵权，请发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。

六十四位Office中API函数声明语句第59讲

评论

相关阅读