Skip to content

Instantly share code, notes, and snippets.

View rediffusion's full-sized avatar
🎯
Focusing

Mr. Nick rediffusion

🎯
Focusing
View GitHub Profile
@rediffusion
rediffusion / Office VBA_14
Last active July 30, 2019 13:08
NOTE: Для »» `Menu` и `Dynamic Menu` подходит тоже!
Sub MyButtonCallbackShowImage(control As IRibbonControl, ByRef showImage)
Select Case control.ID
Case "MyBtn1"
'Можно ещё так »» showImage = 0; 1;
showImage = False
Case "MyBtn2"
showImage = True
End Select
End Sub
@rediffusion
rediffusion / Office VBA_15
Last active July 30, 2019 13:08
NOTE: Для »» `Menu` и `Dynamic Menu` подходит тоже!
Sub MyButtonCallbackShowLabel(control As IRibbonControl, ByRef showLabel)
Select Case control.ID
Case "MyBtn1"
showLabel = False
End Select
End Sub
@rediffusion
rediffusion / Office VBA_16
Last active July 30, 2019 13:09
NOTE: Для »» `Menu` и `Dynamic Menu` подходит тоже!
Sub CallbackGetSize(control As IRibbonControl, ByRef size)
' Callback size
' 0 = normal
' 1 = large
Select Case control.ID
Case "myBtn1"
size = 0
Case "myBtn2"
size = 1
End Select
@rediffusion
rediffusion / Office VBA_18
Last active July 30, 2019 10:12
NOTE: В “Box”-се уже будет текст (смотреть »» EditBox - onChange)!
Sub MyEditBoxCallbackgetText(control As IRibbonControl, ByRef strText)
Select Case control.ID
Case "MyEditBox"
strText = "Hello World"
' strText = "Cat""Lucky"""
' Case Else
'Почему `Tag` не знаю, возможно используется в `XML`.
' strText = getTheValue(control.Tag, "DefaultValue")
End Select
End Sub
Sub MyEditBoxCallbackOnChange(control As IRibbonControl, strText As String)
Select Case control.ID
Case "MyEditBox"
MsgBox "Значение “Editbox” : " & _
strText, vbInformation, "Это заголовок!"
End Select
End Sub
Sub CallbackGetTitle(control As IRibbonControl, ByRef title)
Select Case control.ID
Case "mySeparator2"
title = "My Title"
End Select
End Sub
@rediffusion
rediffusion / Office VBA_22
Last active July 30, 2019 12:23
NOTE: Для »» `DropDown ` и `Gallery ` аналогично!
Sub CallbackCBGetItemCount(control As IRibbonControl, ByRef count)
'Callback кол-во Items
Select Case control.ID
Case "myComboBox"
count = 4
End Select
End Sub
@rediffusion
rediffusion / Office VBA_23
Last active July 30, 2019 12:21
NOTE: Для »» `DropDown ` и `Gallery` аналогично!
Sub CallbackCBGetItemID(control As IRibbonControl, _
index As Integer, _
ByRef itemID)
itemID = Format(index, "00") & "a"
End Sub
@rediffusion
rediffusion / Office VBA_24
Last active July 30, 2019 12:25
NOTE: Для »» `DropDown ` и `Gallery` аналогично!
Sub CallbackCBGetItemImage(control As IRibbonControl, _
index As Integer, _
ByRef image)
Select Case control.ID
Case "myComboBox"
Set image = LoadPicture(getAppPath & _
"Pictures\" & _
Format(index, "00") & ".JPG")
'Case else 'Или – ImageMso
image = "HappyFace"
@rediffusion
rediffusion / Office VBA_25
Last active July 30, 2019 12:26
NOTE: Для »» `DropDown ` и `Gallery` аналогично!
Sub CallbackCBGetItemLabel(control As IRibbonControl, _
index As Integer, _
ByRef label)
Select Case control.ID
Case "myComboBox"
label = DLookup("txtName", "tblPictures", _
"txtPicName='" & _
Format(index, "00") & "'")
End Select
End Sub