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
Best
Please Login or Register to view this content.
Tried :
Please Login or Register to view this content.
Last edited by travelkid; 03-15-2019 at 03:58 AM.
It's not exactly clear from your post what you're trying to achieve so I'm guessing here.
Try:
BSBPlease Login or Register to view this content.
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.
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
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
Maybe this:
BSBPlease Login or Register to view this content.
Another one. Select value to delete in Listbox before pressing button.
Please Login or Register to view this content.
Last edited by bakerman2; 03-15-2019 at 06:40 AM.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Nächster Code unter der Löschtaste.
Please Login or Register to view this content.
Click the * Add Reputation below to say thanks.
Used the one from badly spelled buoy, which works fine. Thanks.
Glad I could help.
Don't forget to mark the thread as SOLVED if you're happy you have a working solution.
BSB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks