-
To pull data from Access to VBA on Multi selected variables from the list box
Hi,
I'm trying to pull the data from the access database based on the list box selection. For single select it is working fine, but for multiselect, I'm not able to get it
For single select i'm using the below index formula ( which refers number D) , and using the sql query "strSQL = strSQL & "Market = '" & wksSumMenu.Range("B3").Value" filtering the data from the access database.
=INDEX(B$5:B$10,MATCH(1,C$5:C$10,0))
For multiple select could you suggest me some logic on how to solve it.
Number |
List box selected |
A |
0 |
B |
0 |
C |
0 |
D |
1 |
E |
1 |
F |
0 |
Thanks a lot for your help
Regards,
Ajay
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules