Clear not delete list box entry

[travelkid]

Hi,

I would like to clear not delete rows over a vba user form. How can I tranlate the code below into a code, that I can clear the selected entriy from the list box? Is this even possible without writing a funciton

Please Login or Register  to view this content.

Best




Tried :

Please Login or Register  to view this content.

[BadlySpelledBuoy]

It's not exactly clear from your post what you're trying to achieve so I'm guessing here.

Try:

Please Login or Register  to view this content.

BSB

[travelkid]

This one is not working. I press the button, nothing happens, no error. Are you sure that the quotation marks should be like that? My goal is to simply pick a entry from the list box and clear that entry. I do not want to use the method delete, because this delets the cells.

[BadlySpelledBuoy]

Yes the quotation marks are correct, but that doesn't mean it's the correct solution for you! As I said, it's not clear from your post what you actually want to do here. I'd suggest you attach your workbook so we can better understand the requirement.

BSB

[travelkid]

OKey, here is the workbook. So as you can see you can you can pick a database entry by clicking on the list box. Im trying to delete the entries that are picked with the löschen/delete button.

Best

[BadlySpelledBuoy]

Maybe this:

Please Login or Register  to view this content.

BSB

[bakerman2]

Another one. Select value to delete in Listbox before pressing button.

Please Login or Register  to view this content.

[dotchiejack]

Nächster Code unter der Löschtaste.

Please Login or Register  to view this content.

[travelkid]

Used the one from badly spelled buoy, which works fine. Thanks.

[BadlySpelledBuoy]

Glad I could help.

Don't forget to mark the thread as SOLVED if you're happy you have a working solution.

BSB