Built in Data Form

[pianoman]

Hi All,
I'm re-posting this request in case people think I'm sorted after the
last post!

I would still very mucjh appreciate some code for a form almost
identical to the built in form, but which includes a drop down box for
one of the fields, while retaining the add/delete record and Edit
function, and also greying out the formula fields when editing/adding
records. The Jwalk version is also very close, but doesn't allow you
to edit existing records...

Thanks,

Gareth

 

[Norman Jones]

Hi Pianoman,

The Jwalk version is also very close, but doesn't allow you
to edit existing records...

John Walkenbach's enhanced data form certainly allows existing records to be
edited: simply select the required record field and edit it!

 

[pianoman]

But how do you save the edit to the sheet? In the built in form, yo
just hit enter and the cell value changes... in the Jwalk version,
can't make it transfer the new values over... what have I missed!

 

[pianoman]

But how do you save the edit to the sheet? In the built in form, you
just hit enter and the cell value changes... in the Jwalk version, I
can't make it transfer the new values over... what have I missed!?

Prompted by your reply, I've had an other look and cracked it!

If you do the edit, you have to move onto another record before
exiting... the change is then made, not perfect, but close!

Thanks