Using a Macro to sum the values in a Selected Range (Expand)

[Mike E Golding]

I have, for example,

Column A containing dates.
Column E containing Pay outs
Column D containing Pay Ins

I would like to be able to Select some of dates and to show a form
with the sum of the relevant Pay Outs in a TextBox on a UserForm and the sum of the relevant PayIns in another TextBox beneath the first and then to show a balance in a third TextBox.
The Userform is OK but now that I have been shown how to sum the values in a given range and it is workable I wonder if I can do the whole job with
just the relevant dates selected....Thanks for any thought..Mike.

 

[DRJ]

You should just reply to your other message if you have a followup questions, and not make a new topic.

Try this.

Sub Test

x = Application.WorksheetFunction.Sum(Selection.Offset(0, 4))
MsgBox x

End Sub

 

[Mike E Golding]

Re: Using a Macro to sum the values in a Selected Range (Exp

My apologies, I am not very familiar with the system. I have been trying to use Hlookup but I seem to be missing the "mainxl.hlp file. Thanks again and hope I'm not a pain...Mike

 

[DRJ]

No big deal, but if someone else wanted to help it would be easier if they could see your origional questions and solution.

 

[Mike E Golding]

Re: Using a Macro to sum the values in a Selected Range (Exp

Didn't think of that. Thanks again. Mike

 

[DRJ]

Your Welcome

Take Care