# Search:

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

Page 1 of 6 1

1. ## Thread: User Form Option Button

by howard
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. ## Thread: Excel function to compute Nominal Int Rate where effective Rate is negative

by howard
Replies
3
Views
166

### Re: Excel function to compute Nominal Int Rate where effective Rate is negative

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

by howard
Replies
3
Views
166

### 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
...

by howard
Replies
2
Views
67

### Re: Offset Function

Thanks for the explanation. It makes perfect sense and your explanation is simple to follow

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))

6. ## Thread: Macro to export last sheet to Desktop

by howard
Replies
4
Views
92

### Re: Macro to export last sheet to Desktop

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

7. ## Thread: Macro to export last sheet to Desktop

by howard
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. ## Thread: Macro to export last sheet to Desktop

by howard
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. ## Thread: Force certain Values in Input Box

by howard
Replies
8
Views
110

### Re: Force certain Values in Input Box

Thanks for the help, Dante
10. ## Thread: Force certain Values in Input Box

by howard
Replies
8
Views
110

### Re: Force certain Values in Input Box

Thanks Rick. Code works perfectly
11. ## Thread: Force certain Values in Input Box

by howard
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 =...

by howard
Replies
2
Views
63

13. ## Thread: Use ampersand to change year in formula

by howard
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. ## Thread: Macro to email based on Renewal Date

by howard
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. ## Thread: Macro to email based on Renewal Date

by howard
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. ## Thread: Macro to email based on Renewal Date

by howard
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. ## Thread: Macro to email based on Renewal Date

by howard
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. ## Thread: Macro to email based on Renewal Date

by howard
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. ## Thread: Macro to email based on Renewal Date

by howard
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. ## Thread: Macro to email based on Renewal Date

by howard
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. ## Thread: Macro to email based on Renewal Date

by howard
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

22. ## Thread: Macro to email based on Renewal Date

by howard
Replies
33
Views
2,567

### Re: Macro to email based on Renewal Date

Hi Dante

1) If Col G = "Yes" and Col I = "NO" or Blank , then generate an email using recipient/s in Col F in...
23. ## Thread: Macro to email based on Renewal Date

by howard
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. ## Thread: Macro to email based on Renewal Date

by howard
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. ## Thread: VBA Code Type Mismatch

by howard
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