Excel 2007 : Allow blank fields in userform

[kmcarter]

I have a userform to populate 11 goals. When I update, all fields need to be entered. Otherwise, if I leave one of the goals blank the current value is replaced with a blank cell.

This is the code for my userform:

Please Login or Register  to view this content.

I would like the ability to update a few of the values without replacing the existing values.

[royUK]

Your code is not necessarly unprotecting the dashboard sheet.

I think you want to amend entries, is that right?

Start by looking at the DatabaseForm example