Weblinks Module VBA TUTORIAL LOGIN Hi ,Logout Cond Statements in VBA TestVBA Tutorial – Conditional Statements If…Then…Else Statements Select…Case Statements Text Strings in VBAVBA Tutorial – Text Strings VBA String Functions – Left, Right, Mid, Len, Replace, InStr & InStrRev VBA String Functions – Split, Join, Concatenate Custom Number FormatsVBA Tutorial – Custom Number Formats Custom Number Formats in VBA Excel VBA Built-in EventsVBA Tutorial – Excel Built-in Events Excel VBA Built-in Events Worksheet Change Event Worksheet Selection Change Event ActiveX & Form ControlsVBA Tutorial – ActiveX & Form Controls ActiveX & Form Controls, AutoShapes Application.OnTime MethodVBA Tutorial – Application.OnTime Method Application.OnTime – Schedule Macros MsgBox & InputBox in VBAVBA Tutorial – MsgBox & InputBox in VBA MsgBox & InputBox in VBA Ebook of Excel SolutionsEbook of Excel FormulasExcel Formulas EbookEbook of Excel FormulasUnique List, Sorted in Ascending Order, Appearing in One Column and Not in OtherCount Rows containing Multiple specified ValuesSUM AND / OR Criteria for Multiple ColumnsPosition of First Number in a StringExtract Unique sub-strings of 1st 5 Characters from each column cellCount Maximum Number of Consecutive Occurrences of a ValueSUMIF with Date Range, Multiple Month Names / Numbers & YearExtract Text After Last Occurrence of a Number in a StringExtract Values which appear ONLY once, from a ColumnExcel FunctionsExcel Text and String Functions: TRIM & CLEANASCII Code, Extended ASCII characters (8-bit system) and ANSI Code.Excel CODE & CHAR Functions, VBA Asc & Chr FunctionsExcel Text and String Functions: LEFT, RIGHT, MID, LEN, FIND, SEARCH, REPLACE, SUBSTITUTECHOOSE Function in ExcelExcel IF Function and IF StatementsExcel VLOOKUP FunctionExcel OFFSET FunctionExcel INDIRECT FunctionExcel SUMPRODUCT FunctionExcel Pivot TablesPrinting a Pivot Table Report – ExcelCreate a Pivot Chart in Excel – graphical display of a Pivot TableExcel Pivot Table Design & Layout, Pivot Table StylesExcel Pivot Table Report – Sort Data in Row & Column Labels & in Values Area, use Custom ListsExcel Pivot Tables: Filter Data, Items, Values & DatesExcel Pivot Tables: Insert Calculated Fields & Calculated Items, Create FormulasExcel Pivot Table Report – Summary Functions & Custom Calculations, Insert Calculated Fields or Calculated ItemsExcel Pivot Table Report – Group Items, Group Date and Time ValuesExcel Pivot Table Report – Field Settings, Expand or Collapse Fields & Items, Refresh Data, Change Data Source & Show or Hide optionsExcel Pivot Table Report – Clear All, Remove Filters, Select Mutliple Cells or Items, Move a Pivot TableExcel TipsCase Sensitive Vlookup in Excel; Finding the 1st, 2nd, nth or last occurrence of the Lookup ValueVlookup Multiple Values – Return MULTIPLE corresponding values for ONE Lookup ValueExcel Date and Time Functions and FormulasFind ‘Smallest’, ‘Largest’, ‘K-th Smallest’ and ‘K-th Largest’ Numbers in a RangeRemove Duplicates in a range, using “Remove duplicates” button in Data ToolsRemove Duplicates or Create a List of Unique Records using Excel FormulaRemove Duplicates or Create a List of Unique Records using Advanced Data FilterCount Number of Unique Values in a Range (with Excel Functions)Shade Alternate Rows – Conditional FormattingLeft Lookup with Vlookup Excel FunctionExcel VBAExcel VBA: ActiveX Controls, Form Controls & AutoShapes on a WorksheetChartFormat object – line, fill & effect formatting for chart elements: FillFormat object, LineFormat object, ShadowFormat object, GlowFormat object, SoftEdgeFormat object, ThreeDFormat objectChild Objects common for many chart elements: Border Object, ChartFillFormat Object, Interior Object, Font ObjectChart Elements in Excel VBA (Part 2) – Chart Series, Data Labels, Chart LegendChart Elements in Excel VBA (Part 1) – Chart Title, Chart Area, Plot Area, Chart AxesCharts in Excel VBA – Add a Chart, the Chart object & the ChartObject objectCreate Charts in Excel VBA: Embedded Charts – Line with Markers; Clustered Stacked Column Chart; Clustered Stacked Bar Chart displaying Variance; Pie chart; XY Scatter chart & Bubble chartExcel VBA Debugging Tools in Visual Basic Editor – Breakpoints & Break Mode, Stepping Through Code, Debugging ViewsExcel VBA Errors & Error Handling, On Error & Resume Satements, Exit Statement, Err ObjectExcel VBA Date & Time Functions; Year, Month, Week & Day FunctionsExcelAnytime SiteMy AccountWebsite Use PolicyExcel VBA Online TutorialTestimonials GlobaliConnect.comAbout ExcelAnytime.comExcel VBA Online Tutorial – learn Excel VBA programming & access examples, illustrations, live codes and downloadable filesExcel and VBA ServicesSample Data-ArticlestestGetting StartedTypographyArticle Categories ModuleSearch ModuleJoomla!AuthenticationArticles Category ModuleStatistics ModuleParametersFruit Shop SiteDirectionsFruit ShopHappy Orange OrchardWonderful WatermelonGrowersHappy Orange OrchardWonderful WatermelonJoomla!ParametersEditorsBanner ModuleProfessionalsEditors-xtdCustom HTML ModuleSample SitesSearchFeed DisplayThe Joomla! CommunityExtensionsUsersNews FlashMenu ModuleWeblinksRelated Items ModuleBreadcrumbs ModuleNews FeedsLogin ModuleTypographyWho’s OnlineComponentsUsersWeblinksNews FeedsAdministrator ComponentsContactsContentSearchModulesMost Read ContentWrapper ModuleNews FlashMenu ModuleRelated Items ModuleBreadcrumbs ModuleLogin ModuleWho’s OnlineLatest Users ModuleBanner ModuleContent ModulesMost Read ContentNews FlashRelated Items ModuleArchive ModuleArticle Categories ModuleArticles Category ModuleLatest Articles ModuleDisplay ModulesRandom Image ModuleWeblinks ModuleBanner ModuleCustom HTML ModuleFeed DisplayFooter ModuleNavigation ModulesMenu ModuleBreadcrumbs ModuleUser ModulesLogin ModuleWho’s OnlineLatest Users ModuleUtility ModulesWrapper ModuleLanguage SwitcherSearch ModuleStatistics ModuleSyndicate ModulePluginsSystemUserContentAuthenticationEditorsEditors-xtdSearchTemplatesTypographyPark SitePhyllopteryxSpotted QuollWobbegoneCradle MountainPinnaclesBlue Mountain Rain ForestOrmiston PoundAustralian ParksFirst Blog PostSecond Blog PostPark BlogFirst Blog PostSecond Blog PostPhoto GalleryCradle MountainPinnaclesBlue Mountain Rain ForestOrmiston PoundKoalaPhyllopteryxSpotted QuollWobbegoneAnimalsKoalaPhyllopteryxSpotted QuollWobbegoneSceneryCradle MountainPinnaclesBlue Mountain Rain ForestOrmiston PoundVBATutorial - Cond Stmnts This module displays the list of weblinks in a category. Help {loadposition weblinksload}