+ Reply to Thread
Results 1 to 5 of 5

Create A UserForm that tracks points and allows scrolling and use of worksheet

  1. #1
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Create A UserForm that tracks points and allows scrolling and use of worksheet

    Okay, Here's what I was trying to do. This is for a Tabletop RPG. I think I am way over my head on this one.

    I have event code that changes a cell's contents on double click. When converting from an open circle to a half circle, that constitutes spending points. The player will only have a certain number of points to spend (let's say 35).

    I wanted a user form that consisted entirely of a textbox with the points in it. Each time you converted a circle to half circle, it would subtract the appropriate points from the textbox.

    Problem 1. Once the Userform appears, I can no longer click on the spreadsheet. Is there anyway to have a User form active and still be able to manipulate the spreadsheet?

    Problem 2. I'd like the user form to stay visible as I scroll down the spreadsheet.

    Here's an abridged version of the spreadsheet. (Some sheets are deleted so some formula's won't work). The Event Macro on SkillSheet is where the UserForm would be called up. It's the code at the beginnning of the macro that I "commented" out. It's incomplete (I need to work out how to computate and subtract the points) but I ran into problems 1 and 2 above and thought I might need to switch direction.
    Clear as mud?
    Attached Files Attached Files
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Create A UserForm that tracks points and allows scrolling and use of worksheet

    Have you looked at modeless userforms? (Are you on a Mac?)
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Create A UserForm that tracks points and allows scrolling and use of worksheet

    I am on a PC, currently Excel 2010. I never heard of modeless userforms. I'm self taught so there are many gaps in my knowledge. How does one initiate a modeless UF?

  4. #4
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Create A UserForm that tracks points and allows scrolling and use of worksheet

    Okay, did a google search and now know how. I will play with this. Thanks Mike!

  5. #5
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Create A UserForm that tracks points and allows scrolling and use of worksheet

    Moving on to new difficulties. Will start a new Thread

+ 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. Replies: 3
    Last Post: 11-09-2014, 08:57 PM
  2. [SOLVED] How to create a formula that keep tracks of new value.
    By fadu4u in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 07-31-2014, 10:06 PM
  3. Create worksheet functions within userform
    By melcoats in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-12-2014, 11:16 AM
  4. Scrolling Userform with Headings
    By BillWilts in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-07-2011, 12:55 PM
  5. Scrolling image box in userform.
    By kryt0n in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-13-2010, 06:56 AM
  6. using userform to create a new worksheet
    By mania112 in forum Excel General
    Replies: 1
    Last Post: 08-13-2009, 09:38 PM
  7. I need to create a job task list that tracks for a 30 day period.
    By Job Task tracker in forum Excel General
    Replies: 1
    Last Post: 12-30-2005, 10:10 PM

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