Updated June 12, 2023
PART- 14 – VBA (Visual Basic) ActiveX Controls
Transcript for Video – VBA (Visual Basic) ActiveX Controls
Video on VBA (Visual Basic) ActiveX Controls – Now that we have learn the dynamic way of updating our sheet as per the sectors let us play with this worksheet more and you know figure out more interesting things what I’ll do is you know I’ll create this sheet 3 and I’ll call this sheet 3 as a data filter sheet and this time I want is that you now probably you know if I choose I want to create some option here if I choose banks the whole list of banks actually should get populated if I select materials then the list of materials should get populated if I select utilities only the stocks which are in utilities should get populated so I am just taking step ahead and since you know in sheet 2 we had only shorted for banks in this data filter sheet I want that all the other should be given an option so let me kind of go here in Developer and kind of show you what exactly I am looking forward to so again between form control and active X controls you know since I want to codding language and invisible layer behind the this sheet so that I can change color of this form I will choose active X control and right click here and change the properties and going to caption I’ll call this as banks now I’ll also introduce button for others as well and the here I’ll call this as materials so idea or the question here is that if I click on banks, banks should be populated if I click on materials the stock which are materials classified will get populated so likewise for utilities and likewise for software so let me create icons for those as well going to software and last we have utilities infect you know before you look at the actual solution I would advise you to why you know kind of try this exercise it will be good exercise to actually look at if you can kind of you know complete this on your own so I’ll stop here and you kind of discuss the solution in another video.