Index[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Z] UDFs (User-Defined Functions) critical details function library add-ins IFERROR making appear native naming conventions unregistering VBA UIS 2nd (user interface support) layer ulFlags element UNC paths unique indexes unobtrusive validation unstructured ranges UPDATE statement (SQL)updating datauser IDs finding user interface support (UIS) layer User-Defined Debug modeUser-Defined Functions [See UDFs] user-defined types 2nd naming conventions user-interface tier user32.exeUserform_Initialize event SetUserformAppearance procedure userforms business logic controls accelerator keys ComboBox data binding data validation event handling layering naming positioning 2nd Windows Common Controls 2nd default instances vs. classes disabling the Close button displaying graphics dynamic userforms code-created/table-driven userforms 2nd 3rd dynamic control event handling and control arrays scroll regions subset userforms error handling demo 2nd 3rd 4th exposing properties and methods hiding vs. unloading locking vs. disabling controls modeless combining with menu items progress bars splash screens popup menuspositioning next to a cell property procedures resizable responding to resolutions simplicity splitter bars UIS layer 2nd 3rd window styles wizard dialogs creating design rules |