IS it possible to create a drop down that works outside presentation mode. Ideally, I want to share a presentation that I want ppl to update and I want to add a drop down list for them to click first before updating the slide.
how would you integrate this dropdown menu with a dynamic chart from excel? I know how to create dynamic charts using index and match with a dropdown menu, but I was wondering if we can do this in PPT too?
Hey! Thanks for this. I have a question for you. Can this drop-down list be used whilst in 'Edit' mode of ppt or can it only be used whilst on 'Slideshow' mode?
I am adding numbers like in this list, however, next to one of the numbers I want to add the word Standard between parenthesis, is there any way to do that?
Thanks a lot! Can you give me an example, how to make a message "correct" and "incorrect" appear on the screen, when the user chooses a particular option from the list?
Very Helpful! But I have a Trouble... when I change the meaning of the items of the list, in the slideshow get doubled,as example 1,2,3,4,1,2,3,4. Do u know if I have to change some properties of the combobox? Thank u!
Hi, how would you create multiple drop down list boxes with the same drop down list on the same slide. I wanted to create drop downs in order to allow someone to select a choice for multiple items in the power point. When I copy the drop down it doesn't seem to keep the list.
If you want to add multiple combo box in 1 slide u must change the code to: Private sub youboxname1_gotfocus () If yourboxname1 = 0 then With yourboxname1 Yourboxname1.additem "item1" Yourboxname1.additem "item2" Yourboxname1.listrows = 2 End with End if End sub Repeat code above as much as you want depends on your combobox. Good luck
Very helpful guide, thanks!But nontheless I receive an error: "Error while compiling Ambiguous name AddDropDownItems" whenever I try to add multiple dropdown lists on one slide. Could you tell me how to edit the code accordingly? It is clear for me, that I have to adjust ComboxBox1 to ComboBox2 etc.. Thanks in advance!
This will work, Try this. Private Sub ComboBox1_GotFocus() If ComboBox1.ListCount = 0 Then AddDropDownItems End Sub Sub AddDropDownItems() ComboBox1.AddItem "1" ComboBox1.AddItem "2" ComboBox1.AddItem "3" ComboBox1.AddItem "4" ComboBox1.ListRows = 4 End Sub Private Sub ComboBox2_GotFocus() If ComboBox2.ListCount = 0 Then AddDropDownItems2 End Sub Sub AddDropDownItems2() ComboBox2.AddItem "1" ComboBox2.AddItem "2" ComboBox2.AddItem "3" ComboBox2.AddItem "4" ComboBox2.ListRows = 4 End Sub
+Umang Kanani I'm in the process of searching a solution for it. I have already got requests from many people subscribe to my channel I'm gonna make a video on it. Thx
Srivastav Nanduri well the thing is that what I'm writing it to long and you can't see the whole text. I was talking about a horizontal scroll bar? (If that exists) but then I messed with the list width and know I can see the whole text
Never tried to get a horizontal scroll bar. And yes tweaking the width will do the job. But since you say that your writing long text, give me a day time, I'll look into a way of getting the scroll bar and get back to you
Has anyone had trouble with the dropdowns working and then when you save and reopen you have to run them all individually again for it to work? I am new to macros in powerpoint to I am wondering if I am missing a step?
thnx for the video kindly tell me how to insert hyperlinks on it. for example if I select figure 3 from drop down list and it should go to slide number 3. thnx
Hi Srivastav, posting was very helpful. But I cannot create a referral code to move to another slide. So I got so far as creating the drop down list but cannot refer a drop down to a particular slide. Created main links as INTRO | SITES | PRODUCTS - each one has three more drop down lists which refers to different slides. Can you please help me with it. I used With SlideShowWindows(1).View .GotoSlide 2, msoTrue End WithBut it is not working. It gives error. Requesting your help.Regards
+tylerjam1980 yeah sure. Of course change Page 1, Page 2 etc to your own words. I placed my drop down in a master page thus making it easier to change if I added new slides. Hope it helps. Private Sub ComboBox1_GotFocus() If ComboBox1.ListCount = 0 Then AddDropDownItems End Sub Sub AddDropDownItems() ComboBox1.AddItem "Page 1" ComboBox1.AddItem "Page 2" ComboBox1.AddItem "Page 3" ComboBox1.AddItem "Page 4" ComboBox1.AddItem "Page 5" ComboBox1.ListRows = 5 End Sub Private Sub ComboBox1_Click() Dim i As Integer i = Me.ComboBox1.ListIndex Select Case i 'first item Case Is = 0 ActivePresentation.SlideShowWindow.View.GotoSlide 1 Case Is = 1 ActivePresentation.SlideShowWindow.View.GotoSlide 2 Case Is = 2 ActivePresentation.SlideShowWindow.View.GotoSlide 3 Case Is = 3 ActivePresentation.SlideShowWindow.View.GotoSlide 4 Case Is = 4 ActivePresentation.SlideShowWindow.View.GotoSlide 5 End Select End Sub
Hi mate, could please to help me how can i figure out if i need the drop list like detail below: Option 1-> type Green with colour green fill in Option 2-> type Amber with colour orange fill in Option 3-> type red with colour red fill in Hopefully you can reply my question :)
@@NanduriSrivastav HI,thanks before, you still want to spare ur time to relief my comment. sure i can send email for the detail, but i was looking for ur emailed i dont found one, if you dont mind, could you please to inform ur email in here so i can send the detail to you right away
hi.. Thanks for the video. I would like to know how to copy paste same drop down created slide multiple times. I have tried to copy paste it, but macros are missing. Is there any easy way to copy paste macros slides ? Thanks
It depens on how many drop down list you wrote on the code. I did it like that, I wrote four and then just copied 4. If you want another list you have to do the same process
Thanks - this was in fact very useful. So here's another problem I'm dealing with - I want to put pictures instead of text in the combo box. Any ideas?
Thank you for that, can you please me how I could use this menu to jump to a desired slide within the presentation? For example if I select the number 4 it will go to slide number 4.
Great video!! Thank you! I would like to know how to add another drop dow list in the same slide. When I tried to do it the code from the first drop down list appears and I have to idea how to add another code (I tried to add it after the first code and it didnt work)... THANK YOU!!! :)
Thank you!! Even to add other drop down list in other slide is a bit challenging (when I try to follow the same steps for the next slide (for example slide 2) it doesnt show me "slide 2" but slide 4.... i dont really know how to explain you but the point is that is not really working :(
Hi Maria, Thanks for waiting. Here is the code you can use but before inserting the code make sure you have made the required number of comboboxes in the presentation as shown in the video. I have taken three as an example. Code: Private Sub ComboBox1_GotFocus() If ComboBox1.ListCount = 0 Then AddDropDownItems End Sub Sub AddDropDownItems() ComboBox1.AddItem "1" ComboBox1.AddItem "2" ComboBox1.AddItem "3" ComboBox1.AddItem "4" ComboBox1.ListRows = 4 End Sub Private Sub ComboBox2_GotFocus() If ComboBox2.ListCount = 0 Then AddDropDownItems2 End Sub Sub AddDropDownItems2() ComboBox2.AddItem "1" ComboBox2.AddItem "2" ComboBox2.AddItem "3" ComboBox2.AddItem "4" ComboBox2ListRows = 4 End Sub Private Sub ComboBox2_Change() End Sub Private Sub ComboBox3_GotFocus() If ComboBox3.ListCount = 0 Then AddDropDownItems3 End Sub Sub AddDropDownItems3() ComboBox3.AddItem "1" ComboBox3.AddItem "2" ComboBox3.AddItem "3" ComboBox3.AddItem "4" ComboBox3.ListRows = 4 End Sub Thanks
@@NanduriSrivastav Thank you so much for this! Trying to create a document with multiple pull downs in Power Point and this was the only reference on how to do this I could find. Maybe a topic for a new video! The only thing I don't care about about it is that the pull downs are only activated in Presentation Mode. Do you know if there is anyway to allow for when it is not in Presentation Mode but in Editing Mode??? Your thoughts would be appreciated Srivastav.
+Lorraine Salac Hiya, yes you can, once you've placed the drop down, double click on it and then use the 'format' section to change the border, colours, etc. I would suggest using the drop down in a master page, thus making it easier to change.
Anyone know how to set it so that the drop down works in normal view and not just in slideshow mode?
Excellent Thank you. How do you add multiple boxes I keep getting errors
IS it possible to create a drop down that works outside presentation mode. Ideally, I want to share a presentation that I want ppl to update and I want to add a drop down list for them to click first before updating the slide.
Did u figure it out how to do it? Im trying to do the same thing
Hello Nanduri, I was wondering how could i create multiple indepedent dropdown list in ppt?
Why is this so difficult. I just want to make a simple box with different letter choices. No actions. Why can't I find this info anywhere?
Great stuff. I see this is 6 years old, I hope you are still making content. Thanks!
It's very helpful. Thank you very much :)
how would you integrate this dropdown menu with a dynamic chart from excel?
I know how to create dynamic charts using index and match with a dropdown menu, but I was wondering if we can do this in PPT too?
Have you found the way? Bcs currently I'm searching for this.
Hey! Thanks for this. I have a question for you. Can this drop-down list be used whilst in 'Edit' mode of ppt or can it only be used whilst on 'Slideshow' mode?
+Amy Morris in edit mode I think no it can't be used only in slide show mode
+Amy Morris in edit mode I think no it can't be used only in slide show mode
It didn't work for me. WHen I went back to the Powerpoint slide it was still just an object. No pulldown menu. :(
I am adding numbers like in this list, however, next to one of the numbers I want to add the word Standard between parenthesis, is there any way to do that?
same for me ....
Is there a way to view/select the drop down menu outside of present mode??
Thanks a lot! Can you give me an example, how to make a message "correct" and "incorrect" appear on the screen, when the user chooses a particular option from the list?
I do this but there is one error pop up OBJECT REQUIRED could you please let me know where I'm making mistakes
Very Helpful! But I have a Trouble... when I change the meaning of the items of the list, in the slideshow get doubled,as example 1,2,3,4,1,2,3,4. Do u know if I have to change some properties of the combobox? Thank u!
Could u please email me the issue with reproduction steps so I can help u better.
I have the same issue ... can you please help me... ? My list is looping another 2 times
Hi, how would you create multiple drop down list boxes with the same drop down list on the same slide. I wanted to create drop downs in order to allow someone to select a choice for multiple items in the power point. When I copy the drop down it doesn't seem to keep the list.
+Doug Dewan I'm sorry but it cannot be core u have to create a new one Everytime
I am unable to make multiple copies this drop down. Can you show how this can be done
If you want to add multiple combo box in 1 slide u must change the code to:
Private sub youboxname1_gotfocus ()
If yourboxname1 = 0 then
With yourboxname1
Yourboxname1.additem "item1"
Yourboxname1.additem "item2"
Yourboxname1.listrows = 2
End with
End if
End sub
Repeat code above as much as you want depends on your combobox.
Good luck
Alguien sabe porque me marca doble cuando lo pongo en presentación en algún proyector. Hice todos los pasos, pero no deja ver tal cual
Thanks for the Video.could you help me how to insert text contents in the drop down ,where in I can present the contents . Thank You
Thank you! But I have a question... How can i fill each dropdown point with a different color ? Maybe somebody can help me out?
Doesn't work for me... The list still remain void
Same For me
Thank you. Very informative and straightforward content.
Very helpful guide, thanks!But nontheless I receive an error: "Error while compiling Ambiguous name AddDropDownItems" whenever I try to add multiple dropdown lists on one slide. Could you tell me how to edit the code accordingly? It is clear for me, that I have to adjust ComboxBox1 to ComboBox2 etc.. Thanks in advance!
+Jan Sch I'll try it first and confirm u cos even I never thought of putting two combo boxes
I also have this problem. Did you find a resolution that worked?
This will work, Try this.
Private Sub ComboBox1_GotFocus()
If ComboBox1.ListCount = 0 Then AddDropDownItems
End Sub
Sub AddDropDownItems()
ComboBox1.AddItem "1"
ComboBox1.AddItem "2"
ComboBox1.AddItem "3"
ComboBox1.AddItem "4"
ComboBox1.ListRows = 4
End Sub
Private Sub ComboBox2_GotFocus()
If ComboBox2.ListCount = 0 Then AddDropDownItems2
End Sub
Sub AddDropDownItems2()
ComboBox2.AddItem "1"
ComboBox2.AddItem "2"
ComboBox2.AddItem "3"
ComboBox2.AddItem "4"
ComboBox2.ListRows = 4
End Sub
Incredibly helpful! Thank you so much.
Thanks for the help! but what if you wanted a drop down list of colors? how would we put a code for that?
+Umang Kanani I'm in the process of searching a solution for it. I have already got requests from many people subscribe to my channel I'm gonna make a video on it.
Thx
Dude this was really helpful. I still have a question, how can you add a scroll bar to that drop list??
Can you brief your question. What kind of scroll bar like if you add more data, that thing will automatically add one
Srivastav Nanduri well the thing is that what I'm writing it to long and you can't see the whole text. I was talking about a horizontal scroll bar? (If that exists) but then I messed with the list width and know I can see the whole text
Never tried to get a horizontal scroll bar. And yes tweaking the width will do the job. But since you say that your writing long text, give me a day time, I'll look into a way of getting the scroll bar and get back to you
Man me again, I now know what I want: a vertical scroll bar, any thoughts on that?
Has anyone had trouble with the dropdowns working and then when you save and reopen you have to run them all individually again for it to work? I am new to macros in powerpoint to I am wondering if I am missing a step?
i am having the same issue
Hi I love the 3 videos you've done! But can i ask , how do i add another dropdown box list , on the same slide?
Add the same code again but with a different id
Srivastav Nanduri What different ID should I put? And where should I indicate the different ID?
Srivastav Nanduri Thank you for replying! 🙏🏼
Make combibox1 to combibox2 in the second code and also the function in the start to some other name of ur choice
I hope that works. If it doesn't, email me and I'll send u the final code after I figured it out
Doesn't run. Still shows as an object.
thnx for the video
kindly tell me how to insert hyperlinks on it. for example if I select figure 3 from drop down list and it should go to slide number 3. thnx
How to wrap text to make it fit into a smaller box?
Hi Nanduri, This video was really helpful.
Additionally, could you please help me in linking the drop-down list with a dynamic table or chart in PPT?
+Mridupaban Khargharia I have requests for it already I'll be making a separate video in the near future. Subscribe to get updates
Thank you for your prompt response! Certainly I'll subscribe to your channel
Thank you so much for the video, it really helped me in creating a request form.
Very Good!!!! and what about a code for a drop-down list box with interior diferent colors for correct and wrong answer. Thank you so much!
You may try looking out on that from Visual Basic docs from Microsoft
i am using powerpoint 2010 but is not working
Very helpful thanks!
Hi Srivastav, posting was very helpful. But I cannot create a referral code to move to another slide. So I got so far as creating the drop down list but cannot refer a drop down to a particular slide. Created main links as INTRO | SITES | PRODUCTS - each one has three more drop down lists which refers to different slides. Can you please help me with it.
I used
With SlideShowWindows(1).View .GotoSlide 2, msoTrue End WithBut it is not working. It gives error. Requesting your help.Regards
+Abhijit Chatterjee I'll look into it and can u please attach a screenshot via hangouts
+Abhijit Chatterjee I'll look into it and can u please attach a screenshot via hangouts
+Abhijit Chatterjee I'll look into it and can u please attach a screenshot via hangouts
+Abhijit Chatterjee I'll look into it and can u please attach a screenshot via hangouts
+Abhijit Chatterjee I'll look into it and can u please attach a screenshot via hangouts
not to worry I've figured it out and all working. Thank anyway.
+Richard B Hi matey, Can you please let me know you managed to link to another slide?
+tylerjam1980 yeah sure. Of course change Page 1, Page 2 etc to your own words. I placed my drop down in a master page thus making it easier to change if I added new slides. Hope it helps.
Private Sub ComboBox1_GotFocus()
If ComboBox1.ListCount = 0 Then AddDropDownItems
End Sub
Sub AddDropDownItems()
ComboBox1.AddItem "Page 1"
ComboBox1.AddItem "Page 2"
ComboBox1.AddItem "Page 3"
ComboBox1.AddItem "Page 4"
ComboBox1.AddItem "Page 5"
ComboBox1.ListRows = 5
End Sub
Private Sub ComboBox1_Click()
Dim i As Integer
i = Me.ComboBox1.ListIndex
Select Case i
'first item
Case Is = 0
ActivePresentation.SlideShowWindow.View.GotoSlide 1
Case Is = 1
ActivePresentation.SlideShowWindow.View.GotoSlide 2
Case Is = 2
ActivePresentation.SlideShowWindow.View.GotoSlide 3
Case Is = 3
ActivePresentation.SlideShowWindow.View.GotoSlide 4
Case Is = 4
ActivePresentation.SlideShowWindow.View.GotoSlide 5
End Select
End Sub
Hi
Thank you for the video. How can i do, at the place of number to have pictures?
I think with that implementation it isn't possible.
Hi mate, could please to help me how can i figure out if i need the drop list like detail below:
Option 1-> type Green with colour green fill in
Option 2-> type Amber with colour orange fill in
Option 3-> type red with colour red fill in
Hopefully you can reply my question :)
Could u write a prototype code and mail me on my email. I'll look into it and find if there are any possibilities
@@NanduriSrivastav HI,thanks before, you still want to spare ur time to relief my comment.
sure i can send email for the detail, but i was looking for ur emailed i dont found one,
if you dont mind, could you please to inform ur email in here so i can send the detail to you right away
Hi @srivastav need your email so i can send the detail with you, please
Hi Erwin , did you get the chance to get the code ? I m looking for it also
Hi, I am following the same steps as in the video but getting an error "Object missing" Any idea how to resolve this?
+Kritika Choudhary can u elaborate ur issue or connect to me via hangouts
+Kritika Choudhary can u elaborate ur issue or connect to me via hangouts
hi.. Thanks for the video.
I would like to know how to copy paste same drop down created slide multiple times. I have tried to copy paste it, but macros are missing. Is there any easy way to copy paste macros slides ?
Thanks
+Rohit Phalak no u can't copy paste because u define objects for each drop down separately
I want same objects. Basically same slide in multiple times
+Rohit Phalak I think it is not possible
It depens on how many drop down list you wrote on the code. I did it like that, I wrote four and then just copied 4. If you want another list you have to do the same process
Please help me how to add a hyperlink of a picture in it
Thanks - this was in fact very useful. So here's another problem I'm dealing with - I want to put pictures instead of text in the combo box. Any ideas?
+kmeisterus ya but I'm not sure if it will work or not so let me try once and if it works I'll guide u on how to do it
+kmeisterus ya but I'm not sure if it will work or not so let me try once and if it works I'll guide u on how to do it
Thank you for that, can you please me how I could use this menu to jump to a desired slide within the presentation? For example if I select the number 4 it will go to slide number 4.
+Richard B yes it will
+Richard B yes it will
Could you please tell me how?
+Richard B can u communicate with me on hangouts
+Richard B can u communicate with me on hangouts
Great Video - thanks - Perfect , Quick Solution.
Bro ur the Goat thanks for this so much
Great video!! Thank you! I would like to know how to add another drop dow list in the same slide. When I tried to do it the code from the first drop down list appears and I have to idea how to add another code (I tried to add it after the first code and it didnt work)... THANK YOU!!! :)
+Maria Maldonado let me check and get back to u never came across such issue
Thank you!! Even to add other drop down list in other slide is a bit challenging (when I try to follow the same steps for the next slide (for example slide 2) it doesnt show me "slide 2" but slide 4.... i dont really know how to explain you but the point is that is not really working :(
+Maria Maldonado I'll surely look into both the matters and come back. Thanks
Hi Maria,
Thanks for waiting. Here is the code you can use but before inserting the code make sure you have made the required number of comboboxes in the presentation as shown in the video. I have taken three as an example.
Code:
Private Sub ComboBox1_GotFocus()
If ComboBox1.ListCount = 0 Then AddDropDownItems
End Sub
Sub AddDropDownItems()
ComboBox1.AddItem "1"
ComboBox1.AddItem "2"
ComboBox1.AddItem "3"
ComboBox1.AddItem "4"
ComboBox1.ListRows = 4
End Sub
Private Sub ComboBox2_GotFocus()
If ComboBox2.ListCount = 0 Then AddDropDownItems2
End Sub
Sub AddDropDownItems2()
ComboBox2.AddItem "1"
ComboBox2.AddItem "2"
ComboBox2.AddItem "3"
ComboBox2.AddItem "4"
ComboBox2ListRows = 4
End Sub
Private Sub ComboBox2_Change()
End Sub
Private Sub ComboBox3_GotFocus()
If ComboBox3.ListCount = 0 Then AddDropDownItems3
End Sub
Sub AddDropDownItems3()
ComboBox3.AddItem "1"
ComboBox3.AddItem "2"
ComboBox3.AddItem "3"
ComboBox3.AddItem "4"
ComboBox3.ListRows = 4
End Sub
Thanks
@@NanduriSrivastav Thank you so much for this! Trying to create a document with multiple pull downs in Power Point and this was the only reference on how to do this I could find. Maybe a topic for a new video! The only thing I don't care about about it is that the pull downs are only activated in Presentation Mode. Do you know if there is anyway to allow for when it is not in Presentation Mode but in Editing Mode??? Your thoughts would be appreciated Srivastav.
Is applicable for 2016 ?
Good job, very helpful.
Is there a way to run automatically? I need to share this with users, and they won't know how to run the macros before...
Hmm currently I can't provide any support on that. Thanks
What if I want to change the design of the drop down list. Can I do that?
+Lorraine Salac no I'm sorry I don't know at least u can always play with visual basic thx
+Lorraine Salac no I'm sorry I don't know at least u can always play with visual basic thx
+Lorraine Salac
Hiya, yes you can, once you've placed the drop down, double click on it and then use the 'format' section to change the border, colours, etc. I would suggest using the drop down in a master page, thus making it easier to change.
Can you color fill also
Thanks it is very useful to me
+Sai Prashanth thanks
doesn't work anymore
yeeeaa.....!!! :D soooo Yeaa
Can you copy and paste the code in your comment.
+Jerome Kinzey I have already given that in the video description
Your code is wrong
Muito obrigada 👏👏👏
no se de ingles y no entendi nada
hola papu
HOLI ME LLAMO EN ROBLOX GATOGATOCATCAT88
Terrible Audio :(