+ Reply to Thread
Results 1 to 2 of 2

A userform that allows me to work on my excel even if it is active?

  1. #1
    Forum Contributor
    Join Date
    12-03-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    107

    A userform that allows me to work on my excel even if it is active?

    I have a userform that calls up data on a database, the information shown in the userform helps the user in finishing his/her costing sheet. A minor drawback in my userform is that the user cannot edit the costing sheet while the userform is active. So they have to close the form, edit the sheet, activate the userform, get the data, close the userform, edit the sheet, and so on.

    Is there a property in userform that will allow my costing sheet to be editable even if the userform is active?

  2. #2
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: A userform that allows me to work on my excel even if it is active?

    hi kjy1989, it should be shown as modeless:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. how can worksheet_activate event of active sheet work of active workbook
    By tahir mahmood in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-20-2011, 08:19 AM
  2. How to get Excel to remember what sheet was active before opening userform
    By kala1928 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-17-2010, 04:00 AM
  3. Workbooks.Count doesn't work when excel cell is active
    By nivanov in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-05-2009, 12:58 PM
  4. UserForm Active
    By grahammal in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-03-2006, 12:29 PM
  5. Excel VBA: Move Userform Based on Active Cell?
    By Dale Maggee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2005, 03:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1