Hi dear members.
I thought I would post this little project here . Basically, as per the thread title, the code creates beveled round buttons at runtime.
The buttons can be added to the userform or to a frame control.
Behind the scenes, the code creates temporary round shapes in a hidden...
Hi forum,
Workbook Example
I have been playing around with this little vba project and thought I would post it here.
Basically, the code creates a full menu system for (MODAL) userforms (up to 10 entries per menu) based on a table in a worksheet.
PREVIEW
The menus are indexed in the...
Hi dear forum,
As you know, the MsForms Multipage control doesn't offer a built-in functionality for changing the colors of individual tabs. I have seen many requests for this functionality over the years and the usual workaround has always been to add some helper buttons\labels , to change the...
Hi all,
I am posting here this little project which, as the title says, allows the user to create custom userform mouse icons on the fly out of worksheet shapes.
The user can save the newly created .ico file to disk for later use.
Workbook Demo
- Class code...
Hi all,
In case anyone is interested, here is the vba for making frame controls transparent in userforms.
A couple of testings of the code revealed that it is very flexible and it is stable as it doesn't use hooking or subclassing for updating the frames backgrounds when moving around the...
Hi all,
Workbook Example
sometime ago, I developped this little puzzle game in excel and I thought I would post it here ... Not much but it shows the power of VBA when combined with the windows API
1- Code in the UserForm :
Option Explicit
Private Type POINTAPI
x As Long
y As...
Hi guys.
My first post (until now google helped out)
So I want to save the snapshot of a portion of screen (not necessarily excel worksheet) to a file. So far I managed to save it to BMP. But files are too big.
Hence saving to JPG or even GIF is more preferable.
Here is the code I have (I...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.