How to type a bullet point from vba?

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Powerpoint
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Video in PPT flashes for a moment before playing... Hello, I have two videos in a powerpoint (2007) presentation, and when the slide advances, the first frame of the video shows, then disappears for a second, and then the video resumes. It does not do this when played outside of Powerpoint. I've moved a copy of the PPT along with the two WMV files and shortened the names to minimize the length of the file path. This helped a bit, but is there anything else i should try? Thanks in advance! Michelle Tag: How to type a bullet point from vba? Tag: 386536
  - 2
    - How to resize individual elements within a chart template I need to be able to alter slightly an individual element within the standard chart template - the size of the "assistant" box. I have applies the template to a slide and right-clicked the box that I want to add an assistant box under. I then right-clicked the assistant box and choose "Format Auto Shape". However, under "Format Auto Shape" all re-size options are greyed out. Is there any way to resize a box within this template??? Tag: How to type a bullet point from vba? Tag: 386535
  - 3
    - Last Date Saved Field How do you add a {LAST SAVED DATE} Field to a 2003 Power Point presentation? This feature is available in MS Word 2003. Tag: How to type a bullet point from vba? Tag: 386533
  - 4
    - Referring to a table on any slide? How can I refer to a table on any slide from vba? without using activewindow.selection.shaperange(1).table, but just use the slide number and then point to the table? thank you, Lily Tag: How to type a bullet point from vba? Tag: 386532
  - 5
    - PowerPoint goes back to slide 1 during presentation When in presentation mode, the slides went back to slide 1 all by itself - no one was touching ANYTHING. I am using PPT 2003. I imported "slides from file" into my document from our speakers document. This is the only thing I can think that would have caused this glitch. It happened several times. Has anyone out there had this happen to them? Tag: How to type a bullet point from vba? Tag: 386531
  - 6
    - WMA sound files I am using the latest Pwr Pnt and want to include some .wma sound files. According to what I read on the "Help" that format is suported by PWR PNT. These songs play just fine on my Windows Media Player. According to what I read on "help" I may need a different codex. I only know what I read so any help or assistance would be greatly appreciated. Mastiff Tag: How to type a bullet point from vba? Tag: 386527
  - 7
    - PowerPoint 2007 acting SLOW after XP SP3 upgrade After upgrading my XP Prof (danish lanq) to SP3 my PowerPoint is getting useless :( All other Office applications works ok - but PowerPoint is lagging... No other changes to the platform have been made... Anyone experiencing the same problem? Tag: How to type a bullet point from vba? Tag: 386520
  - 8
    - "Color Typewriter" animation slower in '07 than '03 My company has rolled-out an Office '07 pilot, and I've noticed a drastic decrease in visual performance when viewing animated slides I've created in the '03 version of PPT. Specifically, the color typewriter effect performs more sluggishly. I've read the thread regarding "print drivers" as the fix, but I'm still curious as to why there is a difference in performance between the two versions when the environment (my desktop configuration, the network...) has not changed. Is PPT using a different method for rendering animations? Have the recommended system requirements been radically changed? While I have the help desk looking into the matter, I'm curious to see if there has been similar feedback. Tag: How to type a bullet point from vba? Tag: 386517
  - 9
    - SmartArt conversion If I decide to convert samrtArt back to bullet list without copying and pasting that from the text pane how can I do that?? Tag: How to type a bullet point from vba? Tag: 386516
  - 10
    - Custom Animation I use Office 2003. When I try to animate (Custom Animation), I can set it up but the animation doesn't work. That is - the Custom Animation menu opens up, I can see that Group 1 should appear with the first mouseclick, Group 2 with the second etc. but when I go into the Slideshow, everything appears at once. I did add the option that would allow me to open Office 2007 documents a few weeks ago, could this cause any problem? Thanks Matt Tag: How to type a bullet point from vba? Tag: 386511
  - 11
    - Can I create a broken bar chart for the larger values in Powerpoin I'm doing a graph that has a few low numbers but one high one, I have seen charts before where the higher number column appears broken to show that it is a higher number? The graph I'm using is a bar chart. Can anyone point me in the right direction? Tag: How to type a bullet point from vba? Tag: 386507
  - 12
    - power point macro Although I can create a Macro in Power Point, I can't get it to accept a sequence of custom animation commands. Any clues anybody? Tag: How to type a bullet point from vba? Tag: 386499
  - 13
    - Powerpoint 2003:Missing Images I have created 4 Chapters of Photo and Sound Images (460 Images in Each Chapter) using Powerpoint 2003. The problem I have is, when using Powerpoint 2003 to view the Presentations, about every 5th to 12th Image is missing on screen. Since this problem presented itself in Powerpoint, I also notice that Emailed PPSs miss some Images. This problem does not happen if I use Microsoft Powerpoint 2003 Viewer to view files outside of Powerpoint 2003 itself. I have also determined that the problem does not present itself when the same Presentation Files are run on other PCs or Laptops. In an effort to identify the cause of this problem I have tested with Graphics Accelleration both on and off and various settings for Accelleration. No improvement. I have changed out and increased DDR400 Memory to max of 4 Gb, I have performed a Windows Repair Install and Un-Installed Graphics Card Driver and Installed current version Driver 93.71, all to no avail, missing Images still persist. My PC specs: MB = Gigabyte GA-81PE775 Pro, CPU = Intel P4 3.0GHz, RAM = 4Gb DDR 400, Video = GeForce MX 4000 93.71 Driver, HDD = SATA 500Gb, OS = XP Pro SP2 + Updates, Application = Office 2003 SP3 + Updates, AVG AntiVirus and AVG AntiSpyWare. Can anyone Please advise if my Hardware can be contributing to this problem in any way or any other pertinent information that may assist in resolving this problem. Thank You, Owen Carlton Tag: How to type a bullet point from vba? Tag: 386498
  - 14
    - MCI error - mp3s randomly stop working; reinstalled WMP11 but noth Would love some help here. I have PPT 2003 and XP sp2. Using this set-up I have created many ppt presos with media in them and they have all worked fine. Up until now that is. Now I am getting this MCI error ("The specified file cannot be played on the specified MCI device. blah blah.."). The offending media in question is an mp3 I have run mplayer2.exe (WMP6?) and mp3s will not work there either, the error being "The source filter for this file could not be loaded. (Error=80040241)". The same mp3s work fine though in every other application I've tried (WMP11, Winamp, RM). So does this mean the problem is not the codecs? I've tried uninstalling and re-installing WMP11 I don't know how many times. I have also uninstalled pretty much every program I can think of that could potentially be causing a codec clash, including: - Winamp - Real Player - Samsung PC Studio + any other programs I saw which had anything to do with multimedia (exlc. VLC and PowerDVD) I have never downloaded and installed a codec pack, rogue or otherwise. To be honest until today I didn't even know what a codec was. The number of character in the file path is well less than 100 too. I would be most grateful for any advice as honestly I am at my wits end. I just don't understand how it could all work fine one day and now it doesn't. Kind regards Rob Tag: How to type a bullet point from vba? Tag: 386495
  - 15
    - PPT2003: Export of "attached" forms, files... Dear all, I am developing a PPT (2003) AddIn which contains quite a lot of files (forms, classes, modules...) meanwhile. For backup and repository purposes I usually export all of these files. Something I am looking for is automising this export. For now I have to click on each file, select "export", select the folder and save. This can be quite annoying for a lot of files (which I have). Is there an easier way - like a script or alike that automises this process? With regards, Martin. Tag: How to type a bullet point from vba? Tag: 386494
  - 16
    - Editing selected table cell in VBA Hi All I'm wanting to write a macro to modify the properties of some cells I have selected in a table in ppt (but not every cell in the whole table). I can't seem to work out how to let vba manipulate just the cells I have selected. Is this possible? Can anyone help? Thanks in advance Tag: How to type a bullet point from vba? Tag: 386482
  - 17
    - Organizing a "Library" of Slides Is there a way of organizing a collection or library of slides taken from a number of different presentations so they can be reused in future presentations? I've seen ads for a program called SlideWhere. Is this program helpful? Are there other programs that are better? Is there a way to do this just using Powerpoint alone (I'm using PPT97 and PPT2003)? Thanks! Tag: How to type a bullet point from vba? Tag: 386480
  - 18
    - changing where a task pane is displayed on the monitor screen I have Powerpoint 2003. I've been working right along on programs OK and when I click on "custom animation", the task pane has been displaying on the far right side of my monitor screen. Now all of a sudden the task pane (and other ppt task panes) display across the entire top of the monitor screen. I can't figure out what I did to change how task panes display and I have been unable to change it back so that the task panes display along the far right side again. HELP! Tag: How to type a bullet point from vba? Tag: 386479
  - 19
    - slide transitions w/ custom animation I have a ppt presentation w/ custom animation set for five-second intervals automatically. However, after the last graphic or text box appears, the slide transitions nearly instantaneously to the next slide. I have the slide transitions set for five seconds throughout the entire presentation. Is there an easy way to slow down the transition or do I need to go back and reset each slide transition one at a time? Thanks. -- NickBaque Tag: How to type a bullet point from vba? Tag: 386476
  - 20
    - Keyboard activation in Presentation mode Is it possible without vba to have an action button behave as a keyboard keystroke? For example, I create an "A" key; in presentation mode someone clicks the key and it prints out an "A". Will I need to use activex buttons instead? I thought about pure trigger animation and building the characters myself through custom animation but that seemed too tedious... I also want to build a working ppt or pptx calculator in the same fashion but have come across the same problem... Any suggestions? Tag: How to type a bullet point from vba? Tag: 386474
  - 21
    - How do I change the default that opens new file when PPT is opened I'm becoming annoyed at a new file opening every time I open PowerPoint -- how do I change that default? Tag: How to type a bullet point from vba? Tag: 386468
  - 22
    - Motion Path Accuracy I'm just starting to use motion paths to develop some animations, and I'm having trouble making them accurate enough to keep my objects aligned. For example, say I have a group of four boxes (upper left, upper right, lower left, lower right) that form a grid. I want to show those boxes moving around to show a particular reordering of data that I'm illustrating, but when the boxes come to their final resting places in the same grid, they are not well lined up because the motion paths don't seem to "snap" to where I'm wanting the boxes to move (meaning, the end points of the paths are not in the right place). Are there tricks to making accurate paths? I've found the same disappointment in general when working with freeforms - I don't know how to put the points exactly where I want them when drawing or editing. Thanks, Eric ------------------------- If toast always lands butter-side down, and cats always land on their feet, what happen if you strap toast on the back of a cat and drop it? Steven Wright (1955 - ) Tag: How to type a bullet point from vba? Tag: 386464
  - 23
    - Copy Excel data to a large table in a ppt slide I have a large data table in power point, the content of which mainly comes from excel spreadsheet. I cannot use copy and paste as the table doesn't exist in excel. I want to build a vba to copy data from excel to power point directly whenever there is an update. However, it is difficult to point to the correct position of each data point in the power point table. Is there a way to do this? thanks. Tag: How to type a bullet point from vba? Tag: 386463
  - 24
    - PowerPoint 2003 - Disable Autosize My company has standards for PPT font sizes, etc. However, I find that whenever I create a presentation, PowerPoint takes it upon itself to resize my fonts without my permission. Is there a way to shut this off? Tag: How to type a bullet point from vba? Tag: 386456
  - 25
    - Track Changes Hello, I'm using PPT 2002 on a Windows XP SP2 computer. How can I share a PPT file with another user and both of us be able to track changes? Thanks. Tag: How to type a bullet point from vba? Tag: 386454
