Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi there, I have nine identical userfoms that each contain over 100 mixed
controls. Each UserForm has it's own name (frmTicket1, frmTicket2, frmTicket3..... to frmTicket9). There are procedures which are located within the UserForms code area with identical procedures with the same names within each UserForm. The references to the worksheets are different but the control references are the same. What I would like to know is it best practice to rename all the controls on each userform, so I don't have any controls or procedure with the same names? This would be a tedious job. If so, is there an easier way to change these control names at design time without having to click on each control and type in a new name? Any reference to a control is done by using the userform name first (frmTicket1.txtBox1.Text= I was just thinking that if I don't need to change all these names... I'm wasting my time. Could someone enlighten me on what the best practice in this situation is? Thanks Craig |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Identical Cells in Multiple Worksheets in one Workbook. | Excel Worksheet Functions | |||
Protection of identical cells on multiple worksheets | Excel Worksheet Functions | |||
Identical Name on multiple workbook pages | Excel Discussion (Misc queries) | |||
look up and append result to row for multiple identical entries | Excel Programming | |||
Inexplicable difference in row hiding speed - identical code, identical machines! | Excel Programming |