I have had two instances with a spreadhsheet that I'm working on where code wasn't functioning as it should be. I can't recall the first item, but the second one is currently occurring and I have no idea why. Basically, I'm trying to draw focus to specific frames as people enter/select data, with the next frame in the series being highlighted in red. Here's the code:
The code was only changing the foreground color to red but not the border. I went back and inserted message boxes to step into the formatting (now commented out) and it worked perfectly. Does anyone have any idea why this might be occurring?Please Login or Register to view this content.
Bookmarks