Hi,

I have designed a UserForm which is used to add new members but thi
form would be used to edit and delete them as well. So instead o
creating another identical UserForm, I would like to use this one.

PROBLEM


- I have at the moment code that places todays date in a text bo
automatically but it is editable if a member joined before the dat
they enter it onto the system.

This would need to be disabled, so that when viewing a member
details the date joined would not be overriden.
- The caption on the form would change, and an extra button 'Delete
should appear.


Is it possible to set a variable or something so if variable = add the
this if not then this

--
bac
-----------------------------------------------------------------------
bach's Profile: http://www.excelforum.com/member.php...fo&userid=2613
View this thread: http://www.excelforum.com/showthread.php?threadid=46864