setwindowsubclass

  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

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

    Zooming on Images (Drawing with GDIPlus + Subclassing with comctl32.dll)

    Hi, I have lately been doing some research on the subject of how to use the GDI+ library for drawing in vba. One thing I wanted to do was to be able to perform smooth zooming on userform images (The native userform zoom property is no good as it doesn't keep the image in the center and moves...
    • Jaafar Tribak
    • Thread
    • argb beginpaint comctl32 copymemory defsubclassproc gdipcreatehbitmapfrombitmap gdipcreatepen1 gdipdrawrectangle gdipgraphicsclear gdiplus ismodal iunknown_getwindow modeless redrawwindow setwindowsubclass stdpicture subclassing translatecolor userform wm_mousewheel zoom zooming
    • Replies: 1
    • 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