Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default 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
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
Repeat same data entry to multiple worksheets without Group Functi vstar Excel Discussion (Misc queries) 1 July 9th 08 08:32 PM
Populating Multiple Worksheets with one entry Intuit Excel Worksheet Functions 5 January 27th 06 09:01 PM
Merging multiple worksheets into one, with ongoing data entry Bear Excel Discussion (Misc queries) 2 October 31st 05 04:16 PM
Data entry for two worksheets Mark from Michigan Excel Worksheet Functions 1 August 24th 05 03:49 PM
data entry on multiple worksheets diosdias Excel Discussion (Misc queries) 1 December 7th 04 05:33 PM


All times are GMT +1. The time now is 06:14 PM.

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

About Us

"It's about Microsoft Excel"