![]() I can't use OLEobjects or shapes, because they are not supporting the properties I would like to assign. I would like to use a For loop (For i = 1 to n) so I can assign specific properties to every Image(i) and Label(i) in the worsksheet, according to the specific index (i). ActiveX Controls are many labels and images in a sheet, and they have sequential names (i.e. ![]() I am trying to assign properties to Activex Controls in a worksheet, using VBA code. Is this possible through Excel VBA code using OLEobjects or Shapes or any other object that accepts to have a variable name in the code, so that this variable name can change with a For loop, replicating in sequence all the names of the ActiveX Controls I want to format? ![]() I want to manage ActiveX properties of many ActiveX controls on a worksheet (for instance image1.picture or other similar properties).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |