Text Box hide & unhinde with mouse?
 

How do i Attach th text box on the right hand side corner of the sheet and
hide it their and when i take mouse their it comes out.

Text Box hide & unhinde with mouse?
 

Cannot be done in Excel with just a 'mouse-over'. Could be done with VBA
(macro) using Worksheet_SelectionChange() event. You would have to click on
a particular cell to make it come out (become visible).

"Anand vijay" wrote:

How do i Attach th text box on the right hand side corner of the sheet and
hide it their and when i take mouse their it comes out.

Text Box hide & unhinde with mouse?
 

how do i do that with the help of cell

"JLatham" wrote:

Cannot be done in Excel with just a 'mouse-over'. Could be done with VBA
(macro) using Worksheet_SelectionChange() event. You would have to click on
a particular cell to make it come out (become visible).

"Anand vijay" wrote:

How do i Attach th text box on the right hand side corner of the sheet and
hide it their and when i take mouse their it comes out.

Text Box hide & unhinde with mouse?
 

Hi,

I hope I understand the OP correctly but not entirely sure what he/she really wants.

I would appreciate your comments on my idea.

1. Draw a rectangle inside a cell (using the drawing toolbar).
2. Right click on the rectangle, then Format AutoShape to remove the lines (colors and lines tab) to get the "hidden" effect.
3. Right click on the rectangle to insert hyperlink, link to the same worksheet.
4. Click on ScreenTip and type in text.

The text will not be seen unless "mouse-over" happens.

Just a thought. Have I missed anything? If I am totally off, have a good laugh.

Epinn

"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ...
Cannot be done in Excel with just a 'mouse-over'. Could be done with VBA
(macro) using Worksheet_SelectionChange() event. You would have to click on
a particular cell to make it come out (become visible).

"Anand vijay" wrote:

How do i Attach th text box on the right hand side corner of the sheet and
hide it their and when i take mouse their it comes out.

Text Box hide & unhinde with mouse?
 

See Epinn's possible solution below.

"Anand vijay" wrote:

how do i do that with the help of cell

"JLatham" wrote:

Cannot be done in Excel with just a 'mouse-over'. Could be done with VBA
(macro) using Worksheet_SelectionChange() event. You would have to click on
a particular cell to make it come out (become visible).

"Anand vijay" wrote:

How do i Attach th text box on the right hand side corner of the sheet and
hide it their and when i take mouse their it comes out.

Text Box hide & unhinde with mouse?
 

You may be on to something. I'd taken it to mean a text box as in a control.
So how about we wait until Anand vijay replies to your possible solution?
Always helps to get a different view of such things - I often seem to guess
wrong or miss offering alternative solutions. Thanks for joining in.

"Epinn" wrote:

Hi,

I hope I understand the OP correctly but not entirely sure what he/she really wants.

I would appreciate your comments on my idea.

1. Draw a rectangle inside a cell (using the drawing toolbar).
2. Right click on the rectangle, then Format AutoShape to remove the lines (colors and lines tab) to get the "hidden" effect.
3. Right click on the rectangle to insert hyperlink, link to the same worksheet.
4. Click on ScreenTip and type in text.

The text will not be seen unless "mouse-over" happens.

Just a thought. Have I missed anything? If I am totally off, have a good laugh.

Epinn

"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ...
Cannot be done in Excel with just a 'mouse-over'. Could be done with VBA
(macro) using Worksheet_SelectionChange() event. You would have to click on
a particular cell to make it come out (become visible).

"Anand vijay" wrote:

How do i Attach th text box on the right hand side corner of the sheet and
hide it their and when i take mouse their it comes out.

Text Box hide & unhinde with mouse?
 

You can attach a Comment in a cell. Everytime you move your mouse to that
cell the comment will pop-up.


"Anand vijay" wrote:

How do i Attach th text box on the right hand side corner of the sheet and
hide it their and when i take mouse their it comes out.

Text Box hide & unhinde with mouse?
 

well , I am not able to create hyperlink in the Text Box. I think you guys
need to first tell me how do i create hyperlink in the text box.

"Epinn" wrote:

Hi,

I hope I understand the OP correctly but not entirely sure what he/she really wants.

I would appreciate your comments on my idea.

