I created simple macro that insert values to custom properties. When I trigger the macro those fields are empty.
Is it possible to call back that existing value from custom property.
( Please refer the attached macro for reference )
Thanks
I created simple macro that insert values to custom properties. When I trigger the macro those fields are empty.
Is it possible to call back that existing value from custom property.
( Please refer the attached macro for reference )
Thanks
Hi Praba,
Do you need to fill the textbox value with custom property value.
Regards,
Vignesh
Hi vignesh,
Yes I need to fill this text box with a value from custom property if its available.
If this trigger is a new entry means we can leave it as blank.
when I edit custom property with this same form i need to know what is the existing value.
Thanks
You can use UserForm_Initialize and get the value form the properties to populate the text box.
Thank you for your replay.
Can you give a example?
I have text box named as property_1 , in that i need to load the property mass.
when its initiate the form, if there is no data means will i get any error?
Thanks
I've already attached the updated macro in my earlier post.
Prabaharan Pichaiyan wrote:
when its initiate the form, if there is no data means will i get any error?
You can set an IF condition. If no value or property is there then leave blank else populate the value.
Apologize. Didn't notice.
Works great.
Thank you
I've already attached the updated macro in my earlier post.
You can set an IF condition. If no value or property is there then leave blank else populate the value.