Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. huiettcm

    Catching the Mouse Click Error in Modal User Form

    Good morning! I'll start with the the goal. I have an excel workbook for data collection. The user can enter data using a form. The user can also edit entries, which brings the data back into the form. I'd like the user to be able to open multiple forms at once. The issue is that the mouse...
  2. huiettcm

    Excel UserForm Window 'Focus' Event Listener

    Solved with a click event. On click I compare the mouse position with the user form's. If the mouse is outside a user form and the user form is modal then excel redraws the form as modeless. Same in reverse. So the user can control which form has the mouse scroll with a click.
  3. huiettcm

    Excel UserForm Window 'Focus' Event Listener

    I think what I want to accomplish is fundamentally flawed. When multiple userforms are open, if the top form is Modal the other forms are locked. I don't think the WM_NCACTIVATE message can get sent by clicking on a window's header.
  4. huiettcm

    Excel UserForm Window 'Focus' Event Listener

    to use multiple tabs, I'd have to dynamically create the same form on multiple tabs. IDK about that. Interesting. Maybe set up a mulit-tab form as a frame for the data entry form..... I have traced my problem in the updated attached workbook. The problem is in the support code module...
  5. huiettcm

    Excel UserForm Window 'Focus' Event Listener

    I thought I had updated those calls. They should have the Me qualifier at the end. I'll fix that and repost.
  6. huiettcm

    Excel UserForm Window 'Focus' Event Listener

    @combo. Data is collected through the included form. Submitting the form spreads the data across 4 worksheets. Editing brings the data from those worksheets back into the form. I'd like to be able to open multiple forms at once for editing...and with mouse scroll enabled. All of my API calls...
  7. huiettcm

    Excel UserForm Window 'Focus' Event Listener

    That file should be good. The modules are broken up and named the capability they perform. I think the issue is in the DE_Form code somewhere in the formFocus_ChangeListener, or in the formFocus module. However, the edit module is where the data form collection is...
  8. huiettcm

    Excel UserForm Window 'Focus' Event Listener

    Of course. I'll post it once I've gone through and cleaned it up.
  9. huiettcm

    Excel UserForm Window 'Focus' Event Listener

    I appologize. I thought it was clear that the code doesn't work. Rereading the post, I obviously forgot to add what the problem is. I am having a hard time diagnosing why the code doesn't work because Excel crashes. Even when I set break points and they hit, excel will crash and I can't watch...
  10. huiettcm

    Excel UserForm Window 'Focus' Event Listener

    thread707-1747946 I am trying to open multiple user forms in excel for a data collection project. The user can select entries to edit and the data is brough into the form. I can open multiple forms 'vbModeless' however this looses the mouse scroll control (as that class ans support module...

Part and Inventory Search

Back
Top