00:00I've got another Excel tip you will love and enjoy. This time it involves creating a customized pop-up bubble that will display the detail of the records your cursor is currently hovering over. Want to learn to do this? Let's go. The first thing you have to do is to insert a rectangle with rounded corners and then position anywhere on your spreadsheet. Then after that let's give this rectangle a name called bubble and let's give this rectangle also some characters by introducing some shadows.
00:27Next launch the VBA editor by right clicking and selecting view code and after that change this to worksheet and you should have a new subroutine here. Once that's done use this VBA script. If you need a copy of this VBA script please leave a comment on the comment section below. In a nutshell this is the area you can customize. This section here determines whether you are clicking within the data set range. If it's outside the data set range the bubble will disappear. This section it populates your bubble with the text and this positions your bubble on your spreadsheet. After that press ctrl s to save. Close the VBA editor.
00:57And you can now test your bubble and you can now test your bubble.
