View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe_Hunt via OfficeKB.com Joe_Hunt via OfficeKB.com is offline
external usenet poster
 
Posts: 50
Default Data entered in several cells before proceeding

I should be able to make this work, but can't. I have a worksheet that
includes a section to record checks and deposits of our school band boosters.
I want to make sure that the person who is entering the data enters all of it,
so that the date, check #, vendor, description, and amount must be entered
before proceeding to the next row. If they haven't entered everything then
they get a message box telling them that all information must be entered
before proceeding. I can make this work using a UserForm, but I've been asked
not to include one of those. These are in columns A - E with the checks
starting on row 11, and the deposits on row 28. Does anybody have any
suggestions? I really appreciate it.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/201005/1