How to insert VBA Calendar or Date Picker Add-in in Excel 2010

Topbullets.com Today I got a challenge to provide a new function in Excel dashboard. I am not an expert in VBA and have very less experience but it’s fun doing coding in VBA. It makes excel function so simpler that I really loved it. My few lines of code helped me to reduce 3 hours manual work to only 5 minutes. Thanks to Microsoft for providing such a powerful tool. Continue reading

Advertisements

How to remove star icon from notification bar in Android Lolipop

Topbullets.com I have recently bought Yuphoria. It’s a low cost phone but having lot of features. This is the first time I am using Cyanogen and Lolipop too. There are lots of new features which I haven’t tried yet. Recently I put my phone on silent while I was in a meeting and then did normal mode. Even after normal mode my phone was not ringing while incoming calls, no notification sound. I increased the ringing volume to full, rebooted it but nothing happened. I thought phone got damaged. Then I saw a white star icon on notification bar and thought this could be the reason. I Googled it and read somewhere that this is related to ‘Interruption’ but didn’t find any perfect solution. Then I looked into my phone and fixed it. Continue reading

Rank() Over Partition by in R – Easiest Method to Follow

Topbullets.comCurrently I am working on R, SAS and SQL languages and recently I came across a new problem. I want to rank my data set on particular columns. Ranking on a single column is very easy but when it comes for multiple columns, it becomes little tough. I Googled my problem, searched for entire day but could not find any satisfactory solution.
Finally I made my own way and it really worked. Here is the solution to this problem. Continue reading

How to Disable/Enable USB File Transfer MTP Port in Android Mobile Phone

Topbullets.comToday I have been trying to charge my mobile from my company’s pc and every time I was getting notification from “Symactec Endpoint Protection” that “USB Cable has been disabled”. It was very annoying. My company PC always takes screen shots if we violet any IT rule. So it was little risky. I thought of disabling the USB share port and Google how to do it. Many bloggers have written different solutions but no one really worked. I tried every options in settings but failed to do so. Finally I got one.
I have been using Android 4.2.2 and there are no such kind of options which different bloggers provided. So here I tried something new on my own and it really worked. Continue reading

15 VLC Media Player Shortcuts You Should Know About

Topbullets.comVLC is supposed to be the most used media player in the world. In my last post, I had mentioned about ‘How to…’ and got huge response from Google. Today I would like to share some shortcut and features which VLC provides. These features are very useful as most of us don’t know. The post could also be helpful who are looking for ‘How to adjust audio in VLC’, ‘How to adjust subtitle in VLC’, ‘How to control speed of subtitle in VLC’, ‘How to control speed of Audio in VLC’, ‘How to take snapshot in VLC’, ’Useful shortcuts in VLC’, ‘How to adjust Audio delay in VLC’. Continue reading