VBA controls are ...uncontrollable
Posted on 2007-07-30
I'm having issues with controls on an excel worksheet. There are too many to shift to a form at this point but I am having issues when I use a projector...has something to do with the difference in resolution between my screen and the overhead projector screen res. My either grow incrementally or shrink incrementally whenever a user clicks on them. I have been able to control their size using conditional statements in VBA, stating if the control is not the proper width, then adjust the width and height to the correct value.
but even though I fix that, the fontsize is still incorrect. how can I control this? I tried
Shapes("shp1").texteffect.fontsize = 10 but that would not work.
so now I was thinking, maybe if a control could not be clicked on, it would not have these problems. is there a way to control that? like a control_Mouse_Down event? ...something to release the focus before it happens? any ideas?
I have a similar question out there, but this question has more detail and is meant to get to the bottom of my issues. I know using a form is better, but I can't make the transition to that just yet...and I still need to utilize other features on the worksheet.