Previous Topic Next Topic

Need help with Macro 2007

Closed
maria - Nov 10, 2010 at 11:02 PM
 easy - Nov 11, 2010 at 09:58 PM
Hello,

College_Cost()
Dim Tuition As Currency
Dim Room_and_Board As Currency
Dim Miscellaneous_Expenses As Currency
Tuition = InputBox("EnterTuition")
Room_and_Board = InputBox("Enter ...
Miscellaneous_Expenses = ...

Total_Cost=.... ( I'M NOT SURE HOW TO FINISH THIS COMMAND SO IT WILL ADD)
MsgBox ("Total Cost = $" & Grosspay & "")
End Sub


Hi, I need help finishing the command Total_Cost= so it will add the cost of all the dims.. Can someone give an idea how to fix it..??.

Thanks

Related:

1 response

Answer 1 / 1
easy
Nov 11, 2010 at 09:58 PM
Grade 1 or 2 Math?

Total_Cost=Tuition + Room_and_Board + Miscellaneous_Expenses

Similar discussions

MS Office Project 2007
stelcyp -
rizvisa1 -

Hello,
Could I have the 25 character key for MS Office 2007? I downloaded the software but can not operate it with out the key.


Configuration: Windows Vista / Chrome 21.0.1180.89

1 response
Automatically Run Macro from a calculated cell value change
smiller -
TrowaD -

Hello,

I am not having any luck using this code(and haver tried others).

Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$V$4" Then Call VALIDATION_LOOKUP End If End Sub

I need to automatically start a Macro then the value of a cell that contains a calculation changes.

Thanks

1 response
Convert number into words in excel 2007
deepadevi -
Brijesh -

Hello,

i'm trying to convert number into words in excel 2007. i've written coding in VB module. But I don't know how to get it in my function list. Please help me asap.

Regards,
deepadevi

Configuration: Windows XP / Internet Explorer 6.0

4 responses