Hey all, had a quick question!
I want to do something along the lines of this:
But I want it to be on a userform with a listbox. Listbox1 will contain a list from named range, and i want people to be able to click the desired deleted one, press delete, it will go to Sheet5, find that row and delete it. Is this possible?
Please Login or Register to view this content.
Thanks!
Steve
Steve,
Yes.
Without testing the code, or seeing/understanding the contents of Listbox1, I think the code would look something like this (not much different from what you have).
I generally like to avoid the attribute: .ActiveSheet unless I'm referencing a newly-created worksheet or the worksheet where a macro button you're pushing because it can make the results dependent upon which sheet is active/you have open when the macro runs. But it looks like .ActiveSheet was used appropriately in your code.Please Login or Register to view this content.
Last edited by joe31623; 02-05-2016 at 12:09 PM.
<---If my answer helped, please click *
I think what I was hoping to make it do was have a userform open, which would contain listbox 1. that userform would give a list of names from a table, you woudl select from teh listbox the one you wanted to delete and press the delete button. it would then search a specific worksheet for that text (would be in A column) and delete the entire row.
does that make sense?
Screen Shot 2016-02-05 at 8.31.36 PM.png
hi anyone have an idea how to make this work within a userform like this?
I'm not too familiar with Userforms, but if you give me a cell, range of cells, or a starting cell and continuous column/row of cells, I can do pretty much anything along the lines of what you're asking about.
Please Login or Register to view this content.Please Login or Register to view this content.
See attachedPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks