doble click to modify selected record in listbox and right click to delete

[BLUEPOMME]

hello

i like to have help with vba codes :

i have a listbox in userform4 i like to add a code to use right click to modify record using userform1 (userfrom1 is used to add new data to list)
and to do right click on mouse to delete selected record from list

please see file and original post
http://www.excelforum.com/excel-pro...ord-in-listbox-and-right-click-to-delete.html

thank you

 

[DanteAmor]

Change names by cell range, try:

OK ,

an other question is since i was using a table and new workbook does not , i have an othe sheet that takes information from that table how do i modify formula to make it work without table

how i must change formula to use sheet EVENTOS without table

example:

=IFERROR(INDEX([COLOR=#ff0000]A2:A1000[/COLOR],SMALL(IF(Dates=C$6,ROW(Dates)),ROW(1:1))-TableRowStart,4),"")

 

[BLUEPOMME]

excellent
thank you

 

[DanteAmor]

Youre welcome! And thanks for the feedback.