Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-11-2022, 12:31 AM
tora1950 tora1950 is offline Powerpoint Menu Navigation in VBA (instead of hyperlinks) Windows 10 Powerpoint Menu Navigation in VBA (instead of hyperlinks) Office 2019
Novice
Powerpoint Menu Navigation in VBA (instead of hyperlinks)
 
Join Date: Mar 2022
Posts: 1
tora1950 is on a distinguished road
Default Powerpoint Menu Navigation in VBA (instead of hyperlinks)

Hello all,


My ppt has almost 100 slides, whereby 5 slides usually belong to one topic ("to the same package"). Now I would like to insert a menu window right at the beginning, so that you can jump to the slides and also get info about the slides. But since there are too many different topics, I don't want to make a listing with hyperlinks, because then I would have 20 different lines with hyperlinks.
I would prefer to create a menu window with 2 columns. In the first column there is the info, on the right side there is a list from which you have to select something (only the first field "Category" should be a mandatory field) and a button with which you can jump to the desired slides. Here is what it should look like:

"Category:" "a list with 5 topics opens here".
"Subcategory:" "here opens another list, which depends on the input of the category". Example: If you select "A" for the category, a selection of 4 options opens for the subcategory. If you select "B" for the category, a list with 6 options opens, and so on.
"Variant:" "Here there should be 2 variants to choose from".


"Information:" "Depending on the selection from the 3 lists, information always appears here as text" Example: I select only category, a text appears. I select a category and subcategory, the text changes again immediately. So after each change above, the info should update. And so on. So I would like to always enter the slide number.
And at the bottom there would be a button "Click to jump to slide". So depending on the entries, the button in the background updates the slide number to which you can jump directly.


The 3 lists at the top should be linked depending on the selection. I would therefore like (even if I have to do it very often) to use If... then... functions, if possible. Unfortunately I don't know much about VBA and would be grateful for any help.

Attached is a picture of what it should look like.



I've already searched a lot of things, maybe I'm looking for the wrong terms and couldn't find anything so far, as most of them only work with hyperlinks.


Thank you very much in advance!


PS: I do not know if I should
Attached Images
File Type: png VBA PPT.PNG (23.3 KB, 12 views)
Reply With Quote
  #2  
Old 03-12-2022, 06:28 PM
Guessed's Avatar
Guessed Guessed is offline Powerpoint Menu Navigation in VBA (instead of hyperlinks) Windows 10 Powerpoint Menu Navigation in VBA (instead of hyperlinks) Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

You haven't given us much to work with here. The data for the category/subcategory/option has to come from somewhere and will be an absolute pain to maintain if you don't have good rigour in setting up your file and maintaining it.

It will probably be most efficient to harvest this information from the slides themselves. Like reading through the slides to find out what layout is assigned, what is typed in the title or what is in the slide Notes page. This would allow the macro to build the lists dynamically.

To get you started, this is the code I played with to read the Titles on the slides and return these as a list and allow the user to type in a slide number to jump to it.
Code:
Private Sub cbCat_Click()
  Dim sMsg As String, aSlide As Slide, sList As String
  For Each aSlide In ActivePresentation.Slides
    Debug.Print aSlide.SlideIndex, aSlide.Shapes.Title.TextFrame.TextRange.Text
    sList = sList & aSlide.SlideIndex & vbTab & aSlide.Shapes.Title.TextFrame.TextRange.Text & vbCr
  Next aSlide

  sMsg = InputBox(sList, "Type slide number")
  SlideShowWindows(1).View.GotoSlide sMsg
End Sub
If you need further assistance, perhaps you could post a sample presentation so we can see where the list hierarchy information can come from.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Tags
navigation, power point, vba

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Navigation with Hyperlinks and Animation TryingHard PowerPoint 5 11-07-2019 08:51 AM
Powerpoint Menu Navigation in VBA (instead of hyperlinks) Navigation within a document - Hyperlinks Officer_Bierschnitt Word 4 12-15-2016 06:39 PM
Powerpoint Menu Navigation in VBA (instead of hyperlinks) Using Frames as fixed navigation toolbar with hyperlinks to jump to sections of a doc dani19 Word 1 04-12-2014 08:30 PM
Powerpoint Menu Navigation in VBA (instead of hyperlinks) Navigation in PowerPoint 2010 namedujour PowerPoint 4 08-27-2012 07:59 AM
Powerpoint Menu Navigation in VBA (instead of hyperlinks) Missing calendar menu (navigation pane) items? carolfarm Outlook 1 07-18-2012 12:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:39 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft