1. Jaafar Tribak

    Animated MsgBox (Added Gif)

    Hi dear forum, Got bored and decided to add some animation to the standard vba MsgBox. It is not going to be of much use to most excel\vba users, but it was fun to code and will add to the MsgBox, some lively aspect that can be used in capturing the user's attention. Basically, the code simply...
  2. Jaafar Tribak

    Multi-Color VBA MsgBox Including Buttons ( Easy to use )

    Hi all, Following a question I saw the other day, where it was asked if we could change the color of the Buttons in the standard vba MsgBox, I decided to give it a shot since I have never seen any code anywhere that addresses the issue. I have seen code before that sets the background color but...
  3. Jaafar Tribak

    Printing the MsgBox

    I decided to write this code and thought I would share it here in case someone finds it useful .... The code is supposed to print the standard MsgBox... The code can easily be amended to make it work for any other window. A case in point is an imbedded WebBrowser control on a worksheet whose...
  4. 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...
  5. Jaafar Tribak

    Putting an Hyperlink in a MsgBox !!

    Hi all, I have been playing with this little project recently which, as the thread title states, allows for adding an hyperlink to the native vba MsgBox. At the moment, I managed to make this work with only one hyperlink per MsgBox... This little "tool"can come as a handy, a quicker and a more...
  6. Jaafar Tribak

    Your Typical VBA Standard MsgBox Behaving Like A TimeOut PopUp With Added Formatting And Some Cool Animation !

    Hi, I have been playing around with this in order to make this kind of plug-and-play timed popup, entirely based on the standard vba MsgBox after having manipulated it with some API calls... A good alternative for the buggy Shell popup. The popup has some cool features such as an optional...
  7. Jaafar Tribak

    Standard VBA InputBox Forced Into Taking More Than 256 Characters (Up to 4280) + Other Cool Features.

    Hi all, I have been playing around with the standard vba InputBox to make it more powerful and flexible. I have named this cutomized vba InputBox as InputBox4280Chars These are the main added features : 1- Takes up to 4280 Chars. 2- InputBox size automatically adjustable depending on the...
  8. 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...
  9. Jaafar Tribak

    Safe MouseWheel Event Hook (Addin)

    Hi dear forum, In the past few months, I have posted various codes which show how to run code upon wheelmouse-scrolling. Basically, intercepting the mouse scroll event relies on four known techniques : Subclassing, Installing a windows Mouse Hook, using the SetWinEventHook API or using the...
  10. C

    "SetWindowsHookEx" Crashing Excel x64

    Hello. For a while I've been using the MsgBoxCB sub from Dan Elgaard ( in order to have message boxes with custom button text. Up until now I have been using Excel 2007-2019 x32 and everything has been working perfectly. Recently I started testing my application on Excel 2016...
  11. Jaafar Tribak

    Lock-UnLock VBAProjects Programmatically without SendKeys

    Hi all, I Have recently written this piece of code so I just thought I would post it here for future reference should anyone be looking for vba code to lock\unlock a vbaproject programmatically without needing to use the unreliable SendKeys method. workbook example This code requires that the...

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