- Next
  - 1
    - Stretching WordArt In PPT2003 you could stretch text vertically or horizontally - but in 2007 it seems that this function no longer exists - but essentially treats all text the same - it maintains the proportions of the fonts. This is a big step backwards if true - despite the great 3-D effects that you can otherwise apply. Am I missing something? Tag: How to type a bullet point from vba? Tag: 386447
  - 2
    - Opening Excel Files from Powerpoint VBA I need to open some excel files from powerpoint VBA and also to copy some cells over to one slide. I don't know how to write the vb code in powerpoint. Does anyone know? thanks Tag: How to type a bullet point from vba? Tag: 386446
  - 3
    - vids:xvid decompressor When I try and follow the instructions to put video into powerpoint, it returns the error message: video not available cannot find 'vids:xvids' decompressor I can view the video through the media player. Do you have any ideas? Please return me!!! Tag: How to type a bullet point from vba? Tag: 386445
  - 4
    - How do I share a power point presentation? I want to be able to share a power point presentation so that if others have it open I can still make edits to the presentation. Thanks! Tag: How to type a bullet point from vba? Tag: 386443
  - 5
    - Hardware acceleration in 2007 I've had PPT 2007 installed on two very powerful laptops but find that hardware acceleration just doesn't work like it did in 2003. With HA enabled the result is the same on both computers: Problem #1: the object animations do not play out in the slide preview - everything just appears (but play correctly with HA off) Problem #2: when playing the slideshow HA has no affect on the speed whatsoever - and is sometimes even slower. Problem #3: all the object animations are slower with much faster computers in PPT 2007 than they were with slower computers in PPT 2003 It seems that MS has managed to just break the hardware acceleration function between versions. I can't be the only one who has this problem. Config: Dell XPS M1530 Intel Duo Core 2.4 4Gb RAM 256Mb video RAM 200Gb, 7200 RPM HD Vista Ultimate All updates installed for Vista and Office Tag: How to type a bullet point from vba? Tag: 386442
  - 6
    - size of blinking cursor Can anyone help me change the size of the blinking cursor in PowerPoint 2007? I am running Vista Home Premium. I have increase the thickness option in the Ease of Access > Make the computer easier to see page. I see the dired effect in Word but there is no effect in PowerPoint. Thanks for your help in advance Clement Tag: How to type a bullet point from vba? Tag: 386441
  - 7
    - save Powerpoint on DVD for TV viewing Is there a way to save a Powerpoint on a DVD for TV viewing? -- jrs Tag: How to type a bullet point from vba? Tag: 386439
  - 8
    - Need alternative to Pixie One of the coolest, cutest little utilities, Pixie, accurately and reliably picks up color on screen and displays RGB and other values. Free, small, easy... ...and evidently incompatible with Vista, according to two clients who have tried it. Can anyone confirm this incompatibility (perhaps there is a workaround), and if confirmed, has anyone found an alternate product for grabbing color values from screen images that works with Vista? Many thanks... -- Rick Altman Author Why Most PowerPoint Presentations Suck...and how you can make them better www.betterppt.com Host The PowerPoint Live User Conference Sep 21-24 | San Diego CA www.powerpointlive.com Tag: How to type a bullet point from vba? Tag: 386438
  - 9
    - Steps to add a macro to a customized toolbar Can you add a macro to a customized toolbar so that it shows everytime you open PowerPoint 2003 that it will be there? If so, can you provide me with the steps to how to do it. Thanks! -- Cynthia Behnam Tag: How to type a bullet point from vba? Tag: 386432
  - 10
    - Macro won't run in slideshow view I am in the process of making a game for a meeting resembling Wheel of Fortune. I was planning on creating a macro for each of the letters of the alphabet so that when clicking on the letter it automatically poplulates the letter in the puzzle. The macro will run if i run it from clicking on tools/macro/macro and clicking run, but they won't work when i add them in the action setting for the slide show. I've tried both action buttons and just text and adding the new action setting so that on click it runs the macro, but they won't run. It underlines the text so i know it recognizes that there is an action associated with it, but when i click on it from the slideshow, it won't run. What am i doing wrong!?!?! I've also tried changing my security to low, but that doesn't make it work either. :( Tag: How to type a bullet point from vba? Tag: 386424
  - 11
    - How to Delete saved Slides from Recent Document? Power Point 2007. How to delete/remove one or two saved-slides with Thumtack on the right from Recent Document? Thanks for your help in advance. Tag: How to type a bullet point from vba? Tag: 386421
  - 12
    - How to turn of hyperlink virus warning? Hello All, when a Package to CD is created in PPT2003 with linked PDF documents, when the CD is run and the hyperlinked button to the PDF is clicked, a warning appears with "Some hyperlinks contain viruses or.....", but of course the pdf's do not contain any viruses, so... How do I get rid of these warnings?? Thanx! Guurt Tag: How to type a bullet point from vba? Tag: 386418
  - 13
    - NG test *test* does this get through again? (sorry) Tag: How to type a bullet point from vba? Tag: 386416
  - 14
    - sound in a different slide what should i do to make different slide (content for subtopic) with a different sound??? ... sorry if my english was broken Tag: How to type a bullet point from vba? Tag: 386414
  - 15
    - photo album - set default font for captions? I find the Photo Album with captions useful for managing photos and presentations but would like to change the default font for captions. Can anyone help? Tag: How to type a bullet point from vba? Tag: 386411
  - 16
    - Default shadow settings Is there a way to change the default shadow settings when I choose a lower-right drop shadow for example? I would like to have the default be 0% transparency and 10 for distance. It is a pain to have to set it for every object I create. I don't want to use format pickup, because I don't want all the attributes all the time. What about other object settings? I assume if there's a way for one then there's a way for all. Can this be done in the registry? It has to be getting it's defaults from somewhere. It sure would be nice if you could change these defaults through the interface. Tag: How to type a bullet point from vba? Tag: 386410
  - 17
    - POWERPOINT Presentations - Viewing Why can't I open a Powerpoint Presentation when I can see a Preview? Are there any file open blocks that I can unset? -- User Tag: How to type a bullet point from vba? Tag: 386402
  - 18
    - PP2003 takes 10 minutes to load templates after 2007 converter ins I installed MS 2007 file converter to work on PP2007 files using PowerPoint 2003 but now PP 2003 takes >10 minutes to bring up design templates using 100% CPU. Tag: How to type a bullet point from vba? Tag: 386401
  - 19
    - search & replace carriage returns Hi, Sorry if this has been asked recently or is obvious. I did not find the answer in the FAQ. 1. Is it possible to change settings so that hidden characters (carriage returns, tabs, spaces etc.) are shown, e.g. like in MSWord? 2. Is it possible to search for such characters without using VBA? I´m using MSPowerpoint 2003. TIA Örjan Tag: How to type a bullet point from vba? Tag: 386400
  - 20
    - Change font size and colour in footer through VBA Hi, I am using the code below to transfer data from an Access 2003 table to be displayed in PowerPoint. Currently, it displays a footer, along with the date and slide number. How do I go about adjusting the font size and colour of the text in the footer? (Sorry about the line breaks) Thanks, Anthony My Code here: *********** Dim PPApp As Object 'late binding Dim PPPres As Object Dim PPSlide As Object Dim db As Database, rs As Recordset Dim strSql As String Set PPApp = GetObject(, "PowerPoint.Application") If PPApp Is Nothing Then 'no existing application is running Set PPApp = CreateObject("PowerPoint.Application") End If If PPApp Is Nothing Then 'not able to create the application MsgBox "The application is not available!", vbExclamation+vbOKOnly,"Help." End If 'Open up a recordset on the employee table. Set db = CurrentDb strSql = "SELECT * From [Employee] WHERE (Status = True);" Set rs = db.OpenRecordset(strSql) Set PPPres = PPApp.Presentations.Add With PPApp While Not rs.EOF With PPPres.Slides Set PPSlide = .Add(rs.AbsolutePosition + 1, 2) PPSlide.HeadersFooters.Footer.Visible = True PPSlide.HeadersFooters.Footer.Text = "My Footer Text Here." PPSlide.HeadersFooters.DateAndTime.Visible = True PPSlide.HeadersFooters.DateAndTime.UseFormat = True PPSlide.HeadersFooters.DateAndTime.Format = 1 PPSlide.HeadersFooters.SlideNumber.Visible = True PPSlide.Shapes(1).TextFrame.TextRange.Text = UCase(CStr(rs.Fields("EmployeeID").value)) PPSlide.Shapes(2).TextFrame.TextRange.Text = "Name = " & CStr(rs.Fields("FirstName").value) & vbCrLf & _ "Surname = " & CStr(rs.Fields("Surname").value)& vbCrLf & _ "Phone = " & CStr(rs.Fields("Phone").value) & vbCrLf & _ "Level = " & CStr(rs.Fields("Level").value) PPSlide.Shapes(1).TextFrame.TextRange.Characters.Font.Size = 30 PPSlide.Shapes(2).TextFrame.TextRange.Characters.Font.Size = 26 PPSlide.Shapes(2).TextFrame.TextRange.Characters.Font.Color = vbBlue End With rs.MoveNext Wend End With PPPres.SlideShowSettings.Run Set PPApp = Nothing Set PPSlide = Nothing Set PPPres = Nothing End If End If Tag: How to type a bullet point from vba? Tag: 386399
  - 21
    - Screen Tips only show for a second, PowerPoint 2007 When I rest my mouse pointer over something on the ribbon the screen tips either show up for just a second or not at all. I did check and they are enabled. How can I get them to show up for more than just a second. They did before I don't know why they stopped. Tag: How to type a bullet point from vba? Tag: 386395
  - 22
    - PPT 2007 - 3-D Cube Hi, I would like to draw a 3-D cube, with 3 surfaces and each surface represent respective segments of product types, geographical share and brand names. Within each surface (segment), the proportion of product types, geographical share and brand names may vary, hence I like to use different colors to represent them. Can I create a SmartArt object for this ? and if so, how ? Thanks very much. EK Tag: How to type a bullet point from vba? Tag: 386391
  - 23
    - PPT Online and VISTA I've posted this before, but can't find the posting or similar questions. We've had a PPT 2003 presentation on our website for several years. On XP computers, the presentation automatically opens and plays in full-screen mode when the link is accessed. On VISTA computers, the PPT opens in the create/edit mode requiring manual starting. Anyone have any comments or ideas about this? Thanks. Tag: How to type a bullet point from vba? Tag: 386385
  - 24
    - Power Point Slide show not working correctly I recently sent a copy of a Power Point slide show, that I had received, to both my daughters. Both of them are using Windows XP and Office 2007. On one computer the show runs correctly (as it does on my Windows XP and Office 2003) but on the other it does not show text in a box which "fades in". What could be causing this? I have opened the file and saved it as html in order to see what types of files are within the slide show and there are no swf files which I thought may be causing the problem. The files within are htm, css, jpg, gif, js, wmf, wav and xml. Where to now? Tag: How to type a bullet point from vba? Tag: 386383
  - 25
    - Slide masters in PP 2007 I have created a new 'Text Only' slide master in a presentation. However, for some reason I now have 22 instances of the 'Title & Content' Master, and cannot delete them. Each time I use the custom master, it seems to generate a copy of the Title master. I do not seem to be able to delete any masters. Any suggestions? Thanks Tag: How to type a bullet point from vba? Tag: 386377

I need to type some text including a bullet point in a cell of a table, how
can I specify the bullet point in the code?

thanks,

Lily

Top

RE: How to type a bullet point from vba? by john

john
Thu May 08 14:02:12 CDT 2008

Try setting Shape.TextFrame.TextRange.ParagraphFormat.Bullet to msoTrue for
the relevant Cell
--
-------------------------------------------
Amazing PPT Hints, Tips and Tutorials

http://www.PPTAlchemy.co.uk
http://www.technologytrish.co.uk
email john AT technologytrish.co.uk

"Lily" wrote:

> I need to type some text including a bullet point in a cell of a table, how
> can I specify the bullet point in the code?
>
> thanks,
>
> Lily

Top