hi,
I have a better way If you have a series of controls that you would like to
format
the same way...suggest you name the textbox txtbxname_1 (_1) becomes our
unique identifyer)
for each.
if right(object.name,4) = _1 then
next
next
On Sun, Apr 5, 2009 at 8:46 PM, Ashish Jain
Hi Vincent
It seems more like sharing information - and we dnt find any other way
to do this at runtime. If you've plz share with us.
Regards
Ashish Jain
On Apr 2, 6:09 pm, Yu vincent2...@gmail.com wrote:
Hi Dear all,
I have this puzzle for a long time. I often program UserForm and
Hi,
I'm not sure if this would work with forms, but when I put multiple text boxes
on a worksheet, I can change them all with the following code:
ActiveSheet.Shapes.Range(Array(Text Box 1, Text Box 2, Text Box
3)).Select
Selection.ShapeRange.Height = 84.75