How to get mouse hover effect and display full-data.

Question

I get the search results by text search box marcro.

( 1st : search in column B, 2nd : search in this sheet. )

There's two additional issues

1. After I get the search result, I edit the row ( delete, move up/down, cut and paste ) by autohotkey.

If I get the mouse hover effect (selecting a cell in Column B or putting a mouse show the datas of close upperside or downside datas ), it's so helpful for me to decide what to do.

ex. my hope :

When I mouse hover in B2093, the mouse hover effect show the rows of 2090~2096.

I can the datas of close upperside or downside datas by ctrl+f. but it's so difficult for me to edit the datas.

and I prefer the view of the macro.

2. After seeing the datas by mouse hover effects,

I want to move the real datas for editing by a hotkey(tab, enter, space, ...)

How can I solve the problems? Thanks for any help in advance.

file : https://1drv.ms/x/s!AhkzsJojv6t1imqrLmb\_XJJxi9w-?e=b5aA39

Answer 1

Although sitting around coding for three months is not my favorite activity, however I familiar with vba, C, and understand some Assembly Macro Language.

I don't think the mouse hover will be a good solution for the following reasons (the loop will lag the heck out of excel, plus the vba macro will have to dynamically generate a screenshot image for it to display a magnified version of the selected dataset image+the animation and runs in an interpreter environment not compiled) the link below will explain:

9 quick tips to improve your VBA macro performance - Microsoft Tech Community

See Tips numbers 2,3,4,5, and 6

However, the following asks are possible:

I edit the row ( delete, move up/down, cut and paste ) by autohotkey. (not tab, enter and space) and move an entire row to an inserted blank row

Hopefully one or more of the vba experts around here will see this post and assists you with this endeavor since I do not like to spend my time coding. Its fun to read about it though and can give underlying insights.

cheers

Answer 2

Here is a blog that is more aligned to what you're trying to do in excel and vba:

Excel Advanced Filter – Employee Database - Online PC Learning

it has a step by step video tutorial

it has parts 1 through 3

check it out.

cheers

Answer 3

Thanks for your tip. ^^

I'll review it.