No Picture
Microsoft Office & VBA

Prettify dynamic grids

Using textboxes instead of grids. Adding grids such as Flexgrid to VBA userforms is fraught with difficulties to do with versioning, security and so on. Sometimes you have to just bite the bullet and use […]

No Picture
Json

Dynamic Event Handlers

Creating event handlers dynamically Normally, when creating a control on a form within the development environment, you assign your code for event handling through the control. However, when your controls are created dynamically, clearly you […]

No Picture
Microsoft Office & VBA

Dynamic Forms

Creating forms dynamically Creating forms and form controls using the IDE is pretty straightforward. When the form is rather static, you can lay it all out in advance. However when the layout of the form […]