Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Re: Upon selection of item in table row, need msg box to appear and have resulting number entered in table

    Nevermind, I just worked it out.
  2. Re: Upon selection of item in table row, need msg box to appear and have resulting number entered in table

    Sorry, I forgot to include the code:


    Private Sub Worksheet_Change(ByVal Target As Range)
    'ActiveSheet.Unprotect
    Dim ans As String
    'I suggest this go to the start before turning off the...
  3. Re: Excel formula to add a minimum amount and add an extra hour

    I can't share the workbook, sorry, there is too much confidential info in it. I have a cell for the hours done and a cell that allows you to select the type of activity. In the background, it does a...
  4. Re: Upon selection of item in table row, need msg box to appear and have resulting number entered in table

    Thanks Joe, I already had this code that someone helped me with and I forgot that I already had the code. It adds a new column on to the end instead of putting the activity cost into the column...
  5. Replies
    5
    Views
    111

    Re: Updating a formula in excel

    Thanks Dante.
  6. Excel formula to add a minimum amount and add an extra hour

    I have a spreadsheet with data entered into cells A5:E11 in a matrix. This is a named range with the name Service_Types. Along the top, starting at B5 I have Mon-Fri, Sat, Sun and Public Holiday. In...
  7. Replies
    5
    Views
    111

    Re: Updating a formula in excel

    Thanks Joe but I already worked it out with this formula


    =IF(A11="","",IF(COUNTIF(Sheet2!$G$87:$DO$97,A11),"Public Holiday",IF(WEEKDAY(A11)=1,"Sunday",IF(WEEKDAY(A11)=7,"Saturday","Mon-Fri"))))
  8. Replies
    5
    Views
    111

    Updating a formula in excel

    I have a formula that correctly returns if a date is a mon-fri, weekend or public holiday.


    =IF(A11="","",IF(COUNTIF(Sheet2!$G$87:$DO$97,A11),"Public...
  9. Upon selection of item in table row, need msg box to appear and have resulting number entered in table

    I have a table called npss_quote. The header row is A10:M10 with the data starting in row 11. Column B for each row in the table has a data validation list referring to a list of 7 items. Upon the...
  10. Can I update a cell from date to general format and retain the date instead of being converted to a number?

    I want to update a column format to general instead of a date. Can I retain the date instead of the date being converted into a number?
  11. Replies
    4
    Views
    186

    Re: Uses for the range.find method

    Sorry to be a bit vague before AlphaFrog. I did want the bottom of the text row but that was to try and work out if I could use it to see if a image would fit in the space between the bottom of the...
  12. Replies
    31
    Views
    910

    Re: Measuring distances with vba

    I then press end and it inserts the image with left alignment and starting in row 7. This is right on top of my table.
  13. Replies
    31
    Views
    910

    Re: Measuring distances with vba

    I remember, with the code is post 13, if the references are changed, I get the error message "The item with the specified name wasn't found."
  14. Replies
    31
    Views
    910

    Re: Measuring distances with vba

    Please remind me what I was trying to achieve with post 13.
  15. Re: What is wrong with my select case statement

    Never mind, I got it working.
  16. What is wrong with my select case statement

    This is the start of my select case statement and it has an error and I can't figure out why, can someone help me please?


    Dim printWorksheet As Worksheet, logoShape As Shape, tempImageFile As...
  17. Replies
    3
    Views
    67

    Re: Carriage return of text in a footer

    I just found it, I used the first option. :)
  18. Replies
    3
    Views
    67

    Re: Carriage return of text in a footer

    Thanks Michael, I used the second option but it put an extra line between each line. How do I make it so there isn't a blank line between the lines?
  19. Re: VBA code to insert an image in the header

    Thanks for that Peter :)
  20. Replies
    3
    Views
    67

    Carriage return of text in a footer

    I have code that enters text in a footer, how do I force vba to enter a carriage return in the footer so the text is on more than 1 line?
  21. Replies
    31
    Views
    910

    Re: Measuring distances with vba

    In relation to post #23 Mike, the document will need to be printed to pdf. Once it is in pdf form, if the text box was near the bottom of the page, the image will be put inserted below the text box...
  22. Replies
    31
    Views
    910

    Re: Measuring distances with vba

    The name of the sheet that the picture needs to go on is sheet1 and the textbox is called TextBox4.
  23. Replies
    4
    Views
    186

    Re: Uses for the range.find method

    Thanks for that AlphaFrog.

    That gives me the row of the bottom of my text box. Is there a way to measure the distance between several rows below that point and the bottom of the page that is on...
  24. Replies
    31
    Views
    910

    Re: Measuring distances with vba

    Sorry Mike, I don't really follow your question.
  25. Replies
    31
    Views
    910

    Re: Measuring distances with vba

    This line is highlighted

    If img.Height > Rows(Worksheets("sheet2").HPageBreaks(1).Location.Row).Top - Sheets("sheet2").Shapes("TextBox4").Top + Sheets("sheet2").Shapes("TextBox4").Height Then
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4