Hello dear Excel Help,
I would like to change properites of a group of the buttons on useform upon condition. I can't figure it out. For example I have userform named 'UserForm1' with buttons named 'but1', 'but2', 'but3', 'dut1', 'dut2'. How woud I change properties of buttons 'but'?
I tried this Debug.Print UserForm1.Controls(1).name which gives me name of first button, but is seems that no properties can be changed like UserForm1.Controls(1),method.
I would also like to change properties of multiple Userfrosm and their buttons at once. With following code I can display properties of arbitrary object, but I don't know how to change them.:
Bellow I provided another function so that you can see my reasoning. I think of all objects in excel as multidimensional matrix and I would like to be able to slice or filter this matrix. Is it possible? I am trying to program this functionality, but without success yet. Maybe I will have to resort to string execute. I am afraid it won't work either.Please Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks