Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / April 2005

Tip: Looking for answers? Try searching our database.

Tabbing out of Blank Cell

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jamie - 02 Apr 2005 01:17 GMT
I'm working in Excel 2002

I have a table with 18 columns where the user enters numeric values.  The
sheet is proctected, the cells the user inputs information into are unlocked.
Currently I have the following coding:

Private Sub Worksheet_Change(ByVal Target As Range)  
    If Target.Column = 18 Then
        Cells(Target.Row, 1).Select
    End If
End Sub

What this does is if the user tabs out of column 18, row 3 for example, the
cursor goes to column A in the same row.

The above coding works only if there is a numeric value in the cell in
column 18.  How can I get the above coding to work if the user leaves the
cell blank?

Thanks.
Signature

Jamie

Chuck - 04 Apr 2005 14:29 GMT
Try using the SelectionChange event instead:
 Private Sub Worksheet_SelectionChange(ByVal Target As Range)

> I'm working in Excel 2002
>
[quoted text clipped - 16 lines]
>
> Thanks.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.