hcbt_activate

  1. Jaafar Tribak

    VBA MsgBox customized to display data in tabular format _ (Data arranged in straight rows and columns)

    Hi all, As you probably know, displaying text data arranged/aligned in straight columns inside the standard vba MsgBox is extremely difficult. I personally have never seen this done before... Calculating the msgbox font size is a nightmare. Here, I am using a few api-based workarounds to...
    • Jaafar Tribak
    • Thread
    • beginpaint createwindowex fillrect gettextmetrics hcbt_activate hiword icc_listview_classes initcommoncontrolsex listview lvm_approximateviewrect lvm_first lvm_getitemcount lvm_getitemrect lvm_settextbkcolor lvs_nocolumnheader msgbox paintstruct removewindowsubclass scrollbars setwindowsubclass syslistview32 tabular msgbox textmetric wm_paint wm_rbuttondown
    • Replies: 5
    • Forum: General Discussion & Other Applications
  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...
    • 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
  3. 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
  4. 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

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