Custom data forms in excel

  oxford 22:46 17 Jan 2003
Locked
  oxford 22:46 17 Jan 2003

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,
Oxford.

  VoG™ 23:15 17 Jan 2003

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.

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

11 best portfolio websites for designers and artists

Office for Mac buying guide: Price, Office 2017 rumours & new features

Comment désactiver les programmes qui s'exécutent au démarrage de Windows 10 ?