Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Excelcior
-
Rename controls in a UserForm
Well, well well well They said it couldn't be done, but between combo and PHV I was (am!) able to rename my controls via program!!! For me the problem is solved. Thanks 1000000 Tek-Tips (I gave a * to both PHV and combo). For Tony Jollens, when I want to import my User Form into a running VBA...- Excelcior
- Post #14
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Rename controls in a UserForm
Again, thanks for the input. I wrote a quick and dirty syntaxer (token analyzer) so I am not worried that I have e.g. fooBtn and fooButton in the same module. I know which controls I have to rename and what the names have to be. However, Combo, can you tell me what VBIDE is and how I access it...- Excelcior
- Post #11
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Rename controls in a UserForm
Thanks for your input. I *do* realize that the doc says you *cannot* change the .Name property under execution. Here's the scenario: Company B buys company A and inherits all its software including several Excel based VBA applications with lots of forms and bokoo controls. Ah, but Company B...- Excelcior
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Rename controls in a UserForm
Does anyone know how to rename a Control other than by using the VB Forms Editor? I have a form with several hundred controls and I want to rename most of them. The doc correctly tells me that you can't change the .Name property during execution :( I don't want to retype them all by hand. Is...- Excelcior
- Thread
- Replies: 14
- Forum: VBA Visual Basic for Applications (Microsoft)
