ediing a listbox (in an userform) entry populated by dynamic table

i have a listbox populated from a named dynamic range called

Please Login or Register  to view this content.

data can be added to that table using following code

Please Login or Register  to view this content.

now i want to edit the data using textbox and edit button
when the listbox item is selected, i want textbox 3 and 4 to show corresponding data and after editing the data in textbox 3 or 4 ,
edit command button should edit the selected data from the dynamic range
and new data should be shown in the list box



and also is there a better way to know if day has changed instead of putting data on excel sheet as i have done



i have attached sample file also

1) Formula for dynamic named range should be

Formula:

Please Login or Register  to view this content.

otherwise you always have a blank row at the bottom of the list box.

2)

Please Login or Register  to view this content.

thanks for your reply

that solved the question

and also thanks for help with named range

added reputation