Dear thanks for sharing your knowledge with us, this is just my request you to kindly make full software making series where all your tricks and techniques use.....so we can focused on all Thanks & Regards
Thank you for this tutorial. I know that this code works, but how is it possible ? You are using Let Property but inside it, you are using Set. Let is for primitive data types and Set is for object data types. Public Property Let ribbonUI(irib As IRibbonUI) Set myRibUI = irib End Property
First of all I want to thank you for your teaching, very useful, I have a question, when output changes with the result of the sum, it does not execute the oneChange of the output, could you help me please
@@VBAA2Z If the value of text box output changes, but I want that when I change the value it automatically executes oneChange. This only executes when I change the value manually, it does not execute when it changes only with the result of the Sum
I am having trouble with the "test1" macro... I have everything set up the same as you did in the video but when I get to the "ThisWorkbook.ribbonUI.InvalidateControl "editBox" statement I get the error "Run-time error '91': Object variable or With block variable not set". Do you have any ideas what I can do to get this to work? Thanks!
I have everything matching the code from your video. It seems to work when I initially load the workbook but if I select another tab, then go back and select the tab I am working on I get this error. I can see, in the locals window, that the "ribbonUI" is no longer active, the way it is when it's first loaded. Is there something else I could be doing wrong?
Hello Thank you for your tutorial. I have just a simple question : how do you manage to switch EditBox without clicking on it? I mean I would like to use the Tab Key to switch between them but I don't know how to do. Currently it doesn't work if I use tab key.
Once again, an excellent tutorial. I lost myself completely, in the "Property Let and Get" part, I didn't understand, because I am also very young in this VBA thing. Can you suggest a website, very very basic, for me to study a little about what it is, what is it for and how to use Property Let and Property Get? It has to be for a true beginner.
I'll share short video in upcoming days with some simple example but to get you started Property Let / Get / Set are used to create new properties for class objects, either a class object that you have created or something such as a custom form like we used in UI/UX. Property Let creates a procedure that sets the value of an object property Property Set creates a procedure that sets the value of an object property that references another object. The arguments of a Property Set procedure must be object references, or you get a compile error. Reference video is CheckBox and EditBox RibbonX video Property Get creates a function that returns the value of an object property. For a property which is read-only, you would create only a Property Get function. To create a property that you can write to, you create a Property Let or Property Set procedure. For a read/write property, you create the Property Let (or Set) and Property Get in pairs. docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/property-let-statement docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/property-get-statementdocs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/property-set-statement
Thank you. Very clear tutorial
thanks Pamai. very useful video.
Very useful. Thanks Pamai 👍🏻
thanks!
Another great episode thanks alot!
You're very welcome!
always a great and fantastic job. In love with this channel.
Thank you very much!
Thanks a ton
Most welcome!
Fantastic tutorials thank you
You're very welcome!
Very informative. thank you sir.
You are welcome
Thanks
You're most welcome and thank you for your support/donation.
Brilliant! thanks sir
👍👍
This is outstanding content!
Thanks!
Dear thanks for sharing your knowledge with us, this is just my request you to kindly make full software making series where all your tricks and techniques use.....so we can focused on all
Thanks & Regards
Good one.Thanks Anand for your suggestion & support. I'll definitely think about it.
@@VBAA2Z appreciated for your response
Thank you for this tutorial.
I know that this code works, but how is it possible ?
You are using Let Property but inside it, you are using Set.
Let is for primitive data types and Set is for object data types.
Public Property Let ribbonUI(irib As IRibbonUI)
Set myRibUI = irib
End Property
First of all I want to thank you for your teaching, very useful, I have a question, when output changes with the result of the sum, it does not execute the oneChange of the output, could you help me please
Make sure variable reference and ctrl events are correct. Please rewatch
@@VBAA2Z If the value of text box output changes, but I want that when I change the value it automatically executes oneChange. This only executes when I change the value manually, it does not execute when it changes only with the result of the Sum
I am having trouble with the "test1" macro... I have everything set up the same as you did in the video but when I get to the "ThisWorkbook.ribbonUI.InvalidateControl "editBox" statement I get the error "Run-time error '91': Object variable or With block variable not set". Do you have any ideas what I can do to get this to work? Thanks!
ensure that code in this time stamp screen is added first.
ua-cam.com/video/4UYqTlnz6ck/v-deo.htmlsi=xWfYLkbjTLUxF_o9&t=470
class/object need to be create and initialized
I have everything matching the code from your video. It seems to work when I initially load the workbook but if I select another tab, then go back and select the tab I am working on I get this error. I can see, in the locals window, that the "ribbonUI" is no longer active, the way it is when it's first loaded. Is there something else I could be doing wrong?
How to make EditBox or ComboBox or DropDown ribbon office which is "the value will be taken from a spesific cell value in spesific sheet" ????
This video should answer your question.
ua-cam.com/video/4UYqTlnz6ck/v-deo.html
try something like this
Thisworkbook.xl_edit1 = range("A1").value
@@VBAA2Z in where that code been put, honey?
Custom UI editor or VB module script ribbon?
you place this in module. Check below video set to play at 1120 seconds
ua-cam.com/video/4UYqTlnz6ck/v-deo.html
How to refresh the drop down without reopening the file?
we'll cover in next video
Hello
Thank you for your tutorial.
I have just a simple question : how do you manage to switch EditBox without clicking on it?
I mean I would like to use the Tab Key to switch between them but I don't know how to do.
Currently it doesn't work if I use tab key.
You can use tab to jump from one editbox to another however first you'll need to have activated one object in that ribbon
@@VBAA2Z Thank you very much. But which object I have to activate?
@@antaled7540 any editbox or ribbon
要是c#就好了
Check this for .NET.
Idea is same. It is very easy to replicate
ua-cam.com/video/C-F_hLt-goA/v-deo.html
How to add custom image please
Will share example in next video.
Once again, an excellent tutorial.
I lost myself completely, in the "Property Let and Get" part, I didn't understand, because I am also very young in this VBA thing.
Can you suggest a website, very very basic, for me to study a little about what it is, what is it for and how to use Property Let and Property Get? It has to be for a true beginner.
I'll share short video in upcoming days with some simple example but to get you started Property Let / Get / Set are used to create new properties for class objects, either a class object that you have created or something such as a custom form like we used in UI/UX.
Property Let creates a procedure that sets the value of an object property
Property Set creates a procedure that sets the value of an object property that references another object. The arguments of a Property Set procedure must be object references, or you get a compile error. Reference video is CheckBox and EditBox RibbonX video
Property Get creates a function that returns the value of an object property. For a property which is read-only, you would create only a Property Get function. To create a property that you can write to, you create a Property Let or Property Set procedure.
For a read/write property, you create the Property Let (or Set) and Property Get in pairs.
docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/property-let-statement docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/property-get-statementdocs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/property-set-statement