Custom data forms in excel

  oxford 22:46 17 Jan 03
Locked
  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,
Oxford.

  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.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

Best Christmas Agency Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…