Results 1 to 7 of 7
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    User Select Question (Excel 2002)

    Hi

    I need users to be able to select the text "Concentrate" or "Ready to Use" in cell K17 but only if AA19 = True


    Is this a reasonable request?. I have no idea where to start.

    Many thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: User Select Question (Excel 2002)

    > I need users to be able to select the text "Concentrate" or "Ready to Use"

    From a dropdown list? You can use Data | Validation for that. Put the entries Concentrate and Ready to Use in two cells somewhere - you can hide them if you like.
    Select K17.
    Select Data | Validation...
    Select List.
    Enter or select the range with the two entries in the source box.
    Activate the other tabs to specify a help text and an error message (optional)

    What exactly do you mean by "but only if AA19 = True"? For example, what should happen if the user has already selected a text in K17, and if AA19 then changes to False? Please try to be as specific as possible.

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: User Select Question (Excel 2002)

    Hi Hans

    AA19 is the link cell from a check box, only if it is checked does the user need to enter either of the text options, if it is unchchecked the cell should show nothing.

    Hope this is a bit clearer.

    Many thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: User Select Question (Excel 2002)

    You can assign a macro to the check box that clears K17 if the check box is cleared:

    Sub CheckBox1_Click()
    If Range("AA19") = False Then
    Range("K17").ClearContents
    End If
    End Sub

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: User Select Question (Excel 2002)

    Hi Hans

    Once again I am in your debt.

    Many Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: User Select Question (Excel 2002)

    But that is not going to stop the user from dropping down the list and selecting one of the entries if AA19 is already false. I think that what is really needed is a worksheet change event routine in combination with. Maybe something like:

    Private Sub Worksheet_Change(ByVal Target As Range)
    If Intersect(Target, Range("K19")) Is Nothing Then Exit Sub
    Application.EnableEvents = False
    If Range("AA19") <> True Then Range("K19").ClearContents
    Application.EnableEvents = True
    End Sub
    Legare Coleman

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: User Select Question (Excel 2002)

    That is correct!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •