-
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.
createwindowex
-
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...- Jaafar Tribak
- Thread
- createwindowex dispcallfunc getmodulehandle getprocaddress getrawinputdata interface rawinput setwindowshookex virtualprotect wh_keyboard
- Replies: 0
- Forum: Excel Questions
-
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
-
Monitoring the Windows Shell ___ [Files and Folders activity]
Hi all, I have been toying around with the shell notification apis in order to be able to monitor file activity in folders such as creating, deleting , renaming, copying, updating files & folders etc ... I thought I would post here what I have come up with in case someone finds it useful. The...- Jaafar Tribak
- Thread
- cotaskmemfree createwindowex csidl_desktop getprop ilcreatefrompath iunknown_getwindow monitoring shchangenotification_lock shchangenotifyregister shcne_allevents shgetspecialfolderlocation shnotifystruct static wm_shnotify ws_minimizebox
- Replies: 3
- Forum: Excel Questions
-
Grouping UserForms [Having userforms follow each other when moved around the screen]
Hi, This is a vba code that hopefully accomplishes what the title of the thread says. Obviously, the forms must be modeless so that the user can freely move from one form to aanother. Problem is, using modeless forms makes this task difficult as we cannot subclass modeless forms to properly...- Jaafar Tribak
- Thread
- accessiblechildren accessibleobjectfromwindow acclocation bm_getcheck bs_autocheckbox createwindowex drawtext dt_calcrect dwmiscompositionenabled getasynckeystate group gwl_hwndparent gwl_userdata htclose iaccessible iidfromstring intersectrect iunknown_getwindow lwa_colorkey ptinrect settimer sm_cycaption systemparametersinfo userform windowfrompoint ws_ex_layered
- Replies: 6
- Forum: Excel Questions
-
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
-
MultiColor + Drag N Drop ListBox Class (Win32)
Hi all, MultiColorDragList.xlsm I have been experimentng with the Comctl32 Listbox control in the last few days. The final result looks good BUT there are two major limitations which I should mention upfront beofre getting too excited. 1- ListBoxes can only be added to MODAL UserFoms. 2- No...- Jaafar Tribak
- Thread
- bitblt createiconfromresourceex createwindowex defsubclassproc drawinsert drawtext frame getasynckeystate getdevicecaps interface iunknown_getwindow lbitemfrompt lbs_hasstrings lbs_notify lbs_ownerdrawvariable makedraglist mapvirtualkey raiseevent screentoclient setwindowpos setwineventhook tooltip translatecolor
- Replies: 8
- Forum: Excel Questions
-
Animated GIF placed on the UserForm Title Bar (Pseudo-Icon)
Hi, For a static icon, sending the WM_SETICON to the UserForm window is the standard way and it is straightforward. However, for an animated icon, we would need to use multiple images\frames and periodically alternate them in a timer procedure or in a loop. This can become quite tedious and has...- Jaafar Tribak
- Thread
- animated gif atlaxgetcontrol atlaxwininit createwindowex gwl_hwndparent icon innerhtml iunknown_getwindow spi_getnonclientmetrics systemparametersinfo webbrowser wm_seticon ws_ex_toolwindow ws_popup
- Replies: 21
- Forum: Excel Questions
-
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
-
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
-
Dragging Controls - Unleashing the power of VBA with Win32 API programming.
This little project took me hours and hours to complete but I think was worthy if only for the learning experience. The project as such won't be of much use to most excel users but its shows that vba can do all kinds of neat things when combined with the win32 API. This is what the code does...- Jaafar Tribak
- Thread
- createiconfromresourceex createwindowex dragging dwmgetwindowattribute extcreatepen gdipcreatebitmapfromhbitmap lwa_alpha mouse move screentoclient setlayeredwindowattributes setwindowrgn ss_bitmap ws_ex_layered
- Replies: 1
- Forum: Excel Questions
-
Round Buttons
Hi all, Workbook Example I have just finished this project which hopefully will enable excel users to add functional round buttons to their userforms ... The AddRoundButton routine is what does the job ... This routine contains 13 arguments each of which will hold an attribute of the button...- Jaafar Tribak
- Thread
- combinergn createwindowex ptvisible selectcliprgn
- Replies: 3
- Forum: Excel Questions
