How can I change programatically the caption(s) of all (ActiveX) controls on a worksheet (NOT a UserForm)?
I know how to do it in VBA for just ONE control, but I can't figure it out for ALL controls at the same time.
The purpose is to change the captions when the user selects a radio button (Dutch or French) to select the language for the control captions.
I have made a separate worksheet containing 3 columns:
- control names
- Dutch text of the controls captions
- French translation of the controls captions
Each row contains the strings for each control.
The text of the captions must be searched in that worksheet mentioned above using Application.WorksheetFunction.VLookup.
Any help would be greatly appreciated.
Thanks
redseujac
Bookmarks