Рет қаралды 28,300
In this Excel video tutorial you will learn how to create custom UI/UX Design interface forms using Excel VBA.
The resources of the Excel VBA programming environment are very limited when it comes to creating forms with a modern look, which in many cases, forces us to migrate to Visual Studio, since this is a specific system for development of mobile, web and desktop systems.
Even with all the limitation that Excel VBA has in terms of application development, it is possible to develop custom forms with a modern look and attractive appearance as required by the UI/UX design.
One of the main tips in this video is regarding the images or icons of the buttons. For those who are already familiar with Excel VBA know that the PNG image format, widely used for allowing transparent background in images, is not accepted within VBA, which often makes it difficult to create more modern forms.
To get around this limitation of VBA, we will use another image format, a little less popular, but which also allows images on a transparent background and that VBA accepts, the ICO format.
Image formats supported by Excel VBA
.bmp - does not allow transparent background
.jpg - does not allow transparent background
.ico - allows transparent background
Download Link
drive.google.c...