Dear Forum,
Listbox1 filters data from another sheet into listbox 2
In Listbox 2 I'd like to uptain the cell addres form a filtered item.
However, in the sheet with the filtered data the wanted address should be "B5", but because of the filtercriteria it returns B2.HTML Code:
How can I 'vba' my way out of this and get the wanted result?
Thanks in advance.
Rudy
P.s Needless to say I'm relatively new at VBA
Hello Rudy,
In the interest of time, can you please post a copy of your workbook. Looking back through old posts and code is not going to entice others to help you.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hello Leith,
Adding attachments doesn't seem to work.
Clicking the attachment button results in a small blank line.
Am I missing something?
Regards, Rudy
Hello Rudy,
It is probably not letting you post because you are new. You must have a certain number of posts before you can attach a workbook. Can you post the workbook to a public file share? If you can then you can post the link to the workbook. Otherwise, you can send it to me via email and I'll post it for you.
Hi Leith,
Sorry, I don't know how Public fileshare works. Never done that.
If you don't mind I'd prefer to send the workbook by email.
Do you have an emailaddress for me?
Thanks, Rudy
In case the issue is that you are not using the correct method for attaching... (not saying you are, but there have been issues)
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Another try
Hello Rudy,
I made a few changes to your code to make the cell address in column "A" appear in ListBox2. See the attached workbook.
Hi Leith,
Thank you, the line of code you put in returns the cell address for the item in listbox1, and does that fine.
However, the items in listbox2 have 'a relation' with one item in listbox1, and I would like to get the cell address of the item in row B, sheet2 ("Blad2").
Point is, that when listbox2 filters sheet2, it puts - for example - "Teststraat 5" with "IdAdres" 5 and "IDCls" 5 from B6 to B2, and "Teststraat 5" with "IdAdres" 5 and "IDCls" 6 from B7 to B3,
I'd like to obain the cell address from the item in row B in "Blad2" despite filtering through listbox2.
Does this make any sence?
Regards, Rudy.
Hello Rudy,
I had a 50/50 shot at getting it right. Here is the updated version. This will display the cell address for the row in on "Blad2" as "$B$4:$D$4".
Hello Leith,
And the other 50 percent is a hit :-)
This is exactly what I was looking for.
Thanks very much, also for your prompt replies.
I appreciate it.
Regards, Rudy
Hello Rudy,
Niets te danken! (Not sure if that is correct.) I'm glad to know it is working correctly now.
:-) Right on the nose.
I have one more question in this thread, if I may.
How do I put the column 6 address in a string? As in dim x as string x= ??
Hello Rudy,
You can by declaring a variable as a String Type, since the address of a Range returns a string type. The address can be obtained from the cell or the ListBox.
Please Login or Register to view this content.
Thanks again Leith,
Works like a charm.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks