1. Jaafar Tribak

    Custom Data Validation Lists on Steroids !

    Hi all, I have been looking for ways to overcome the weaknesses of the native Excel Data Validation lists and to make such DV lists more versatile by adding often sought functionalities sunch as the following: A- Not being affected by the current worksheet zoom (specially when the worksheet...
  2. Jaafar Tribak

    Making the MouseWheel function in the VBA editor. No DLL or EXE needed - All done from within Excel !!

    Hi all, I have long looked for code that makes the mousewheel scroll the VBE code panes but I could only find some external programmes or dlls written in C. with a bit of trial and error and a couple of tricks, i have put together this code done purely with VBA as you can see which I hope...
  3. Jaafar Tribak

    MouseWheel to Scroll long Cell Validation DopDown Lists ?

    Is there a way ,which i am missing, of scrolling a long validation dropdown list with the mouse wheel ? I am thinking of setting a mouse hook for this (which i guess will be rather involved) but wonder if there is a simpler workround . Regards.

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...