-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
beginpaint
-
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 setwindowsubclass syslistview32 tabular msgbox textmetric wm_paint
- Replies: 5
- Forum: General Discussion & Other Applications
-
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
-
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
-
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
