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,
Dear Ashish,
Thanks Ashish, awesome micro.
On Sat, Mar 8, 2014 at 6:30 PM, ashish koul koul.ash...@gmail.com wrote:
try this
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count = 1 And Target.Column = 1 Then
On Error Resume Next
Hi Expert,
Is there no way to do that?
On Fri, Mar 7, 2014 at 9:57 AM, Rupesh Patil patil.rupesh1...@gmail.comwrote:
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
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
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