Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fprced data entry on multiple worksheets
I am trying to force data entry on specific cells within a worksheet before
the user can leave the cell. I was working on this and got my code to this point, and it works great - as it is only in one worksheet: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(rLast, Range("D4, F4")) Is Nothing Then If IsEmpty(rLast.Value) Then With Application .EnableEvents = False .Goto rLast MsgBox "No empty cells, Cowboy" .EnableEvents = True End With End If End If Set rLast = Selection(1, 1) End Sub However, when I try to put this code in multiple worksheets, and just change my range to fit the specific worksheet cells, I get a run time error. Can someone help me out here to make this work for multiple worksheets within the same workbook? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Repeat same data entry to multiple worksheets without Group Functi | Excel Discussion (Misc queries) | |||
Populating Multiple Worksheets with one entry | Excel Worksheet Functions | |||
Merging multiple worksheets into one, with ongoing data entry | Excel Discussion (Misc queries) | |||
Data entry for two worksheets | Excel Worksheet Functions | |||
data entry on multiple worksheets | Excel Discussion (Misc queries) |