asked on

another question on http://www.experts-exchange.com/questions/28843339/

I have changed the date format on column 1 from 09/25/2015 to 09-25-2016 like column 3
Ihave a form with an mshflexgrid that opens a Calendar form to the date on the cell selected
the calendar then returns the new seleted date to the cell selected
this works fine on the dates in the 3rd column, but i need it to also work on the first column
how can this be done ?

Martin Liss

If after clicking in column 1 you want the new date to show up in column 3 then all you need to do is to change this in label1_Click

If (frmReminder.gridMaster.Col = 3 And frmReminder.gridMaster.Text <> "" Then

Open in new window

   If (frmReminder.gridMaster.Col = 3 Or frmReminder.gridMaster.Col = 1) And frmReminder.gridMaster.Text <> "" Then

Open in new window

isnoend2001

ASKER

I don't want the new date to be put into column 3. I want it to be put into the same cell that is clicked in column 1

ASKER CERTIFIED SOLUTION

Martin Liss

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

isnoend2001

ASKER

Thank you
don't have time to test now have to run an error for a couple hours

isnoend2001

ASKER

Ran into an issue if clicking column 3 in the grid and selecting a different year. the new year is not put into the cell on further testing selecting a different month does not work either

Martin Liss

You said you were planning on posting a new question about selecting the date in the calendar. I can solve the above along with a couple of other problems there.

isnoend2001

ASKER

I will post the queston now