VBA UI UX-11: How to install Common Controls. ListView, TreeView, FlatScrollBar, ImageList etc.

[@rakhitanwarrajpoot1531]

thank you this is what i am looking for

[@VBAA2Z]

You are welcome!

[@GiselleBrat]

many thanks Sir

[@VBAA2Z]

Most welcome

[@LookHowSmartYouAreGetting]

I've been watching & liking all your videos and Subscribed! Really appreciate your detailed walk-thrus.. Extremely helpful; awesome teacher! Now, I've got a question, if I were to create this App, package up the same set of files you provided and placed it out on a server in a project-specific folder for the team to use, would each user that clicked on it to open and use it also encounter issues until they go through all the trouble to go download additional controls to their laptop, go through the Register Run process, etc.???? (if so, how do we mk this as painless as possible to implement). Are there several other settings they'd need to go manually set up on their machine before everything would work? I know when I've pushed VBA apps out in the past, (10-15 yrs ago) there were several things each user had to manually set up within their Excel, PPT or Word, check mark boxes to allow Object models to work, to pass things from Excel into PPT or Word, etc.. For example, I created Userforms to collect data from many diff locations who all had access to a central server.. they'd open the .XLSM file (Form) specific to their Region.. upon SUBMIT/Save/Close, that data would auto-feed upward into master collection files (Excel). Then the CEO/VPs of the company had their Executive Dashboard file they could open and see up-to-date metrics. (when they opened the XLSM file, it looked like a website to them by opening in full screen with the traditional menus hidden).. if they wanted a PPT, they could click a button to generate an output (from that Excel app) of 4-square slides (PPT) they could take to meetings to discuss.) Have not had a job purpose to use VBA since 365' came out so, I'm re-teaching myself all that I've forgotten in the past 15 years.. not sure if the more current 365' software takes care of some of those past roadblocks automatically with Object models and don't want users of my 'Dashboard of this decade' to encounter similar issues of back-end set-ups that they're not familiar with... Thanks again, happy to continue to support! (perhaps a short video on this topic would be helpful?, perhaps it's up ahead and I've just not encountered it yet?) "How to Roll Out Your New App" - Lessons Learned, things that might go wrong, how to avoid w/ pre-planning..

[@holieh5301]

Many thanks

[@VBAA2Z]

You are welcome

[@Jaiemimoyu]

Thank you for sharing

[@VBAA2Z]

Thanks for watching!

[@susilsxzen-ff1zn]

Great work

[@VBAA2Z]

thanks!

[@mramsey6887]

Thank you for this. Your advice is precise and just what I need. Please can you answer this question: If the end user does not have these installed, will the workbook still function correctly? And, if not, can they be installed onto an Apple mac pc?

[@VBAA2Z]

I am not a mac user so not sure if all features will work in Mac office. For windows, if ListView, inbuilt DatePicker does not work you can install commons controls from Microsoft. kzbin.info/www/bejne/h3i9op2LfM19Z7M

[@baliongerewiong2194]

I have my listview control and imagelist control but I cant use the custom feature for both its giving me a message like Class not registered, Looking for Objects CLSID.{7EBDAAEI-DAAEI-8120-11CF-899F-00AA00688B10}, I cannot load image into list view because the class is not registered how do I fix this, I need some help, including the bar code control as well. Thankyou

[@VBAA2Z]

1 - First ensure common controls are installed. kzbin.info/www/bejne/h3i9op2LfM19Z7M 2 - and 1 is complete, registering the MSSTKPRP.DLL will fix this issue. bit.ly/2RcEpWG All the best!

[@baliongerewiong2194]

Thankyou very much Sir I will try and if I have issue I will keep you posted thankyou

[@tai-yunyu2263]

Thank you so much , your videos are helpful! After installing it, my VBA Common Controls still did not update? could u give clue to fix it ? thanks .

[@VBAA2Z]

Date picker is not available in windows 10 latest updates and Windows 11

[@baliongerewiong2194]

Thankyou Chief I folwed your instruction and my error of MSSTKPRP.DLL has been fix thankyou so much and the last thing is how do i installl the bar code control in the active x controls? Its still missing in my active X controls

[@VBAA2Z]

Baliong, good to hear you were able to fix the error. try this navigation from Developer tab -- > Insert---> More Controls -- > Microsoft Listview (or browse for more controls)

[@baliongerewiong2194]

Thanks I'll try my best to ensure that the bar code control is installed in the acive x control, thankyou very much again, looking forward for more of your videos on excel userform database development

[@mdtazmir7924]

hi bro,how to make, TreeView image list like,example TreeView inside any catgory click,right side side image viewer this image zoom in and zoom out, pls make video

[@VBAA2Z]

thanks for your suggestion. Will review and come back

[@jeromesendon5354]

Is this lisview is available in 64bit

[@VBAA2Z]

Hi Jerome, listView like date picker will not work on 64-bit Excel. You can opt for Listbox Control or Customized table so it goes with your UI theme. Check below link for example. kzbin.info/www/bejne/maS4maR5g5V2eKs Also please subscribe for more videos. Thanks for your support. All the best!

[@VBAA2Z]

Download link: www.microsoft.com/en-us/download/details.aspx?id=10019

[@yagneshacharya2461]

how can i contact u personally? i got very complicated excel error in my excel and it can't explain here so please provide ur personal contact

[@VBAA2Z]

Please comment below or post it to stackoverflow.com/