Anusree
10-01-2010, 12:50 AM
Hi,
I have created a drop down in A1 of sheet1 using the below code:
Set rng = Worksheets("sheet1").Range("A1")
Set lb = Sheet1.DropDowns.Add(Left:=rng.Left, Top:=rng.Top, Width:=rng.Width, Height:=rng.Height, Editable:=False)
lb.AddItem "Hai....I would like to read books on fiction."
lb.AddItem "Hai....I would like to read short stories."
lb.AddItem "Hai....I would like to read novels."
When i try to read the first entry of the drop down, i am not able to see the entire text which is present there because the size of the dropdown matches with the size of the cell but does not match with the length of the first entry. That is,
When i try to read "Hai....I would like to read books on fiction." which is the first entry, I can see only till "Hai....I " because of size problem i mentioned above.
My requirement:
Whenever i keep mouse over an entry in the dropdown, i want to show the full content to the user. Is there any way i could achieve this?
Regards,
Anu
I have created a drop down in A1 of sheet1 using the below code:
Set rng = Worksheets("sheet1").Range("A1")
Set lb = Sheet1.DropDowns.Add(Left:=rng.Left, Top:=rng.Top, Width:=rng.Width, Height:=rng.Height, Editable:=False)
lb.AddItem "Hai....I would like to read books on fiction."
lb.AddItem "Hai....I would like to read short stories."
lb.AddItem "Hai....I would like to read novels."
When i try to read the first entry of the drop down, i am not able to see the entire text which is present there because the size of the dropdown matches with the size of the cell but does not match with the length of the first entry. That is,
When i try to read "Hai....I would like to read books on fiction." which is the first entry, I can see only till "Hai....I " because of size problem i mentioned above.
My requirement:
Whenever i keep mouse over an entry in the dropdown, i want to show the full content to the user. Is there any way i could achieve this?
Regards,
Anu