1. Draw a rectangle inside a cell (using the drawing toolbar).
2. Right click on the rectangle, then Format AutoShape to remove the lines (colors and lines tab) to get the "hidden" effect.
3. Right click on the rectangle to insert hyperlink, link to the same worksheet.
4. Click on ScreenTip and type in text.

The text will not be seen unless "mouse-over" happens.

Just a thought. Have I missed anything? If I am totally off, have a good laugh.

Epinn

"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ...
Cannot be done in Excel with just a 'mouse-over'. Could be done with VBA
(macro) using Worksheet_SelectionChange() event. You would have to click on
a particular cell to make it come out (become visible).

"Anand vijay" wrote:

How do i Attach th text box on the right hand side corner of the sheet and
hide it their and when i take mouse their it comes out.

Text Box hide & unhinde with mouse?
 

Thank you for your encouragement. I like mama's solution which I have totally forgotten. Like you, I was focusing on textbox/autoshapes. The best thing about comments is that the cell is flagged with a red triangle. Let's hope the OP can give us some feedback.

Wish you a Happy and Healthy 2007.

Epinn

"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ...
You may be on to something. I'd taken it to mean a text box as in a control.
So how about we wait until Anand vijay replies to your possible solution?
Always helps to get a different view of such things - I often seem to guess
wrong or miss offering alternative solutions. Thanks for joining in.

"Epinn" wrote:

Hi,

I hope I understand the OP correctly but not entirely sure what he/she really wants.

I would appreciate your comments on my idea.

1. Draw a rectangle inside a cell (using the drawing toolbar).
2. Right click on the rectangle, then Format AutoShape to remove the lines (colors and lines tab) to get the "hidden" effect.
3. Right click on the rectangle to insert hyperlink, link to the same worksheet.
4. Click on ScreenTip and type in text.

The text will not be seen unless "mouse-over" happens.

Just a thought. Have I missed anything? If I am totally off, have a good laugh.

Epinn

"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ...
Cannot be done in Excel with just a 'mouse-over'. Could be done with VBA
(macro) using Worksheet_SelectionChange() event. You would have to click on
a particular cell to make it come out (become visible).

"Anand vijay" wrote:

How do i Attach th text box on the right hand side corner of the sheet and
hide it their and when i take mouse their it comes out.

Text Box hide & unhinde with mouse?
 

I am not able to create hyperlink in the Text Box. <<

As indicated in my response to your other thread, I don't think we can insert hyperlink to a **textbox**. Under this thread, I mentioned about drawing a **rectangle** inside a cell via the drawing toolbar (viewtoolbarsdrawing). In my opinion, a textbox is not the same as a rectangle. Experts, please feel free to correct me if I am wrong.

You may want to try mama's solution which is simpler. If you want to draw a rectangle and still not sure how, post back or search the net.

Good luck!

Epinn

"Anand vijay" wrote in message ...
well , I am not able to create hyperlink in the Text Box. I think you guys
need to first tell me how do i create hyperlink in the text box.

"Epinn" wrote:

Hi,

I hope I understand the OP correctly but not entirely sure what he/she really wants.

I would appreciate your comments on my idea.

1. Draw a rectangle inside a cell (using the drawing toolbar).
2. Right click on the rectangle, then Format AutoShape to remove the lines (colors and lines tab) to get the "hidden" effect.
3. Right click on the rectangle to insert hyperlink, link to the same worksheet.
4. Click on ScreenTip and type in text.

The text will not be seen unless "mouse-over" happens.

Just a thought. Have I missed anything? If I am totally off, have a good laugh.

Epinn

"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ...
Cannot be done in Excel with just a 'mouse-over'. Could be done with VBA
(macro) using Worksheet_SelectionChange() event. You would have to click on
a particular cell to make it come out (become visible).

"Anand vijay" wrote:

How do i Attach th text box on the right hand side corner of the sheet and
hide it their and when i take mouse their it comes out.

Text Box hide & unhinde with mouse?
 

Simple, elegant - and probably the perfect solution as long as no interaction
with the text is required.

"Teethless mama" wrote:

You can attach a Comment in a cell. Everytime you move your mouse to that
cell the comment will pop-up.


"Anand vijay" wrote:

How do i Attach th text box on the right hand side corner of the sheet and
hide it their and when i take mouse their it comes out.