RibbonX 05 - Dynamic ComboBox, DropDown Control for Excel CustomUI

Build First-Class UI Directly into App Ribbon. RibbonX full e-course. 100% free. XML samples included. For more check: vbaa2z.blogspo...
Subscribe, Like, and Comment. 🙏Thanks for watching.
You can now support by buying any of the Projects or Source Code.
📥Downloads: pamaitech.com/...
👍 Support: paypal.me/pama...
✉️ Contact: [e-mail]
📌What to watch next:
Playlist: www.youtube.co...
Videos: www.youtube.co...
#VbaA2z

[@debbiefairbanks916]

Your videos are great and your help solving a problem means I can continue with my project. Thank so much for your help.

[@VBAA2Z]

Glad you found them useful. Do not forget to support the channel, thanks. :)

[@DavidRymell]

Thank you very much: that was excellent! Very informative and useful.

[@VBAA2Z]

You're very welcome!

[@holieh5301]

Exactly what I need. Thanks Pamai

[@VBAA2Z]

So glad!

[@bnancy3699]

Keep it up Pamai. Thanks for brilliant tut.

[@VBAA2Z]

Thanks, will do!

[@glegeant]

Thank you very much. Quite informative. I came across your channel, as I was in search of a way of dynamically updating/refreshing a list in a combobox after new items have been added or deleted, without having to close and reload the Excel spreadsheet.
Keep on the good work! Cheers Gerard

[@VBAA2Z]

You're very welcome!

[@VBAA2Z]

thanks for watching!

[@user-dp5xg7wf2b]

Thanks a lot Pamai!

[@VBAA2Z]

My pleasure!

[@mazaisipamai8800]

Just wow 😮👍

[@VBAA2Z]

Thanks Azai

[@GiselleBrat]

thanks for the tutorial!

[@VBAA2Z]

Happy to help!

[@annanamdau1605]

👍👍👍

[@VBAbyMBA]

What macro should I need to insert textbox into word document?
-The size of the box should adjust as more text is written
-The box shall stay together in case of page-break during writing.

[@empathic_mimicry]

Very nice videos. Is is possible to create an Excel Add-in with bespoke ribbon. But before you make it an add-in you populate a table or known range with a list of values or text. Then you convert it to an addin.
I would like either a combo box or dropdown to be completely dynamic and refresh against the values in the list and add-in the number of options in the dropdown automatically?
Doing it this way mean a no-code interface and will open up other avenues for me, for example dynamic hyperlinks to file location etc.
Thank you very much for making these videos free!

[@VBAA2Z]

Yes, dynamic Ribbon can be auto created

[@masterhenyo7988]

This is geat, can you go a bit futher like how to assing a default value in the drop down? And how to refresh it if the drop down label source is expanded thanks in advance

[@VBAA2Z]

You can follow this approach mentioned in RibbonX 06.
ua-cam.com/video/4UYqTlnz6ck/v-deo.html

[@jo.si_911]

First of all...Amazing Channel👍 I have just a short question. How do i retrieve the value of the selected item in a dropdown and populate a label of another control e.g. a button dependent on the selected item in the dropdown??? I just do not get it..😪
Thx in advance

[@mrbagins3774]

Hi, if I wanted to utilise a table range from active sheet, how could this be achieved ?

[@efernandes67]

Great! Pamai, if you insert another fruit on the list, how can the dropdown be update without the need to save and reopen the file?

[@VBAA2Z]

We'll talk about iRibbonUI object and discuss how to accomplish this in next video.
For dynamicMenu you can simple use
getContent and invalidateContentOnDrop events.

Hi Bro. 12:29
After choosing "Banana". How to reload selection in dropdown back to the first value "Apple".
Plz Help me Code VBA. Thank Bro

[@VBAA2Z]

Check this episode and refer to checkbox Control Invalidate example
ua-cam.com/video/sbHrUFLSaDo/v-deo.html

[@engfernandolsf]

there is any option to do a search box in a custom ribbon?

[@VBAA2Z]

Yes you can add EditBox which can be like a textbox to get input and button as well to get the input and execute your search.
ua-cam.com/video/4UYqTlnz6ck/v-deo.html

[@MJLCabral]

Fantastic, thanks

[@VBAA2Z]

Glad you liked it!

[@MJLCabral]

Hi Pamai, is it possible to introduce an image (photograph), instead of an icon, which is in a certain directory in a Combobox or Dropdown, in the Excel Ribbon?
If so, do you have a video that explains how?

[@VBAA2Z]

Hi JCabral, thanks for visit. I'll to recheck dont remember on top of my head

[@MJLCabral]

Hi, Is it possible to dynamically add images to DropDown items that are in a spreadsheet tab? How?

[@VBAA2Z]

I haven't tried it but it should be possible.

[@MJLCabral]

@@VBAA2Z Will you try to make it and then share?

[@VBAA2Z]

Sure, will have to check and come back on this.

[@MJLCabral]

@@VBAA2Z Great

[@MJLCabral]

@@VBAA2Z Any news?