Posts by SimplyCongy

    Re: Locking cell range depending on value of another cell, repeat the process for 50


    can you colour the cells that will have the word "Completed" into them?

    Then you could do (i've used Yellow in this example)

    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Interior.Color = RGB(255, 255, 0) Then
        If UCase(Target.Value) = "COMPLETED" Then
            Range(Target, Target.Offset(0, -4)).Locked = True
        End If
    End If
    End Sub


    I've got a bit of code that populates a listbox with any filenames (.jpgs) from a specified folder. The user can then flick through the pictures that the search finds. The only problem is when the filename contains a comma. When I use the .AddItem command, it is seperating the filename onto two lines, as if it was set to comma delimited...

    Is there anyway I can tell the listbox not to do this, but to accept a comma in the item?

    Hope this is clear.


    Re: Lookup Part Of A Cell


    Try something like this


    Where D6 is your word to look up, I6:I9 is your range to lookup in and J6:J9 is the range you want to return


    Re: Deleting Duplicate Rows


    this one got me going... try this if you dont want to sort your file...


    Re: Matching column data in multiple worksheets

    Hi Ima,

    I've been away, hence why its taken me a while to respond!

    Have a look at the help menu (F1) for the find property. That will tell you how to use the "lookat" function to specify whether you want an exact match or just a close one


    Re: Matching column data in multiple worksheets

    Hope these comments help


    Re: Matching column data in multiple worksheets


    try something like this

    its not the whole answer, but should point you in the right directions


    Re: Drop down to select Currency type

    Should be quite easy to do with a drop down box as you suggest. Can i just check that you dont want to change the values with the currency change (e.g £1 --> $1.83) but just the formatting (£1.00 --> $1.00)

    Re: Automatic rounding

    You could use something like this...

    ... and assign the code to a button on your toolbar...