trouble with rollovers

[williajc]

hello,
This is my first post, I think I am in the right area. I found some other posts that deal with rollover text but none quite apply to what I am looking to accomplish.

I have a list of four letter codes on sheet one, in sheet two I have a list of what those alpha codes translate into; I am trying to come up with a way that when my cursor is on the alpha code it pops up with the full name.

I have attached a sample of the complete file. any help with this would be very helpful, i don't start with VB prgramming until next semester so please expalin any VB code you might suggest.

thank you,
John

[shg]

Doing it on mouseover would be way complicated. Doing it on cell selection, and showing the full text in the StatusBar (LL corner of the window) would be easy. If that's an OK approach, I or someone else will show you how.

I'm moving this thread to the Programming forum.

Also, please read the forum rules about thread titles before starting your next thread. Threads with a title like this are routinely closed.

[williajc]

Shg,
Thank you for the warning about the thread title, I am sorry and will work at following the guidelines more closely next time.

As to using the status bar that would be fine, I can explain to the end users where to find the name at.

If anyone can help with this type of coding it would be greatly appreciated.

Thanks

[shg]

See attached.

Edit: Never mind, forum is having problems.

Reaarrange Sheet2 to have abbreviations in the first column and full names in the second.

Right-click on the Raw Data tab, select View Code, and paste this:

Please Login or Register  to view this content.

Close all that out to return to Excel, and then select a cell in col D and look at the Status Bar.

[williajc]

shg,

thank you for your reply, it works perfectly. Since receiving your help I have been trying to do the same thing with several columns doing the same thing.

I am missing how to tie it together. here is what i have tried so far:

Please Login or Register  to view this content.

My second attempt was trying to nest them:

Please Login or Register  to view this content.

I am sure I am missing something easy, anyone who could help would be great. I have attached an exemplar of the data I am working with

[shg]

1. There's no code in the workbook you posted.

2. On the alpha codes tab, the data is not arranged in the two-column format suggested in post#4.

3. What are you trying to do?

[williajc]

I am sorry, getting caught between two finals projects and missed the code.

I am trying to accomplish the samething as before only with column E but i would like to have it work concurrent with the first bit of code that works for the alpha codes.

I have made sure that the code is in the sheet this time.
Thank you for your help

[shg]

So what do you want to do with a selection in column 5?

[williajc]

Yes,

I am sorry I am not explaining this well.

so the finished product would have two columns, that, when selected would show the full text in the status bar. it would be column D & E or 4 & 5 (not sure which way is more correct).

thank you for being patient shg

[shg]

Try replacing all the code with this:

Please Login or Register  to view this content.

[williajc]

shg,

thanks for the code, it didn't work though, I am not sure why. I was going to give you the entire workbook but apperntly it is too big, so here is another sample. if you could look at it again i would really appreciate it. it does have your code in it.

Thank you

[shg]

Before I look at anything knew, explain 'didn't work.'

In all this, I am left to guess what you actually want.

[williajc]

The orignal code that you gave me to show alpha codes in the status bar did exactly that. when in column 4 it pulls information from sheet two and then displays that in the status bar, eg ACFL : Acadian Flycatcher.

I am now trying to replicate that piece of code for column 5 so that when that cell is active/clicked upon, it pulls information from the sheet named Age Codes (I believe that it is sheet 3) and then, like the alpha codes it also displays information in the status bar, eg 6 : After Hatch Year.

this way any user does not have to go between sheets, the information is always displayed in the status bar of Sheet 1.

Currently with the last bit of code you gave me the status bar will display the information in it asked but when moving to a different Column it does not refresh.

I hope i have explained it well, I really appreciate your help. I am sorry that i can't explain it better.

[shg]

I am now trying to replicate that piece of code for column 5 so that when that cell is active/clicked upon, it pulls information from the sheet named Age Codes (I believe that it is sheet 3) and then, like the alpha codes it also displays information in the status bar, eg 6 : After Hatch Year.

THAT was the piece I was missing. Replace all with this:

Please Login or Register  to view this content.

[shg]

BTW, you might put data validation in col E (Whole number, 1 to 6), and paste this in the data validation input message:

1: After-hatch year
2: Hatch-year
4: Local
5: Second year
6: After-second year
7: Third year
8: After-third year

[williajc]

shg,
thanks for being sooo patient with me, I truly appreciate it.

As for the validation? I am not sure what you mean by this.

will this make the the data more easily read?

thanks again for your help

[shg]

Data > Validation. On the Settings tab, select List, and in in the Source box, enter 1,2,3,4,5,6. In the Input Message box, paste

1: After-hatch year
2: Hatch-year
4: Local
5: Second year
6: After-second year
7: Third year
8: After-third year

You'll get a drop-down list when you select a cell in that column.

---------------------------------


If you are satisfied with the solution provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save