This VB question must have a simple answer...

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

  1. SalMae

    SalMae

    Joined:
    Jan 19, 2010
    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. williadn

    Excel VB 6 with Excel

    williadn, Jun 9, 2005, in forum: Microsoft Office
    Replies:
    0
    Views:
    650
    williadn
    Jun 9, 2005
  2. hmicky

    Access Importing Access Tables using VB / SQL

    hmicky, Jun 14, 2005, in forum: Microsoft Office
    Replies:
    2
    Views:
    931
    hmicky
    Jun 14, 2005
  3. efremoj

    Windows XP Run time error 3001 in vb 6.0

    efremoj, Jul 7, 2005, in forum: Windows
    Replies:
    0
    Views:
    8,511
    efremoj
    Jul 7, 2005
  4. reenabahuleyan

    Windows XP faxing dynamic pages in vb.net

    reenabahuleyan, Oct 29, 2005, in forum: Windows
    Replies:
    0
    Views:
    239
    reenabahuleyan
    Oct 29, 2005
  5. merikhoz

    Windows XP change DragIcon of MSFlexgrid using vb.net

    merikhoz, Jul 12, 2006, in forum: Windows
    Replies:
    0
    Views:
    609
    merikhoz
    Jul 12, 2006
  6. blumenhause

    Windows XP VB.NET 2003 MultiLine Datagrid HEader Column

    blumenhause, Aug 26, 2006, in forum: Windows
    Replies:
    0
    Views:
    590
    blumenhause
    Aug 26, 2006
  7. Troy117

    Excel Excel VB - exporting & importing data

    Troy117, Jun 19, 2007, in forum: Microsoft Office
    Replies:
    0
    Views:
    356
    Troy117
    Jun 19, 2007
  8. Me__2001

    Excel Need some help with VB in Excel

    Me__2001, Dec 17, 2008, in forum: Microsoft Office
    Replies:
    0
    Views:
    671
    Me__2001
    Dec 17, 2008
Loading...