implements

Hi, I coded this class recently and thought I would post it here. Workbook demo. Basically, it is just a standard userform (manipulated with the windows API) that implements a custom Interface (IFloatingShape) for easy & flexible use. One good thing about this API based class is that it...

Hi all, As you know, the TypeOf operator cheks if an object implements a certain interface so the following 2 codes return TRUE as expected : in a userform module: Private Sub UserForm_Click() MsgBox TypeOf Me Is IAccessible End Sub The same goes for this : Private Sub Test1() MsgBox...

we have a keypad that you program each button so when pressed it will bring to front the excel file for that button. i had this working but at work we got updated to office 365 (excel 2016) and i think the title bar naming is the difference. i wrote vbs code to rename the title bar but it puts...

Hi, First post here, as have hit a real stumbling block that is crucial to an application I am writing. I have an Interface Class - coreIReport - it is instantiated as PublicNotCreatable I have a sheet object in the solution (under Microsoft Excel Objects). It has the code behind with...