settimer

  1. 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...
  2. Jaafar Tribak

    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 objid_titlebar peekmessage ptinrect settimer sm_cycaption systemparametersinfo userform windowfrompoint wm_nclbuttondown ws_ex_layered
    • Replies: 6
    • Forum: Excel Questions
  3. 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
  4. Jaafar Tribak

    Excel Screen Reader Upon Navigating With The Mouse (with VBA alone)

    Hi all, This is an attempt to simulate the Windows built-in screen-reader narrator but, done with vba alone. The code is supposed to read-back the type of object currently under the mouse pointer and, if applicable, to read the object caption\text\value as well. The code lets you choose a...
    • Jaafar Tribak
    • Thread
    • accessibleobjectfrompoint cocreateinstance currentclassname currentlocalisedcontroltype dispcallfunc elementfrompoint executeexcel4macro getcursorpos getdescription iaccessible iuiautomation narrator sapi.spvoice set.name settimer sysreallocstring texttospeech voice
    • Replies: 7
    • Forum: Excel Questions
  5. 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...
  6. T

    VBA Application.OnTime issues

    I have a shared file on a LAN. I borrowed some code online to kick out idle users (who presumably forgot to get out of the file). I tweaked it a bit so that it puts them to read-only instead of kicking them out altogether (not sure if it exhibited the undesirable behavior I'm about to...
  7. Jaafar Tribak

    A Cool Generic ToolTip Class for Worksheet ActiveX Controls

    Workbook Demo Hi Excellers, As the title says, this is a Class that creates ToolTips for worksheet controls .. The tooltips are made out of office AutoShapes Some of its fun features : 1- Works for all controls except for Spin and ScrollBrar controls 2- You can create a tooltip for different...

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