UDF to Fetch Comment Text in Excel Cell
In this article, you will learn how to create a UDF to Fetch Comment Text in Excel Cell VBA to get the comment text from an Excel Cell. Let’s say we
Blogs
Spotlight Visualization in Excel (Part-2)
This is the second part of Spotlight visualization. Here we have used spotlight to highlight top performer in the chart. We have created a Column Chart for Team Manager wise
Spotlight Visualization in Excel (Part-1)
This is the first part of Spotlight visualization in excel Here we have used RAG (Red, Amber and Green) color code to display metric performance like – Service Level, Quality Score
VBA User form for Segregate data into multiple worksheets
Many times, we require to segregate our data into different worksheets. Here we have created a VBA User form which can segregate your data into worksheets. One user from will
Shell Function in VBA with Example
Shell function in VBA is very useful. If you want to start a program or open a executable file then you can use shell function in VBA . In this
Login Form for Excel VBA based Application
Login Form is very important for any application. We have designed this Login form in VBA User form and connected with MS Access Database. We have used ADODB Connection to
Custom Visual: Liquid Fill Gauge in Power BI
Liquid Fill Gauge is very beautiful Custom visual for Power BI. You can use this chart to display metrics like – Service Level, Quality Score, Sales conversion etc. You can
Stylish Traffic Lights in Excel
You can create very attracting info-graphics with the help of Auto shapes. Here we are giving an example of this. We have created stylish and beautiful Traffic lights in Excel.
PDF to Word Converter Macro in Excel VBA
In this article we will tell how you can develop your own PDF to Word converter using Excel VBA. You can convert multiple files using this macro. Keep all your
33 Useful VBA Shortcut Keys
Keyboard Shortcut Keys can improve your productivity. In this article we will tell you 33 useful VBA shortcut keys. If you are a VBA developer or work on VBA frequently