setwindowshookex

  1. Jaafar Tribak

    KeyPress Event for Worksheet Cells (Subclassing Without Crashing)

    Hi dear forum. I am sure you are all familiar with the KeyPress and KeyDown events exposed by userform controls. These events not only allow the user to detect any keys being pressed dynamically, but also give the user the opportunity to discard (block) the key if so desired before it actually...
  2. Jaafar Tribak

    Subclassing without crashing - (Testers required.)

    Hi dear excellers, I have put together this project which subclasses userforms (can be extended to other windows) and I would like to know if it works as expected for trapping window messages. I am particularly interested to know if the project is stable enough. Meaning: It dosen't shuts down...
  3. Jaafar Tribak

    MsgBox that waits for user input

    Hello everyone, As we know, a MsgBox is modal, ie: halts code execution and blocks the excel user interface while it is on display. Whereas a modeless userform allows user interaction, but doesn't halt the execution of the caller code : Dim oForm As New UserForm1 oForm.Show vbModeless MsgBox...
  4. 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...
    • Jaafar Tribak
    • Thread
    • atlaxgetcontrol atlaxwininit colorhlstorgb colorrgbtohls color_window createwindowex getdlgitem getsyscolor hcbt_destroywnd innerhtml lwa_colorkey screentoclient setlayeredwindowattributes setwindowshookex ws_child
    • Replies: 51
    • Forum: Excel Questions
  5. 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...
    • Jaafar Tribak
    • Thread
    • bitblt coloradjustluma copyimage createpen drawtext fillrect getdlgctrlid getdlgitem getdlgitemtext getobjectapi hcbt_activate lwa_colorkey movetoex msgbox oletranslatecolor setlayeredwindowattributes settimer setwindowshookex setwindowsubclass wm_ctlcolordlg wm_ctlcolorstatic
    • Replies: 15
    • Forum: Excel Questions
  6. 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...
    • Jaafar Tribak
    • Thread
    • createdc docinfo getdefaultprinter inchestopoints mm_isotropic physicalwidth pointstoscreenpixelsx print msgbox printwindow pw_renderfullcontent setviewportorgex setwindowshookex startdoc startpage
    • Replies: 2
    • Forum: General Discussion & Other Applications
  7. 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...
    • Jaafar Tribak
    • Thread
    • accessibleobjectfrompoint appendmenu createmenu createpopupmenu drawiconex drawmenubar exttextout gdipcreatehiconfrombitmap gdiplusstartup icon loadimage menuitemfrompoint mf_bycommand mn_gethmenu olecreatepictureindirect setbkcolor setwindowshookex wh_callwndproc wh_getmessage win32 menus windowfrompoint wm_create
    • Replies: 44
    • Forum: Excel Questions
  8. 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...
    • Jaafar Tribak
    • Thread
    • activateactctx binary createwindowex getdlgitem gettempfilename gwl_wndproc hcbt_activate hyperlink initcommoncontrolsex isuseranadmin lm_setitem manifest movewindow msgbox screentoclient setwindowlongptra setwindowshookex shellexecute syslink wh_cbt wm_ctlcolordlg wm_ctlcolorstatic
    • Replies: 31
    • Forum: Excel Questions
  9. 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...
    • Jaafar Tribak
    • Thread
    • beginpaint countdown createiconfromresourceex drawicon getcapture getclassname getdlgitem gettickcount gradientfill gwl_wndproc hcbt_createwnd invalidaterect lwa_alpha playsound popup safearraygetdim setlayeredwindowattributes setwindowshookex shell popup timeout msgbox ws_ex_layered
    • Replies: 13
    • Forum: General Discussion & Other Applications
  10. 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...
    • Jaafar Tribak
    • Thread
    • 256 chars createwindowex edit control em_getlinecount em_setlimittext es_multiline getdlgitem getfromclipboard getwindowtextlength gwlp_hwndparent gwl_wndproc hcbt_activate hiword initcommoncontrols inputbox loword makedword setwindowshookex showwindowasync swp_framechanged sysreallocstringlen tooltip tooltips_class32 ttm_addtool ttm_trackposition ttm_updatetiptext tts_balloon wh_cbt wm_getfont ws_tabstop
    • Replies: 4
    • Forum: Excel Questions
  11. 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...
    • Jaafar Tribak
    • Thread
    • addressof backcolor beginpaint bitblt createcompatiblebitmap createrectrgn cuiautomation currentboundingrectangle cwpstruct drawfocusrect drawtext fillrgn fontcolor gdipdrawpolygon gdipdrawrectangle gdipsetsmoothingmode getstockobject movetoex multipage objptr olecreatepictureindirect setprop setwindowshookex setwindowsubclass translatecolor userform wm_create wm_paint
    • Replies: 4
    • Forum: Excel Questions
  12. 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...
    • Jaafar Tribak
    • Thread
    • clsidfromstring getwindowthreadprocessid iunknown mouseeventf_wheel onmousewheelscroll registeractiveobject revokeactiveobject setwindowshookex wh_mouse_ll withevents wm_mousewheel
    • Replies: 40
    • Forum: Excel Questions
  13. C

    "SetWindowsHookEx" Crashing Excel x64

    Hello. For a while I've been using the MsgBoxCB sub from Dan Elgaard (www.EXCELGAARD.dk) 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...
    • carlobatusi
    • Thread
    • 64 bit excel crash excel 2016 excel 2019 msgbox setwindowshookex vba
    • Replies: 3
    • Forum: Excel Questions
  14. 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 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