LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Autosize cells as data is entered Carol Excel Discussion (Misc queries) 16 April 4th 10 08:14 PM
Using a Macro in Excel 2004 to move entered data from one sheet toanother and space between rows when next data is entered? [email protected] Excel Programming 1 June 4th 08 05:08 PM
Unhide cells when data is entered greyo Excel Worksheet Functions 0 August 8th 05 07:39 PM
Protect data in cells after entered Jeff Hall Excel Discussion (Misc queries) 1 May 16th 05 08:54 PM
How to only print cells where there is data entered, as in a sched Cel Excel Discussion (Misc queries) 1 April 19th 05 10:43 PM


All times are GMT +1. The time now is 05:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"