PDA

View Full Version : [SOLVED] Help edit data in listview via two Dtpickers



djemy1975
03-13-2016, 04:00 AM
Good morning sirs,

I would be grateful if someone could help me get over this proble.I want to edit data in listview via two Dtpickers to enter two dates in two column is there any way to do this.

Herewith my form to have a clear idea

djemy1975
03-14-2016, 01:03 AM
Good morning,
I have modified my form to make it easier for any one who is willing to help me

What I want is to display a record in listview in textboxes in order to edit it and save in both listview and sheet keeping the same conditional formatting applied on it.

- enter to dates on listview and on sheet column BR and BS consecutively .

Please help me I am stuck for more than 2 days in this problem.

Herewith my form modified

Thanks in advance,

p45cal
04-03-2016, 07:03 PM
Have a play with the attached.
Too many changes to code and userform to list them.
The caption Annullée I think is spelt wrongly, I believe it should be Annulée (only one letter L). So if you change this caption you will need to search the code for annullée and change to annulée (Instances of this word in the code are intentionally all lower case.)

djemy1975
04-04-2016, 12:22 AM
Dear p45cal,

I am so pleased to receive a reply from your part and it is working as a charm .

Thank you very much

I am now stuck in another problem in copying a range into another sheet in this thread:

http://www.vbaexpress.com/forum/showthread.php?55622-copy-data-from-a-range-in-sheet-into-rows-in-another-sheet (http://www.vbaexpress.com/forum/showthread.php?55622-copy-data-from-a-range-in-sheet-into-rows-in-another-sheet)

Could you help me please

Thanks in advance,