spinjector
New Member
- Joined
- Aug 2, 2021
- Messages
- 1
- Office Version
- 365
- 2019
- 2007
- Platform
- Windows
I recently started using Excel 2019 on Windows 10. In this environment, Windows places a thin red border around VBA UserForms, and there are no properties within VBA to change it. In the screenshot below, I've changed the UserForm border style to 'Thin' & color to 'Black' to show what I mean. What used to be the UserForm border is now only around the "control space" below the title bar.
I'm not fond of this appearance, and I'd like to set the border width, color, and the style to a more traditional '3D'. But the old 3D isn't an option in VBA; I thought perhaps it might still be available through Windows.
So.....can Windows API calls be used to do any of this..?
I've searched Google and found surprisingly little on this topic. This StackOverflow page comes close, but it only gets the border width, and doesn't set it. And it does nothing with the color or style.
I'm not fond of this appearance, and I'd like to set the border width, color, and the style to a more traditional '3D'. But the old 3D isn't an option in VBA; I thought perhaps it might still be available through Windows.
So.....can Windows API calls be used to do any of this..?
I've searched Google and found surprisingly little on this topic. This StackOverflow page comes close, but it only gets the border width, and doesn't set it. And it does nothing with the color or style.