userform listbox info on mouseover.

[jacobsoo]

Hi all,

Is there a way to get info from an column (that's not in the RowSource of the listbox on my userfrom) when I move over the line with the mouse.
Or in other words, I would like to have the option when I move over an item in my "rowcourse" populated listbox, in my userform that I get some info from an different column. The listbox shows me the most relevant info, and that's in A1:C28. But there is additional info in G1:G28.

I was reading some treads about tooltips etc and also about API stuff, but to be honest my VBA knowledge is not that good.

Any of you have a good tip or info for me ?

Regards Olaf.

[davesexcel]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Andy Pope]

take the simple approach and limit the display information to 4 columns

Please Login or Register  to view this content.

[jacobsoo]

take the simple approach and limit the display information to 4 columns

Please Login or Register  to view this content.

Hello,

I tried the way U say Andy, but to update the listbox while i am ticking my checkboxes, I use the rowsource method in the toolbox.
In this listbox rowsource is not included the source of the additional info i would like to display on mouse over.
The rowsource for the listbox is in A1:G28 while the additional info is in G1:G28.

The file attached is a sample based on my sheet. The sheet is a small book with a tab for every monthly payments i have to do etc. When I (you) open the userform the userform will be displayed on top of all active window's using windows API settings (this was out a different post.) Basic I use this file to do all my online payments while using my bank account and this sheet/userform on top of it. But some times i would like to check the payment details witch are in column G1:G28. So instead of switching back to normal view of the sheet it would like to see this data with the option mouse over.

When the userform is working the way I like it to work I will redesign the sheet it self, and create a database style instead of one sheet for each month, like it is right now.

my-sample.xls

[Andy Pope]

the attached did not include the code I posted.

Please Login or Register  to view this content.

When I add this to the userform, and make the form itself a little wider, I see the existing 3 columns plus contents of column G. No need for complex API stuff. And the checkbox connection still functions.

[jacobsoo]

Correct Andy, but in that case I can also keep using the rowsource for filling the list, but instead of using the range A1:C28 use the A1:G28 as fill range. And in the toolbox keep using the column width property for setting the correct size etc. I use the rowsource so the value of the sheet is constantly updated to the listbox when any of the checkbox value changes. If I use the VBA code to fill/populate the listbox it wouldn't update the list real time, only till I switch back and forward with the userform.

And like I said, for me it would be really superb to have it working under a kind of mouseover effect

ps I use the API windows setting to keep it constant on top, so when i do the banking it stays on top and I can fill in the banking page form while reading/finding it out my sheet. Most of the contacts are already in my banking contact list. But like most of the time the payment details change, and just to double check these numbers I would like to display them the way I try now. Also the other option to make the list wider is not an option, due to the page settings from my bank

Maybe Im asking to much

[Andy Pope]

I'm not suggesting you use code to populate the listbox item at a time.

I'm saying widen the RowSource and hide the columns not required. In the attached I have commented out the application resizing and TopMost API as there is no code to restore state.

[jacobsoo]

Thanks Andy,

I see what you mean, but due to the size and window layout of my bank it's not possible to make the userform any wider. Maybe a couple of mm but that's it. I am just thinking of a total different approach and that is to call a extra listbox with the value's of the last column.

[Andy Pope]

Here is a non API example.

Skinny userform and floating tooltip

[jacobsoo]

Andy Pope, I don't know what to say

All I did was just adjust the frame with label, so I still can tick the checkboxes. And reinstalled that API code. And this is exactly what I was looking for, perfect thanks a lot.



Regards Olaf.

Up to the next chapter, create an data base so it is all on a single sheet including an recall form. Any way excel has the future

[jacobsoo]

Hi,

One more question to this tread, how can i set the value of the Tooltip / textbox in the part of mouse_move, so it displays also the cell format.
Is there any option to that.

[Andy Pope]

What do you mean by cell format?

[jacobsoo]

The value of a cell is now in the tooltip, but in some of the cell's is a number value/format and some is a currency value/format.
And when i go over the item's in the listbox (what still works perfectly, thanks for that) it only show's me the numeric value of the cell. So I have bin staring at it for a while, $#%@# around with it for a while but after all I just can't figure it out to get it to display me the value including the € sign when needed.

[Andy Pope]

you need to format the text using the same formatting applied on the worksheet.

Please Login or Register  to view this content.

[jacobsoo]

Thanks again.