Data entered in several cells before proceeding
in [Programming]
|
From: Joe_Hunt via OfficeKB.com on 18 May 2010 14:03 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.aspx/excel-programming/201005/1
From: Don Guillett on 18 May 2010 14:52 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 -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "Joe_Hunt via OfficeKB.com" <u45578(a)uwe> wrote in message news:a832e9928b2d4(a)uwe... >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.aspx/excel-programming/201005/1 >
From: Joe_Hunt via OfficeKB.com on 18 May 2010 15:01 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
|
Pages: 1 Prev: Lost horizontal scroll bar Next: Kill Open Read Only Message on Open |