Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data entered in several cells before proceeding
I thought of that, but if they don't enter things in the order I think they
should then they'll get a lot of messages. Of course, they'll learn to enter things in the right order maybe. I'll take a look. Thanks. Don Guillett wrote: You could use event code that fires on an entry in the last column. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count 1 Or Target.Column < 5 Then Exit Sub If Application.CountA(Cells(Target.Row, 1).Resize(, 5)) < 5 Then MsgBox "finish" End If End Sub 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 [quoted text clipped - 9 lines] starting on row 11, and the deposits on row 28. Does anybody have any suggestions? I really appreciate it. -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autosize cells as data is entered | Excel Discussion (Misc queries) | |||
Using a Macro in Excel 2004 to move entered data from one sheet toanother and space between rows when next data is entered? | Excel Programming | |||
Unhide cells when data is entered | Excel Worksheet Functions | |||
Protect data in cells after entered | Excel Discussion (Misc queries) | |||
How to only print cells where there is data entered, as in a sched | Excel Discussion (Misc queries) |