Auto Refresh Listview table after Keydown event VBA, Yelp!

Hi all,

Help me please, I don't know whats wrong with the code. I attach my file, if you need to review the code.

I'm working with listview here. I use dummy data, to make it more simpler. I want my listview autorefresh whenever i press F1 (to refer to 2nd database), and F2 (to refer back to 1st database), the default need to show 1st database

see below pic, table B5:D25 (beige), is the 1st database. and G5:I16 (blue) is the 2nd database

Listview.JPG

I want to show the listview listitems, like this

if G1 (yellow) was blank, indicated by H1 (istext = false), then

show 1st database

else G1 (yellow) was filled, indicated by H1 (istext = true)

show 2nd database

and here's my current code,

telling if
press F1, selection item will be copied to G1 - Listview gonna refreshed and showed 2nd database.
press F2, content/text in G1 will be deleted - listview gonna refreshed and showed 1st database

currently
1. when first time running, 1st database wasn't showed, press alt/shift/ctrl will showed them

2. the listview not immediately refreshed after press F1, need to press alt/shift/ctrl to refresh

3. the listview not immediately refreshed after press F2, need to press alt/shift/ctrl to refresh

4. i can't use up/down key direction to select within the listview.

Please Login or Register  to view this content.

Mucho gracias,
Thanks a lot for the help

Hi radian,

Find attached the workbook with working code.
i will try to explain the changes

1. you could not use up/down key to navigate cause that is a keydown event and triggered this part which loaded table 1 or 2 again

Please Login or Register  to view this content.

2. I added the call of table 1 in the initialize of the form so it gets shown immidiately

3. i removed this part

Please Login or Register  to view this content.

and added the call for table1 and two directly in the if section of f1 and f2 key. and then replaced the exit sub part in the F1 section with exit for

Originally Posted by LordLoki

Hi radian,

Find attached the workbook with working code.
i will try to explain the changes

1. you could not use up/down key to navigate cause that is a keydown event and triggered this part which loaded table 1 or 2 again

Please Login or Register  to view this content.

2. I added the call of table 1 in the initialize of the form so it gets shown immidiately

3. i removed this part

Please Login or Register  to view this content.

and added the call for table1 and two directly in the if section of f1 and f2 key. and then replaced the exit sub part in the F1 section with exit for

Hi LordLoki,

sorry for late reply, i don't receive email for your reply to my thread,
It's work! and awesome, i don't know it would be this simple :D

thanks a lot so much, you made my day
regards

Originally Posted by LordLoki

Hi radian,

Find attached the workbook with working code.
i will try to explain the changes

1. you could not use up/down key to navigate cause that is a keydown event and triggered this part which loaded table 1 or 2 again

Please Login or Register  to view this content.

2. I added the call of table 1 in the initialize of the form so it gets shown immidiately

3. i removed this part

Please Login or Register  to view this content.

and added the call for table1 and two directly in the if section of f1 and f2 key. and then replaced the exit sub part in the F1 section with exit for

Hi Loki,

sorry, I had another problem coming, and it's similar when you added exit for in the code.

I made my userform floating when the file open with

Please Login or Register  to view this content.

but, when i press F1 it didn't show the tabel2 (i change your code, when press F1 will call tabel2), instead I need to press ctrl or alt or shift + F1 to made it happen.

can you help me figure the logic? I attached the file

listview call macro to display different table .xlsm

thanks a lot for the 2nd help

Hi Radian,

Apperently the F1 Key does not trigger the keydown event when the Window is modeless
Just change F1 to F3 or another key then it should do just fine.

Greets
Loki

Originally Posted by LordLoki

Hi Radian,

Apperently the F1 Key does not trigger the keydown event when the Window is modeless
Just change F1 to F3 or another key then it should do just fine.

Greets
Loki

Hi LordLoki

well NOTED, just tried with F7, and it works just fine... thanks a lot for the help