Mouseover Textbox for Changing Cells

P

peter.d.yang

Hi all,

I'm trying to figure out how to insert mouseovers but for dynamically changing cells.

There is a column where it's a ID identifier (e.g., A, B, C) and they all have long descriptions. The idea with having a mouseover is that it would show the description once I hover over so that I don't have to have another column.

This column of ID identifiers can change value (for example, it may become C instead of an A) so the mouseover would need to recognize the new value and show the new description accordingly.

Is there a simple way to do this (ideally without VBA)? If not, I still would appreciate direction.

Thank you!
 
C

Claus Busch

Hi Peter,

Am Mon, 10 Mar 2014 10:15:40 -0700 (PDT) schrieb (e-mail address removed):
There is a column where it's a ID identifier (e.g., A, B, C) and they all have long descriptions. The idea with having a mouseover is that it would show the description once I hover over so that I don't have to have another column.

This column of ID identifiers can change value (for example, it may become C instead of an A) so the mouseover would need to recognize the new value and show the new description accordingly.

try it with comments. The changing of the comment text you have to do
with VBA.
Look here:
https://onedrive.live.com/?cid=9378...#cid=9378AAB6121822A3&id=9378AAB6121822A3!326
for the workbook "Comments".
Right click and downlod it, because macros are disabled in OneDrive


Regards
Claus B.
 
P

peter.d.yang

Thanks Claus for your response.

I'm trying to find a way though to do this without manually insert a comment for every single cell (I have 100+). There are 43 unique IDs.

It's also like I'm doing Conditional Formatting: when the cell shows "A", I want a certain description to show.

Do you have a recommendation as to how I could achieve this?

Thanks so much thus far!!
 
G

GS

Thanks Claus for your response.
I'm trying to find a way though to do this without manually insert a
comment for every single cell (I have 100+). There are 43 unique IDs.

This is why Claus suggested using VBA, so the process happens
automatically via worksheet events!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 
P

peter.d.yang

That's my fault for not understanding.
Thanks! I'm very new though with VBA, so would I extract the code from there?
 
C

Claus Busch

Hi Peter,

Am Mon, 10 Mar 2014 11:06:40 -0700 (PDT) schrieb (e-mail address removed):
I'm trying to find a way though to do this without manually insert a comment for every single cell (I have 100+). There are 43 unique IDs.

the comment will be inserted automatically.
It's also like I'm doing Conditional Formatting: when the cell shows "A", I want a certain description to show.

IMO is that not possible with CF.


Regards
Claus B.
 
P

peter.d.yang

Thanks Claus. The conditional formatting bit was just to give an example of what I was trying to do.

I'll try to figure out how to insert the code. Thank you!
 
C

Claus Busch

Hi Peter,

Am Mon, 10 Mar 2014 11:10:43 -0700 (PDT) schrieb (e-mail address removed):
I'm very new though with VBA, so would I extract the code from there?

im my workbook right click on sheet tab => Show Code and copy the code.
Right click on your sheet tab => Show code and paste the code.
Modify the column name to suit for your sheet


Regards
Claus B.
 
P

peter.d.yang

Thanks Klaus. I think I am almost there!

I added "names" to define my characters, and posted the code to my worksheet as you recommended.

I also edited my range from A:A to H:H (since my column is H).

However, I keep on getting this error to debug:

myStr = Range("_" & .Value)

Am I supposed to edit the range in the "_" as well?
 
C

Claus Busch

Hi Peter,

Am Mon, 10 Mar 2014 11:51:34 -0700 (PDT) schrieb (e-mail address removed):
myStr = Range("_" & .Value)

Am I supposed to edit the range in the "_" as well?

some characters are not allowed for names. That the code handles all
range names the same I added a leading "_" to the names.
Have a look into the name manager.
E.g. name for A is _A, for B is it _B


Regards
Claus B.
 
C

Claus Busch

Hi Peter,

Am Mon, 10 Mar 2014 11:51:34 -0700 (PDT) schrieb (e-mail address removed):
Am I supposed to edit the range in the "_" as well?

you can create the range names automatically also. Can you send me the
workbook with all IDs and the descriptions for these IDs?


Regards
Claus B.
 
P

peter.d.yang

Absolutely - thank you Claus. How can I send you this file?

Just FYI - I did try to add names with your "_" in front of my ID - but it still was having this error.
 
C

Claus Busch

Hi Peter,

Am Mon, 10 Mar 2014 12:06:44 -0700 (PDT) schrieb (e-mail address removed):
How can I send you this file?

send it to my mail address
claus_busch[at]t-online.de

Regards
Claus B.
 
P

peter.d.yang

Just wanted to openly thank Claus for being so helpful today.

Much appreciated!

Hi Peter,



Am Mon, 10 Mar 2014 12:06:44 -0700 (PDT) schrieb (e-mail address removed):


How can I send you this file?



send it to my mail address

claus_busch[at]t-online.de



Regards

Claus B.

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top