Multiple Cells properties alter using one command

[inq80]

Hi,

I'm using the code below in alter the appearance of a new entry into a table using a userform. I'm changing each cell individually though - is there a way of doing all the cells using one line?

Please Login or Register  to view this content.

thanks

[inq80]

might as well add something to this which just came up:

I need the value of "firstBlank.Offset(0, 8)" to be the sum of the value added in firstBlank.Offset(0, 3) + firstBlank.Offset(0, 4), minus the value of Now() which is named on the sheet.

I've tried

Please Login or Register  to view this content.

but it doesn't recognise the "EntryForm.txtDateDue" or "EntryForm.txtTimeDue" values

how do i refer to them so excel recognises it?

thanks

[inq80]

Anyone?