Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.24 seconds.

  1. Replies
    3
    Views
    35

    User Form Option Button

    I have a user form with several option buttons

    After selecting an option button and clicking on Ok, I would like the button to show the last option button selected


    it would be appreciated if...
  2. Re: Excel function to compute Nominal Int Rate where effective Rate is negative

    Thanks for your help and input. it makes perfect sense
  3. Excel function to compute Nominal Int Rate where effective Rate is negative

    I would like to know if there is a function in excel to compute the nominal interest rate if the effective rate is negative

    If the effective rate is positive the formula =Nominal works perfectly
    ...
  4. Thread: Offset Function

    by howard
    Replies
    2
    Views
    67

    Re: Offset Function

    Thanks for the explanation. It makes perfect sense and your explanation is simple to follow
  5. Thread: Offset Function

    by howard
    Replies
    2
    Views
    67

    Offset Function

    I would like to know how the 4th and 5th function in Offset works i.e height and width


    eg
    =SUM(OFFSET(J14,0,0,1,-5))



    Your assistance is most appreciated
  6. Replies
    4
    Views
    92

    Re: Macro to export last sheet to Desktop

    My apologies Fluff. I inavertently forgot to post the cross link


    https://www.excelforum.com/excel-programming-vba-macros/1285228-macro-to-add-sheet-after-last-sheet.html#post5169586
  7. Replies
    4
    Views
    92

    Re: Macro to export last sheet to Desktop

    I have attempted to write code, but It save each sheet

    I only need the last sheet to be saved as a csv and to the desktop


    Sub Save_ActiveSheet()

    Dim WS_Count As Integer
    ...
  8. Replies
    4
    Views
    92

    Macro to export last sheet to Desktop

    I would like a macro to save my last sheet with the same name as the sheet for if sheet name is July 2019 to save as July 2019 followed by -BR1 Data


    This sheet to be saved will always be the...
  9. Replies
    8
    Views
    110

    Re: Force certain Values in Input Box

    Thanks for the help, Dante
  10. Replies
    8
    Views
    110

    Re: Force certain Values in Input Box

    Thanks Rick. Code works perfectly
  11. Replies
    8
    Views
    110

    Force certain Values in Input Box

    I have the following code below

    Sub Input_Data()


    Sub Input_Data ()
    Dim myValue As Variant
    myValue = InputBox("Enter The net income amount")
    Range("B3").Value = myValue
    myValue =...
  12. Replies
    2
    Views
    63

    Re: Use ampersand to change year in formula

    Thanks for the link
  13. Replies
    2
    Views
    63

    Use ampersand to change year in formula

    I have the following formula



    =INDEX('[Sales Report2019.xlsm]Sales by month'!$A$11:$N$11,MATCH('[Sales Report2019.xlsm]Sales by month'!B1,'[Sales Report2019.xlsm]Sales by month'!$A$1:$M$1))
    ...
  14. Replies
    33
    Views
    2,567

    Re: Macro to email based on Renewal Date

    I will never forget this again. Once again thanks for all your patience and effort

    I have learnt a lot from your code
  15. Replies
    33
    Views
    2,567

    Re: Macro to email based on Renewal Date

    Hi Dante

    I went through your code line by line and tried a few things but could not get it to work. I did not realise that I had not set up sheet BR3

    My sincere apologies for this

    Many...
  16. Replies
    33
    Views
    2,567

    Re: Macro to email based on Renewal Date

    Hi Dante

    The last item (G4) contains "Yes" and I4 is Blank, but no email is generated


    See full code below


    Sub email()
    Dim Mail_Single As Variant, c As Range, d As Range, wFile As...
  17. Replies
    33
    Views
    2,567

    Re: Macro to email based on Renewal Date

    Hi Dante

    Thanks for the amended Code. The logic I supplied to you is correct. I tested with "NO" in Col G and no emails generated, which I correct

    Where I have Yes in G2, G3 & G4, and either...
  18. Replies
    33
    Views
    2,567

    Re: Macro to email based on Renewal Date

    Hi Dante


    Sorry if I was not clear in my explanation


    The criteria is as follows:

    If item in Col G = "Yes" and Col I contains a blank cell in same row or "No" then an email to be...
  19. Replies
    33
    Views
    2,567

    Re: Macro to email based on Renewal Date

    Thanks for the amended code

    The sample data contained "Yes" in Col G for all items and Blanks in Col I

    Emails were generated for

    Simon.Davids@smt.com
    barry.marks@smt.com
  20. Replies
    33
    Views
    2,567

    Re: Macro to email based on Renewal Date

    Hi Dante

    Thanks for the amended code. If all the items in Col G are = "Yes" and Col I is either blank or contains 'No" and there are 3 items from G2 onwards, only 2 emails are generated

    I tried...
  21. Replies
    33
    Views
    2,567

    Re: Macro to email based on Renewal Date

    Hi Dante

    If for eg G2 = "Yes" and I2 = "NO" or Blank, the macro creates 2 emails. It should only create 1 email


    Please test and amend code
  22. Replies
    33
    Views
    2,567

    Re: Macro to email based on Renewal Date

    Hi Dante

    Your original code worked 100% , but I added an additional Criteria as follows:

    1) If Col G = "Yes" and Col I = "NO" or Blank , then generate an email using recipient/s in Col F in...
  23. Replies
    33
    Views
    2,567

    Re: Macro to email based on Renewal Date

    I amended your code slightly that that if "yes" appears in Col G & "emailed" appears in Col I not to send an email


    Kindly test & amend
  24. Replies
    33
    Views
    2,567

    Re: Macro to email based on Renewal Date

    Hi Dante


    I checked your data again today and 4 emails are generated and only 3 should be generated

    Kindly test and amend code

    ...
  25. Replies
    3
    Views
    122

    Re: VBA Code Type Mismatch

    Thanks Fluff-Code works perfectly
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4