PC Review

Thread Tools Rate Thread

This VB question must have a simple answer...

New Member
Join Date: Jan 2010
Posts: 1
      19th Jan 2010
Hi! I'm a determined novice.

I have a situation where customer service folks are not recording claim numbers. A Customer Call In Rept. (Excel sheet) has a "Date Closed" field that is a catalyst for generating their commission.

I want to make the Date Closed field (cell "E74" below) uneditable until they fill in the Claim Number Field (cell "W66" below) with a claim # or Not Applicable or something that shows they've at least acknowledged it.

I have a prompt in the Claim Number field that states either "See Note Below" or "Type Claim Number Here" (redundant, I know) and, in VB, I can get the Date Closed field to not allow editing if that message is in it. The issue is, once I type in a claim number, I can't get the Date Closed field to allow editing.

Below is what I have:

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

If Range("W66")= "See Note Below" Or Range("W66") = "Type Claim Number Here" Then

Range("E74") = "Complete Claim # Section (if applicable) Before Entering Date"

ElseIf Range("W66") <> "Type Claim Number Here" Or Range("W66") <> "See Note Below" Then

Range ("E74")what do I use here?

End If

End Sub


1) What do I use after ("E74") to allow editing? (AllowEdit command gives me a property error)

2) Does it look like I have all my commands in order so I won't get any compile errors? Is there a 'tidier' way to approach this?

Thank you very very much!
Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Simple questions for simple 2 PC file sharing network. Simple? raylopez99 Microsoft Windows 2000 Networking 3 11th Feb 2007 02:31 PM
A No Brain Question......This must be obviously Simple Celtic_Avenger Microsoft Excel Programming 4 1st Nov 2004 06:30 PM
A No Brain Question......This must be obviously Simple Celtic_Avenger Microsoft Excel Programming 0 31st Oct 2004 03:51 PM
Simple Simple Simple craigwojo Microsoft Excel New Users 3 29th Aug 2004 05:32 AM
If you have a network and like a GUI to control it Tridia is a must have.... wildone Windows XP 2 16th May 2002 11:30 AM




All times are GMT +1. The time now is 01:30 AM.