olecreatepictureindirect

  1. Jaafar Tribak

    Round Buttons on UserForm (Beveled + Clickable + Tab-able)

    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...
  2. Jaafar Tribak

    Adding a Menu system to UserForms

    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...
  3. Jaafar Tribak

    Changing the Font & Back Colors of individual Tabs\Pages in a MultiPage

    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...
  4. Jaafar Tribak

    VBA Class to Make Mouse Cursors from Worksheet Shapes

    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...
  5. Jaafar Tribak

    How to make UserForm Frame Controls transparent

    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...
  6. Jaafar Tribak

    Little Puzzle UserForm Game done in Excel/VBA

    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...
  7. L

    export shnapshot as PNG/JPG

    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've detected that you are using an adblocker.

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.
Go back
Back
Top