Search:

Type: Posts; User: scottmcclean; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    2
    Views
    119

    Re: Trouble Using Nested IF Formula

    Genius!
    Thank you so much - it works a treat.

    :)
  2. Replies
    2
    Views
    119

    Trouble Using Nested IF Formula

    Hi all,
    I am trying (unsuccessfully) to create an IF statement that does the following:

    In cell S2 If The week number in H2 is Greater than Todays date then write "Late" If not write nothing, If...
  3. Replies
    7
    Views
    684

    Re: Reference Library Problem

    Rory - thank you so much. Works a treat!! Many thanks.
  4. Replies
    7
    Views
    684

    Re: Reference Library Problem

    Hi Rory, that is very kind. Much appreciated....here is the Outlook routine:


    Private Sub cmdAdd_Click()
    'This calls the send mail module that will send an email to the line manager to let...
  5. Replies
    7
    Views
    684

    Re: Reference Library Problem

    Hi Rory, forgive me, I do not understand what you mean by this.
  6. Replies
    7
    Views
    684

    Reference Library Problem

    Hi all,
    I wonder if you could steer me in the right direction.....

    I originally created a number of excel VBA forms in Excel 2007. My system had to be upgraded and I now use Office 2010. I have...
  7. Userform drop down list text/value pairs

    Hi there,
    I have a VBA userform that has two drop down lists and a text box. I currently have the first drop down list populated with Low, Medium, High and the sceond drop down list with Likely and...
  8. Re: Excel VBA Form: Add an Incrementing Serial Number

    Thanks Roy.
  9. Re: Excel VBA Form: Add an Incrementing Serial Number

    you're a genius. works superbly.
    thank you very much, seriously appreciated.
  10. Re: Excel VBA Form: Add an Incrementing Serial Number

    Hi Roy,
    thank you for replying.how do I relate the code to a text box on my form so that it adds in the serial number with the rest of the form data?
  11. Excel VBA Form: Add an Incrementing Serial Number

    Hi there,
    I have an Excel VBA form that populates a sheet. The problem that I could do with some help on is that I would like to be able to have a text box that adds an incrementing serial number. I...
  12. Replies
    0
    Views
    217

    pulling in a graph based on an ID

    Hi all,
    I am not sure if this is even possible.....

    I have a single, electronic, report that is in Excel2007. When you select the ID from a drop down box it displays that IDs report data. I have...
  13. Replies
    3
    Views
    131

    Re: Index and Match Problem

    Thanks holystoner, it works a treat!!
  14. Replies
    3
    Views
    131

    Index and Match Problem

    Hi there,
    I hope you can help. am having some problems getting my head around Index and Match.

    I have a requirement to pull data from a specific cell in a sheet based on two Criteria.

    The...
  15. Re: Hide rows based on a selection from a combo box

    Hi Jim,
    Thank you very much for taking the time to help me. The solution works, and has definitely helped.

    Just out of interest, is using a combobox to do this very difficult?

    Many thanks...
  16. Hide rows based on a selection from a combo box

    Hi all,
    I would like some help please in being able to hide rows based on a combobox selection.

    I have a sheet that contains a lot of rows an would like the user to be able to filter out rows...
  17. calculate the number of occurrences of a "Letter" based on a percentage

    Hi there,
    I hope you can point me in the right direction. I am trying to create a RAG status report and have a 4 cells that contain a letter based on a score. I would like to total that range of...
  18. Need to select data based on conditions in a separate sheet then return the values in specific places

    Hi All,

    I am new to the more advanced uses of Excel and a total novice at Macros etc. The problem that I have is that I have a userform that (amongst other things) adds overtime data for multiple...
  19. Re: Dates in UK Format are converting to USA Format

    Thanks Andrew, much appreciated.
  20. Dates in UK Format are converting to USA Format

    Hi all,

    I have been fighting with a date problem now for a week and cannot seem to crack the issue - I could really do with a steer please.....

    I have an Excel VBA userform that populates data...
  21. Re: Form Combo Boxes to Default to last input row data

    Hi Andrew,
    Thank you very much, it worked a treat.

    all the best

    Scott
  22. Re: Form Combo Boxes to Default to last input row data

    Hi Andrew, thanks for replying. The combo boxes populate specific cells within the sheet: so the team members for the previous day would be in cells 15, 18 and 21 of each row.

    .Cells(iRow,...
  23. Form Combo Boxes to Default to last input row data

    Hi all,
    this is my first post and I am currently an occasional user of excel - this is my first attempt at Excel VBA
    My question to the forum is this:

    I am using Excel 2007 and would like to...
Results 1 to 23 of 23