I have a macro that outputs the following line on an Excel spreadsheet:

2260.54 is the amount for your group.

The code is as follows:

activecell.offset (0,5) = vGrpAmt & " is the amount for your group"

I would like for it to display as follows:

$ 2,260.54 is the amount for your group.

I'm having trouble getting the dollar sign and commas to display in the
output. Any suggestions would be appreciated. Thanks for the help.........
--
JT

ActiveCell.Offset(0, 5) = Format(vGrpAmt, "$0,000.00") & " is the amount for
your group"

"JT" wrote:

I have a macro that outputs the following line on an Excel spreadsheet:

2260.54 is the amount for your group.

The code is as follows:

activecell.offset (0,5) = vGrpAmt & " is the amount for your group"

I would like for it to display as follows:

$ 2,260.54 is the amount for your group.

I'm having trouble getting the dollar sign and commas to display in the
output. Any suggestions would be appreciated. Thanks for the help.........
--
JT

One way:

ActiveCell.Offset(0, 5).Value = Format(vGrpAmt, _
"$ #,##0.00 ""is the amount for your group""")


In article ,
"JT" wrote:

I have a macro that outputs the following line on an Excel spreadsheet:

2260.54 is the amount for your group.

The code is as follows:

activecell.offset (0,5) = vGrpAmt & " is the amount for your group"

I would like for it to display as follows:

$ 2,260.54 is the amount for your group.

I'm having trouble getting the dollar sign and commas to display in the
output. Any suggestions would be appreciated. Thanks for the help.........

activecell.offset (0,5) _
= format(vGrpAmt, "$ #,###.00") & " is the amount for your group"

or something close to that.

JT wrote:

I have a macro that outputs the following line on an Excel spreadsheet:

2260.54 is the amount for your group.

The code is as follows:

activecell.offset (0,5) = vGrpAmt & " is the amount for your group"

I would like for it to display as follows:

$ 2,260.54 is the amount for your group.

I'm having trouble getting the dollar sign and commas to display in the
output. Any suggestions would be appreciated. Thanks for the help.........
--
JT

--

Dave Peterson

WS.Range("A2").Value = FormatCurrency(vGrpAmt) & " is the amount for your
group."

Changing WS.Range("A2").Value to whatever is your cell.

Bill Horton

"JT" wrote:

I have a macro that outputs the following line on an Excel spreadsheet:

2260.54 is the amount for your group.

The code is as follows:

activecell.offset (0,5) = vGrpAmt & " is the amount for your group"

I would like for it to display as follows:

$ 2,260.54 is the amount for your group.

I'm having trouble getting the dollar sign and commas to display in the
output. Any suggestions would be appreciated. Thanks for the help.........
--
JT