Custom data forms in excel

  oxford 22:46 17 Jan 03
  oxford 22:46 17 Jan 03

As a teacher, I have a classlist in excel showing names, marks for homework etc for a class of 20 pupils. I want to run a DATAFORM at the click of a button/macro, in order to add/ delete/ find-next/ find-previous etc and update this list. I can create a userform to add a new member to the bottom of the list, but it doesn't have the same power as a dataform. According to Help, I need to create a CUSTOM Data Form in order for 'ActiveSheet.ShowDataForm' to work. Any ideas on how to do this?
Many thanks,

  VoG™ 23:15 17 Jan 03

Sorry, I don't understand the question. Is this something that you are trying to do in VBA?

If you cannot get a Userform to do what you want, you can always use an old-fashioned Dialog Sheet -Right click a tab, Insert and select MS 5.0 Dialog...

This thread is now locked and can not be replied to.

Surface Pro 5 News - release date, UK price, features, specs

Microsoft Surface Studio hands-on review: the iMac killer is here

Best Mac antivirus 2017