Search : in
By :

Formating Powerpoint Title

fg, on Sep 14, 2008 10:11:12 pm BST 
 Report this message to moderators

Hello,

I wrote a macro to create powerpoint presentations from an excel macro and I need to format the variable BWRep in red when negative. I am using the following instruction:

Dim BWRep As Long
'
'
'apply tittle to the slide
.Shapes.Title.TextFrame.TextRange = "MONTHLY EXPENSES" & vbCrLf & "2007 & 2008 C.Y. - " & sTitle & vbCrLf & _
"B/W =" & Format(BWRep, "$##,##0;[Red]($##,##0)")


The variable is following the currency format, but is not changing color when negative. What am I doing wrong?

Thanks

Configuration: Windows Vista
Firefox 3.0.1

Best answers for « Formating Powerpoint Title » in :
Download Free PowerPoint/PPT to Pdf Converter Show It is frequent to convert Word, Excel or image files to PDF format. But it is not very common to convert a PowerPoint file to the PDF format. PowerPoint / PPT to Pdf Converter is an application allowing to convert easily and quickly PowerPoint...
Download PowerPoint to Video Show Would you like to share your do your PowerPoint files with your friends? PowerPoint to Video offers to convert them into video format so that everyone can see them at home. PowerPoint to Video is a program allowing to convert a PowerPoint file...
Extracting sound and images from a Powerpoint (PPT/PPS) Show Extracting sound and images from a Powerpoint (PPT/PPS) Powerpoint is a software that allow you to export your sound and images file directly from the powerpoint as from a simple configuration. A simple modification is however...
Formatting your drive in FAT32 ShowFormatting your drive in FAT32 Issue Solution Issue Windows XP normally refuse to format a partition higher than 40 GB with FAT32. however this operation performs properly with NTFS Solution The solution for this issue is to boot...
Opening a PPS FILE ShowOpening a PPS FILE PPS, acronym for PowerPoint Show, is a tool created by Microsoft Office PowerPoint for distinguished presentations and slideshows. PowerPoint enables you to draft your own presentation within different display and design...
Formatting Your Hard Drive ShowFormatting Your Hard Drive Formatting and installing your Hard drive using the installation CD ] A hard disk drive is a non-volatile device mainly for data storage. Usually faster than any other storage device, this essential...
Download HP USB Disk Storage Format Tool ShowHP USB Disk Storage Format Tool is a small utility allowing to format a key USB or READER MP4. It also allows to make a key (Bootable). This software works with all keys and readers MP4 of the market. To make work this utility under Windows...
Download PowerPoint Viewer Show
Download HDD Low Level Format Tool Show
MKV format (Matroska Video) ShowMKV format The MKV format (Matroska Video) is an entirely free video format. More precisely, it is a container (hence the name Matroska, in reference to the Russian dolls contained within another) making it possible to contain video (DivX, Xvid,...
Formatting - Formatting a hard drive ShowBefore trying to understand formatting, you first need to understand how a hard drive works. Many people do not distinguish low-level formatting (also called physical formatting) from high-level formatting (also called logical formatting). Even...
S/PDIF format ShowS/PDIF format The S/PDIF standard ("Sony/Philips Digital Interface", or SPDIF for short) is a digital audio data transfer format. It is an international standard known as "IEC-958 type II", which defines both hardware specifications (physical...
Ask your question Reply
They need your help