![]() And i'm not seeing that option in Callouts. I like that my TxtBx + Arrow groups actually have arrows because I think it looks better graphically. I'm at a point where I need to make a decision, and I'd like two things if you'd be so generous to offer either:ġ) A general recommendation about whether I should just switch to callouts instead of my own custom creations. Now, I'm just about at the point where I want to switch to actual "callouts" in my templates, but I haven't messed with them enough to know if they might be more trouble than my own hodgepodge "custom callout" composed of a textbox and a single line arrow connected at one of the four nodes (positions) that I then group and name accordingly. What's the best way to get a handle on the text boxes that are actually a mixture of a textbox and an arrow that I've grouped and named? I decided on the textbox + arrow before I realized how much a pain in the *** the grouping stuff was going to be. I've been working in VBA for like 10 years now, but shapes and things related to shapes are not my strong suit. ![]() So anyway, when I executed the vba script, i noticed that the objects that lay within groups are no longer (apparently) members of the shapes collection. Plus, I can resize every template textbox by referring to range dimensions which I know will not change unless I directly modify them (which may also be done by code! yay!) Shp.Height = ThisWorkbook.Sheets("FORMS TEMPLATE").Range("TB_ACTUAL_SIZE").HeightĪside: I've noticed that sometimes after copying objects or clicking some buttons in excel, the objects/controls change sizes a tiny bit, but over time they can change alot. Shp.Width = ThisWorkbook.Sheets("FORMS TEMPLATE").Range("TB_ACTUAL_SIZE").Width If shp.name Like "TB*" And (shp.name Like "*UP" Or shp.name Like "*LEFT" Or shp.name Like "*RIGHT" Or shp.name Like "*DOWN") Then For Each shp In ThisWorkbook.Sheets("FORMS TEMPLATE").Shapes
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |