Відео

Thank you.

Office script works on a single excel file. You will need power automate and office script then.

@mdismailhosen8280 do You have a video about that?

Not at the moment.

1997ismail.hosen@gmail.com

Thank you

Thank you so much 😀

Thank you.

Thank you.

You need to use RowSelector option of Html.Table. check the documentation.

What you mean by update?

@mdismailhosen8280 Renaming to already named ranges.

@@svgkiran I guess it will create a new one. With more vba code we can add renaming functionality though.

Yes. When you don’t have a way you have to be creative.

Thanks for your feedback.

Thanks.

You are welcomed.

I know that range is for system reserved, but sometimes using that error number with a custom message resonates more. Instead of saying that there is a Type mismatch, I can say that we expect a long, but you have passed something different. That's why I kept 13. When I am running the same thing on the windows it is saying Custom Error even in the class module. Also, If you see the module example in the Mac version, then you will see that it is showing the custom description instead of a Type mismatch. So, it is more relevant to the class module and Mac issue than the error number. If I use VbObjectError then it just throws a runtime error with the description "Method RaiseCustomError' of object 'Class1' failed".

Using VBA code with userform and class modules.

It's a paid tool developed by me. It's not available at free of cost.

Thank you for your kind words.

Trying to make it better day by day. Thanks for your input.

Sorry i don't understand completely. Please share files via email and explain the problem.

@@mdismailhosen8280 Pleae Check Your Mail : Dear Sir , Working Two Excel Workbook 1. Active Workbook 2. Close Master Workbook . I need Searchable Data from Close workbook , Search Reference Will Active Workbook Active Workbook C2 Cell Value . Details: 1. Get data From all sheets of Close masterWorkbook to Active Workbook . 2.Criteria : Active Workbook C2 Cell Value reference , 3.Get All Searchable data from close workbook with Entire Row . 4. Past destination : Active Workbook last row , Could you Please MAke a Tutorial For Me ,

Glad to help. Welcome from Bangladesh.

Thank you so much. Your words will keep me inspired to record more videos. Glad to help.

Thank you. Received it. Will let you know.

@@mdismailhosen8280 Ok

Just checked. Excellent job. I may record a video for this. Is that okay?

@@mdismailhosen8280 Yeah sure

Excellent way. Do you know that VBScript is going to be removed from Windows? techcommunity.microsoft.com/t5/windows-it-pro-blog/vbscript-deprecation-timelines-and-next-steps/ba-p/4148301 . Also it won't work in Mac.

@@mdismailhosen8280 , Sorry, yes VBS. And with it, the RegExp library. That is a shame. There has to be a .NET we can use. I use System.Collections.Stack a fair amount. And .Queue once. I really like RegExp in VSCode and Notepad++

It will be removed in multiple phases. But what about Mac compatibility?

@@mdismailhosen8280 There is apparently a set of REGEX worksheet functions for Excel 365. I have 365 but not the functions. Maybe I stripped Windows down too much. I have Macs too, WorksheetFunction would be great.

Okay. I will add this comment in my video ideas list. Just to answer shortly. You can use the implementer class as an interface as well as you can use that as a separate entity. So if i have a IValidator class and implementor as IntegerValidator then i can use IntegerValidator as IValidator or as IntegerValidator. So, if we don't have both getter and setter then when you will use it as IntegerValidator then you can't set the properties of that object right? But if you want to use IntegerValidator as IValidator only then you can remove those default getter and setter and only keep the Interface (IValidator_....) one's. But still you need private module level variable to set the property (Not method).

Please share the file.

Glad to help.

Thank you. Don't forget to share to your network so that they can learn too.

Glad to help.

Glad to help.

You can search anything but the example form is just for importing and inserting code.

I agree with you about the Option Explicit. What's the benefit of having all code in a general module?

@mdismailhosen8280 I don't know if that's good enough reason but when someone deletes worksheet then you loose all code. When the whole code is just one liner calling procedure kept in a module then the whole executable code is preserved. I guess it's rather a personal preference like using a Hungarian notation but makes me feel a little more well organized.

@@fufumaliniak2927 Good point about deleting sheet and losing the code. It’s more of a personal preference.

Thank you for your suggestion. Can you check my latest video please and suggest?

Yes. Because if you don't then it will use activesheet but you can trigger a worksheet change event from vba and active sheet could be different one.

Thanks for pointing that out. For this one we definitely need comments. But when we will refactor it out we will need lesser comments.

Thank you Ben. Glad you like it.

Thank you. Congratulations.

Check this video: ua-cam.com/video/pXfBpd1OpwU/v-deo.html

You can use the same code for bunch of controls. You can definitely call a sub for each control events but still you are duplicating code. I think i have another video on handling multiple textbox events with one single class. Check that to see the usage.

@@mdismailhosen8280 Hi, yes, on that specific point i see the benefit. But my question was about generate custom events, outside Userforms at all. my point is this: instead of calling the Code within the EventCode like "RaiseEvent DoMyCode()" i could simply use that a Class and call that same Code as a method: myClass.DoMyCode() Like i said, besides that we can call Existing Events from Userforms or WOrksheets etc. the Mainquestion is, When do i use Class Method, and when a self written Event?

Okay. I get what you mean. Now let me ask you this: Does textbox events help you to write custom code? For example we have one textbox for pin code. Now you have validation that it must be 4 digit numeric. Now you use keydown event for that. And you write your custom validation code on it. You have another textbox for Let's say Firstname and you want to allow only Alphabet then your validation will be different right? But you can see that the event is same and the event is being raised by msforms internal. You are just following their contract. And the contract is every time user press something run that command.

Now consider your case: you want to use sub right instead of event. So you can put the sub either in the custom class or in form. If you put the code in the custom class then you are fixing the implementation details. Now you control what kind of validation you want right. Userform control doesn’t have the flexibility to have different validations for different textbox as event or sub will be raised by the custom class.

Now consider the second option. Put the sub in the userform. This time you can give user the flexibility to have different validation. But now you need to have userform instance in the custom class to call the sub that you have defined in the custom class. That's one dependency issue. The second issue is that Let's say i do have two textbox with two different validation. So how do you want to specify two sub with same name in the same userform? Third isdue is that you need to know what is the sub that you are calling from custom class of that userform? Fourth issue is that you need to remember what should be the name of the sub that you are using in the custom class and you need to keep that same name in the userform. So you can see the userform code and custom class code is tightly coupled.

Glad to share.

Thanks.