Re: $$Excel-Macros$$ cell tooltip

2014-03-08 Thread Rupesh Patil
Dear Ashish, Thanks Ashish, awesome micro. On Sat, Mar 8, 2014 at 6:30 PM, ashish koul wrote: > try this > > Private Sub Worksheet_SelectionChange(ByVal Target As Range) > If Target.Count = 1 And Target.Column = 1 Then > On Error Resume Next > ActiveSheet.Shapes("displaytext").Delete

Re: $$Excel-Macros$$ cell tooltip

2014-03-08 Thread ashish koul
try this Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Count = 1 And Target.Column = 1 Then On Error Resume Next ActiveSheet.Shapes("displaytext").Delete On Error GoTo 0 Set shp = ActiveSheet.Shapes.AddShape(msoShapeRectangle, Target.Offset(0, 1).Left, Targ

Re: $$Excel-Macros$$ cell tooltip

2014-03-07 Thread Rupesh Patil
Dear Abhishek, I have database for medicines, that data base have columns call side effect and contraindications value of both columns are like five to six line paragraph. If I want to see this side effect and contraindications, I need to press F2, it will visible like paragraph, so each time or

Re: $$Excel-Macros$$ cell tooltip

2014-03-07 Thread Abhishek Jain
Just to help me understand: Why do you want to reflect the value in tooltip when it is already visible in the Cell itself? Do you mean Cell Address instead of Cell Value? Example - Cell Value is "Rupesh" Cell Address is "E2" What do you want to appear in the tool tip? On Fri, Mar 7, 2014 at

Re: $$Excel-Macros$$ cell tooltip

2014-03-07 Thread Rupesh Patil
Hi Expert, Is there no way to do that? On Fri, Mar 7, 2014 at 9:57 AM, Rupesh Patil wrote: > Hi Expert, > > I need your help. how to show cell value as tool tip when mouse over that > cell. > > -- > Thanks and Regards, Rp. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wann

$$Excel-Macros$$ cell tooltip

2014-03-06 Thread Rupesh Patil
Hi Expert, I need your help. how to show cell value as tool tip when mouse over that cell. -- Thanks and Regards, Rp. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discus