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!


---
Regards,
Norman



"pianoman" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> pianoman
> ------------------------------------------------------------------------
> pianoman's Profile:
> http://www.excelforum.com/member.php...o&userid=33712
> View this thread: http://www.excelforum.com/showthread...hreadid=535856
>

[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!?

[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