Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

excel macro discombobulation


  • Please log in to reply

#1
dsenette

dsenette

    Je suis Napoléon!

  • Administrator
  • 26,019 posts
  • MVP
alright fellers (and feller-ettes)...i've got an ODD quandry here with an excel macro...anyone who wants a stab...let's see what you can figure out

ok here's the scenario:

we've got this training sheet (attached) that the supervisors use to track training and competency. whatever raving lunatic who decided to make this thing...decided to use the method of having little circles divided into quadrants, and the way you mark someone as being trained or at a specific level in each section is to change that quadrant's color to green (if they aren't there yet...then it stays white). as you could imagine this get's pretty tedious...

i've created two macros that are initiated by two buttons in the top left of the worksheet (yes and clear) the yes one will turn any selected shape (i.e. quadrants of the circles) green, and the clear one will change any selected shape back to white....this might be a little easier for these guys to do...but what i REALLY want is to be able to assign a macro to EACH quadrant on the sheet (fun for me right?) that will allow them to simply click the quadrant to turn it green...it would be great if it could check the quadrant's status and act accordingly (i.e. if the quadrant is white it changes to green...if it's green it changes to white)...but that's not neccessary right now.

i did find a way to do this by assigning the macro to change a specific group (that makes up one of the quadrants)...but i'd have to modify that macro for EACH deal...and any time they added a new sheet or whatever...i don't like that plan at all

any takers?
  • 0

Advertisements







Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP