TextBox.Value = WS column math with $ format???

[Big Lar]

What’s the correct code to display the following BAD example in a UserForm Textbox?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>

[FONT=Verdana]TextBox12.Value = Format(Sheet1.Range("T:T").Value + Sheet1.Range(“U:U”) * 0.25, "$ #.00")[/FONT]

<o></o>

 

[mikerickson]

What do you mean by Sheet.Range("T:T").Value + Sheet1.Range("U:U") ?
If you want the value in columns T and U to be summed, the syntax for the Message box would be

TextBox12.Value = Format(Application.Sum(Sheet1.Range("T:T")) + Application.Sum(Sheet1.Range("U:U") / 4 , "$ #.00")

 

[Big Lar]

Mike,
I wish to sum the valves in ColumnU / 4 plus the values in ColumnT.

I've tried your example and get a syntax error...which I can't find.

 

[Big Lar]

b

 

[Big Lar]

Once again...

TextBox12.Value equals the sum of the values of (Sheet1 ColumnU divided by 4) Plus the values of (Sheet1 ColumnT)

My attempts result in "Expected )" or "syntax error".

 

[mikerickson]

Darn, I mis- counted the number of parenthesis.

The Application.Sum for column U needs to be closed.

 

[Big Lar]

Mike,
Thank you!