Excel VBA - Create Functions

thx now i need a digital whiteboard

how can to create a function that combines multable in one tables in a sheet

It's clear, however Can you please give different examples ? Thank you.

Apke wajah se hum exam me pass ho pate hai thank u sir ....... video dekhte dekhte aap par crush 🥰🥰🥰 aa gya h......dil de baithe h hum apko......

when i type it and try to use the function i get a value error, how come...?

Want to create a function that for unique code we get email

Can u suggest me how to create image function

BRO. You just saved me. I was tearing my hair out trying to figure these errors. THANK YOU.

Great job, brother

Your body covered the whole fuckin thing, but other than that this is actually the first video I've seen yet to properly explain this concept so good on that part.

I want to add a sequence function in my excel pls guide me about this

how to create bold italic function for a part of string

Hey sir .....i just need to know how we can make this sum function as dynamic

Thanks

Sir plz help I have a data and maine uska average nikala
Second thing is Min max from data but when we go according to excel formula we will get min value which is lowest value in data and max value which is highest value in data but I don't want it
For my work my calculation for min is average+min value ➗ by 2
And same for max is average+highest value ➗ by 2
So plz help me how can I do this according to my calculations

Excelent! quick and precise. Nice job sir :)

Hello Sir Could you please solve my question
I want to split name in VBA like first name middle name third so how to solve this question

I want to modify the name of my function, but I created this function some months ago and I don't find how open it now. Someone could help me ?

Thank you for saving me.

wrg

Thanks a lot for making this video. I have been trying to learn VB on my own and your videos are very helpful. Best thing is that the content is divided in various videos and you can learn one step at a time. No confusion. Thanks a lot!

does anybody know if this gonna also work for thermodynamics properties? Like there is no function “ =Enthalpy “ in excel, any ideas plz?

how to write the function to find the volume of trapezoid

I wanna specify specific language for specific columns in the sheet , may anyone help ?

I want to add this function in Excel 2016 "=FILTER(array, include, [if_empty])" sir plz can you send me the method

I want to have large touch screen as you have.

nice

Hello pavan I liked your videos but I have a little problem I don't know how can I do. I need to create a unique record in the first colum (A1)., Num ID with macros with (dd, mm, yy, and time)

Can you help me please?

Thank you Pavan

Hello Sir,

Can you help me in getting an user define function to get monday dates between two dates?

For Ex: Start date = 4/4/2020 & End date= 5/5/2020, then result should give me a list of Mondays dates

dd/mm/yyyy
dd/mm/yyyy
dd/mm/yyyy
......so on

Please help me this is very urgent..

Thank u in advance.

Is there a way to make a custom function label the inputs as you type them?  For example, in Excel’s “DATE” function, it lists “year”, “month”, and “day” as you’re typing to help you remember the inputs.  Is this possible with custom functions?

I'm unable to create any functions at all. Where am I going wrong?

I'm unable to create any functions at all. Where am I going wrong?

Clear, concise, no BS. Very well done.

I dont have developer tab in my excel

Had to use the call =myownfunction(2;3). Had to use ; not ,

Please upload a video for unzip a 325 file type

Brutal.

Hello pavan , thank you for your video and please solve the error for my program
Function aa(x As Integer) As Integer
aa = x + 1

End Function


its not working , I dont know why

hi, i have an excel sheet and i want to restrict it to use some time only, after the subscription time it has to said contact the creator. that too using machine ID. can u pls let me know how to do that.

This comment has nothing to do with the content. But, WOW! Incredible presentation!!! The effect where you stand in front of a giant spreadsheet and push fields is AMAZING. The visual is so clear, I'm not even annoyed by the Indian accent. Going to follow (have less than 12 channels I'm following in over 10 years of use).

I commend you for teaching me this in less than 3 minutes

Great Video! But, I wish you told us how to call a function from a macro ! Thanks for sharing it !

Great! Thank You.
━═━═━═━═━═━═
Function StripAccent(thestring As String)
Dim A As String * 1
Dim B As String * 1
Dim i As Integer

Const AccChars= "ABC"
Const RegChars= "XYZ"

For i = 1 To Len(AccChars)
A = Mid(AccChars, i, 1)
B = Mid(RegChars, i, 1)
thestring = Replace(thestring, A, B) Next

StripAccent = thestring

End Function
━═━═━═━═━═━═
This Function covert A to X, B to Y, and C to Z. But I want to convert like this
A to X
X to A
B to Y
Y to B
C to Z
Z to C
Please, help me.

How can add two different columns value in one column like consolidated report kindly instruct the vba code
For ex : one employee's basic + DA + HRA = gross - deduction = net

I created the function but it's not working. the value is showing as "0".

actually i have created that function, but it is not working..