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

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" wrote in
message ...

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

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!

--
pianoma
-----------------------------------------------------------------------
pianoman's Profile: http://www.excelforum.com/member.php...fo&userid=3371
View this thread: http://www.excelforum.com/showthread.php?threadid=53585

pianoman Wrote:
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


--
pianoman
------------------------------------------------------------------------
pianoman's Profile: http://www.excelforum.com/member.php...o&userid=33712
View this thread: http://www.excelforum.com/showthread...hreadid=535856