Putting Spreadsheet Into Date Order After Submitting Userform

[stuu3270]

Hi again,

Can somebody tell me how I can set the rows of my spreadsheet to go into date order after using the userform?
I have another spreadsheet that makes this happen when switching back via another sheet in the workbook but this file only has one sheet.

Alternatively, if this is not possible, how about a macro for a button on the spreadsheet to re-order according to the date in column C?

Thanks

Stu

[Leith Ross]

Hello stuu3270,

I could tell you but I can't. There is is the small problem. You did not post your workbook. Since I am neither clairvoyant nor a graduate of Hogwart's, I need to review your code the old school way by physically looking at it.

[stuu3270]

Here is one of them. I thought it would be a simple case of putting some code in somewhere to make it happen, as its not part of the userform (or is it?).

I can do it with a command button on the spreadsheet but ideally I would like it to happen automatically upon submission of the data.

Stu

[stuu3270]

Help... Anybody ?