Friends, I want that when i type in excel sheet it should merge the cells automatically. For example as I start typing from cell no A1 and continue typing to cell no E1 then the range from A1 to E1 should automatically be merged. Moreover I want to assign tooltip to the new customized buttons. In fact I have inserted two ActiveX control buttons in excel sheet and have assigned vba codes to those buttons to do specific task. In addition to it I have added those buttons in home tab by FILE-OPTIONS-CUSTOMIZE RIBBON. Now I want tooltip for those two button on home tab. Please help me. Thanks.