Posts by Taz


    Can any tell me how i would put a formula together that will allow me to produce a set figure if a certain criteria is met?

    As an example i have to allow the spreadsheet to put a set figure in a box if a number is over these criteria:

    <140 then -20 points, between 140 and 190 give them 10 points and over 190 give them 20 points.

    Any ideas?

    not 100% sure whats gone wrong with this but i get an error on this line?

    Label1.Caption = Range("A1").Offset(ComboBox1.ListIndex, 1)

    any ideas? and what happens if once it has selected an item if i want the details of that row put into a text box in the form.... is that possible?

    Hard to say over here without having an attachment to show what i mean... my form contains various sections one being a drop down list which reads the contents of itself from the spreadsheet. what i need is for the item to be selected from the drop down list and for the system to find that entry and then jump across a few columns to one called location and show me in a report box exaxtly where the item is...

    any wiser?


    Can someone take a look at the attachment and maybe point me in the right direction. the form that is based within it should allow me to select a bin from a list and then what i want it to do is either show me the location or the availability of it.

    can someone take a look and let me know please


    ummmm where is the attach option gone?

    Hiya peeps

    Does anyone know if its possible to create a table on contents in Excel that will relate to the individual worksheets in the workbook?

    after lots of checks i have found that it only works on a spreadsheet that starts on A1, if there are gaps or the data starts on A7 for example it comes up with the #REF

    Does that mean anything?


    is there anything that could make every blank cell in the spreadsheet come up with #REF?? have check the test one and its perfect, just what i want :) but why wont it work on the live one :(

    Hiya Derk.... have been watching your replies with interest for a while, you certainly know your stuff!!!

    have tired this and all it does is fill in ALL the blanks with #REF any other suggestions please?

    I wish Andy..... the sheets contain thousands of entries which are automatically produced for me, i would be there for weeks inputing that as they change from report to report....

    this is why i am looking at a new solution :(

    its me yet again, sorry about this, just seem to have a lot of excel work and no time to really get into the nitty gritty of it all..... hence the need of help...

    have a spreadsheet demo attached, which has various bits of information and what you will see is there are areas missing, these need to be copied from the cells above.... anyone got any ideas?

    hi Andy... have attached a picture of the sort of dialogue box i want and it would contain items from either a predefined list or a list of information stored in cell contents, the same would be for the picutres and the tables one is basically a dialogue box that will allow me to select a preconfigured table and put it into the document.... make any more sense :(

    Thanks Andy for your reply..... part of it will be a dialog box that will pop up in the centre of the screen allowing users to select a phrase or paragragh of txt, one will allow them to select a picture, one will allow a selection of various tables....

    any help?

    Howde friends

    does anyone know the best way to create a vba script that will allow me to click an icon on the toolbar which would then produce a little box and allow me to select say a picture from a selection and then place it in the worksheet or document? am trying to automate a set of sequences...

    any ideas?

    this might help you:

    Sub Dup_cells()
    ' Dup_cells Macro

    On Error GoTo EndMacro
    If Selection.Columns.Count &gt; 1 Then
    MsgBox "Sorry, You May Only Select Cells In One Column.", vbExclamation
    Exit Sub
    End If
    If Selection.Rows.Count &gt; 1 Then
    Set rng = Selection
    MsgBox "Please Select Cells In Multiple Rows.", vbExclamation
    Exit Sub
    End If
    Application.ScreenUpdating = False
    Application.Calculation = xlCalculationManual
    i = Selection.Cells.Count
    n = 0
    For r = rng.Rows.Count To 1 Step -1
    v = rng.Cells(r, 1).Value
    If Application.WorksheetFunction.CountIf(rng.Columns(1), v) &gt; 1 Then
    rng.Rows(r).EntireRow.Delete Shift:=xlUp
    n = n + 1
    End If
    Percentage = n / i * 100
    Application.StatusBar = "Please Wait Now Processing: " & Percentage & "%"
    Next r
    MsgBox Format(n) & "Duplicates Will Now Be Cleared.", vbInformation

    End Sub

    Conditional formating is quiet easy to use for items like this. If you can share a little more detail i am sure we can help.

    but in a nutshell, go to Format, Conditional formating, set the options for condition 1, (cell is equal to 1.50*) then set the cell options by clicking on the Format button and selecting the options you want shown if that number appears.

    You can set more options if required

    Hi looking for an answer to this problem... need the best solution to allow me to identify how many enteries of a certain number exist in a sheet, just like a count formulae except there are a number of variables... any ideas?