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?
Bookmarks