#Winsock excel vba tutorial code#

#Winsock excel vba tutorial code#

Public Property Let IsCancelled(ByVal value As Boolean)ДЄnd now we can change the code that works with a UserForm and make it work off the ISomeView interface, e.g. If CloseMode = VbQuerењњlose.vbFormControlMenu ThenД«ut then, nothing forbids creating another class module that implements the ISomeView interface without being a user form - this could be a SomeViewMock class: Option Explicit Private Sub UserForm_Querењњlose(Cancel As Integer, CloseMode As Integer) Private Sub SomeOtherSettingInput_Change() Private Property Set ISomeView_Model(ByVal value As ISomeModel) Private Property Get ISomeView_Model() As ISomeModel Private Property Get ISomeView_IsCancelled() As Boolean The form's code-behind could look like this: Option Explicit Public Property Set Model(ByVal value As ISomeModel)

Public Property Get Model() As ISomeModel Public Property Get IsCancelled() As Boolean Say you have an ISomeView interface that the form itself implements: Option Explicit The ability to implement interfaces allows completely decoupling the application logic from the UI, or from the database, or from this or that worksheet. Working With Files and Directories Without Using FileSystemObjectД®xample Polymorphism is the ability to present the same interface for different underlying implementations.String Literals - Escaping, non-printable characters and line-continuations.Searching within strings for the presence of substrings.

Reading 2GB+ files in binary in VBA and File Hashes.

Macro security and signing of VBA-projects/-modules.

Automation or Using other applications Libraries.

Assigning strings with repeated characters.