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

Best Amazon Echo: What’s the best Alexa speaker?

Kano Computer Kit Complete review: A fun DIY 'laptop' that teaches kids to code

Best pro photo editors for Mac 2018

TV & streaming : comment regarder les Jeux olympiques d’hiver 2018 ?