This VB question must have a simple answer...

Discussion in 'Windows XP' started by SalMae, Jan 19, 2010.

  1. SalMae

    SalMae

    Joined:
    Jan 19, 2010
    Messages:
    1
    Likes Received:
    0
    Hi! I'm a determined novice. [​IMG]

    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


    Questions:

    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!
     
    SalMae, Jan 19, 2010
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. wildone
    Replies:
    2
    Views:
    1,754
    wildone
    May 16, 2002
  2. KGB-911
    Replies:
    3
    Views:
    271
    KGB-911
    Nov 2, 2005
  3. mrock
    Replies:
    0
    Views:
    319
    mrock
    Nov 14, 2006
  4. mustanger

    Must restart for internet access

    mustanger, May 21, 2008, in forum: Windows XP
    Replies:
    0
    Views:
    253
    mustanger
    May 21, 2008
  5. m0b1us
    Replies:
    1
    Views:
    821
    Abarbarian
    Dec 8, 2008
Loading...

Share This Page