Consulting

Results 1 to 4 of 4

Thread: Solved: Using spreadsheet with a userform activated

  1. 10-12-2010, 11:51 AM #1
    YasserKhalil
    YasserKhalil is offline
    VBAX Expert
    Joined
    May 2010
    Posts
    661

    Solved: Using spreadsheet with a userform activated

    Hi everyone
    Can I use the spreadsheet while the userform is activated???
    Reply With Quote Reply With Quote
  2. 10-12-2010, 12:10 PM #2
    Kenneth Hobs
    Kenneth Hobs is offline
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,956
    Location
    Set the userform's ShowModal property to False.
    Reply With Quote Reply With Quote
  3. 10-12-2010, 12:11 PM #3
    CharlesH
    CharlesH is offline
    VBAX Regular
    Joined
    Oct 2010
    Posts
    73
    Location
    Hi,

    Set the usemform property "ShowModal" to False.
    This will allow you to enter info in the worksheet while the Userform is in view.
    My Time is valuable. The forum's time is valuable.
    So take time to say "Thanks"

    As with all programs there may be an easier way!
    CharlesH
    Reply With Quote Reply With Quote
  4. 10-13-2010, 04:19 AM #4
    YasserKhalil
    YasserKhalil is offline
    VBAX Expert
    Joined
    May 2010
    Posts
    661
    Thank you very much
    I appreciate your efforts and your time
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules