U

UDFs (user-defined functions), 75

Add, 76-77 BookOpen, 77-78 CellColor, 84-87 ColName, 101 ContainsText, 98 DateTime, 81 FirstNonZeroLength, 91 GetAddress, 100 IsEmailValid, 82-83 LastSaved, 81 MSubstitute, 92-93 MyFullName, 77 MyName, 77 NumFilesInCurDir, 79 NumUniqueValues, 88 RetrieveNumbers, 93 ReturnMaxs, 99-100 ReverseContents, 99 SheetExists, 78-79 SortConcat, 95-96 sorter, 97-98 state_period, 102 StaticRAND, 101 StringElement, 94-95

SumColor, 83-84 Textcolor, 87-88 UniqueValues, 89-90 Weekday, 94 WinUserName, 79-81 UDTs (user-defined types), 429-432

Ungroup command

(UserForm toolbar), 433 Uniform Size command (UserForm toolbar), 433

Union function, 68-69 unique list of values, extracting

Advanced Filter dialog box, 208

AdvancedFilter function, 209

CancelButton_Click()

function, 212 cbSubAll_Click() function, 212

cbSubClear_Click()

function, 212 GetUniqueCustomers()

function, 210 multiple field values,

214-215 OKButton_Click() function, 212

RevenueByCustomers()

function, 211 ShowCustForm() function, 213

single column list ranges,

208-209 UniqueCustomerRedux()

function, 210 UserForm_Initialize() function, 213

Unique Records Only feature (Advanced Filter), 226

unique values, counting, 88 UniqueCustomerProduct() function, 214-215

UniqueCustomerRedux()

function, 210 UniqueProductsOneCustom er() function, 216

UniqueValues() function, 89-90

Unload() function, 163 unloading UserForms, 163 UnselectAll() function, 434 Until clause, 111-112 Update() function, 405

updating records, 408-409 Web queries, 333

UseBookmarks() function, 372

UseGetObject() function, 363

user interaction functions, 161-162 user-defined functions. See UDFs user-defined types. See UDTs

UserForm command (Insert menu), 162

UserForm toolbar, 433

UserForms. See forms

UserForm_Activate() function, 449

UserForm_Initialize() function, 213, 222-223, 408, 435-437, 444-446, 459 userIDs, 80-81

UserName() function, 454-455

0 0

Post a comment