Tag Archives: MSForms

Getting A Handle On Userforms [VBA]

In a previous post I wrote about how to add minimize and maximize buttons to a VBA userform. A necessary part of that process is to get the handle to the userform’s window, but the focus of that post was … Continue reading

Posted in Microsoft Excel | Tagged , , , , | 5 Comments

VBA: Understanding ByVal In An ActiveX Textbox KeyPress Event Handler

I was posting on one of the online forums a while back and helped a user understand some code which he had found on the web and, in particular, how it restricted what could be typed into a textbox on … Continue reading

Posted in Microsoft Excel | Tagged , , , , , | Leave a comment

Minimize And Maximize Userform Across 32-bit and 64-bit Environments

If you scour the internet you’ll find plenty of examples of how to give your VBA userform minimize and maximize buttons. The exact code will vary depending on the trinkets the programmer wants, but a typical snippet will look something … Continue reading

Posted in Microsoft Excel | Tagged , , , , , , , , , , , , , , | 1 Comment

Stop MSForms.Frame Scrollbars From Resetting On Focus

I’ve been doing some more work on my dynamic grid control – which mostly comprises of MSForms Comboboxes in a Frame. A feature of a Frame control with scrollbars is that when it gets the focus the scrollbars’ positions reset themselves. Here’s some quick … Continue reading

Posted in Microsoft Excel | Tagged , , , | 3 Comments

Deceptive Appearances: MSForms Textboxes And Comboboxes

The Microsoft Forms 2.0 Object Library (FM20.dll) really lacks a number of controls. One which I seem to miss the most often is a “grid” control which will let users select rows and edit data in multiple columns. For this sort of … Continue reading

Posted in Microsoft Excel | Tagged , , , , , , , , , , , | 2 Comments