Thread: VBA Objects
View Single Post
  #3   Report Post  
 
Posts: n/a
Default

Not a class assignment, a work necessity. I've never
studied VBA formally -- learning it on the fly. I have
named all related controls (on a UserForm) with the same
ending. For instance, if I have a label and check box
that go together, they will be named lblXXX and chkXXX.
What I am trying to do is to write a generic subroutine
that would allow me to pass the value of XXX into the
subroutine, and the sub would add the lbl and chk
prefixes to the string and then manipulate the Enabled
and Value properties of those controls. This would be
much more efficient than what I'm writing now --
individual subroutines for each group of controls.

Thanks
-----Original Message-----
And the assignment is due when?

--
Don Guillett
SalesAid Software

"Kevin" wrote in message
...
I need to take a string variable passed into a
subroutine, concatenate it with another string, and

then
have this string represent an object name so I can
manipulate the Enabled and Value properties of the
already existing object.



.