February 2018 - Tactical Process Automation

Home
About

Tactical Process Automation

Home
About
Videos
Downloads

20180212

VBA

Excel VBA - Use Collection Object in Userform ListBox

Ajay 01:52

Create a Userform with Listbox showing the unique items from available large data Excel. Userform in Excel are very dynamic view and u...

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Labels: Collection in Excel, Color Coding in excel Userform, How to use Date and time functions in userform, Userform in Excel, VBA

20180204

VBA

How to Highlight Lowest or Highest Value in Excel

Ajay 01:52

Highlight Lowest or Highest Value in your Data Set using VBA Script. It is normally required to highlight the lowest value or highest val...

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Labels: Color Coding in excel, Conditional Formatting, Excel Range, how to highlight lowest value, VBA

Newer Posts Older Posts Home

Search This Blog

Reverse String using Excel VBA

Normally this is an interview question being asked by company technical recruiters. This is an logical question and every aspirants must b...

Contact

Name

Email *

Message *

Total Pageviews

Powered By Blogger

March (1)
August (1)
July (1)
April (3)
March (4)
February (2)
January (3)
December (6)
November (18)

Labels

VBA Excel Advance Functions Advance Excel Macro Excel Dashboard Excel Nested function Excel automation Excel Excel 2013 Logical Function MS Excel excel formulas Conditional Formatting Excel Range Excel functions Collection in Excel Color Coding in excel Data Analysis Data handling Date & time functions Dynamic Name Range INDEX Statistical functions for-Next loop tactical automation Create Name Range Data Validation Error Handling LOOPs Split String in Excel User Defined Functions User defined Data Type

Recent

Popular

Caculate GPA-CGPA in Excel

GPA and CGPA concept is used to evaluate the performance of students in many institution across globe. Every country has is own methodolog...
Create Named Range in Excel

Create Dynamic named ranges in Excel and use them in formulas, data validations dynamically. There are multiples ways to create the name...
Calculate Percentile in Excel

Percentile in Statistics is method of evaluation individuals performance in a group or set of people. Percentile is not the ranking positi...
Low Cost Automation

Tactical Automation is low cost approach for business units that helps to ease manual efforts by automating the process steps with the hel...
Business Process Automation

Business Process Automation (BPA) is the strategic process to automate the manual efforts used to run the business. Process Automation is ...

Comments

Blog Archive

Designed with by Way2Themes | Distributed By Best Blogger Themes