Windows API codes make use of special functions which are not part of Excel or VBA, but part of the main Windows application. If your code is expected to work on Windows and Mac, then using the VBA solution is the better option. Of the two, the Windows API solution has a smoother, more integrated feel for the user, but it will only work on Windows. There are two solutions presented below, a Windows API method and a VBA only method. With a bit of coding magic, we can achieve a similar resizing effect for our VBA UserForms. Most other forms and windows within the Excel and Windows environments do not have a fixed sized they can be resized by the user. When creating a VBA UserForm, we generally set it to a specific size.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |