วีดีโอ

Sir rupees formula to aa hi ny ra

mary pas excl may Deta validation kam nahi kar raha list link nahi hoo rahai kia waja jo sakti haa

🙌🔥

Sir its a very good video. I appreciate your wonderful effort. Can you do the same video in English so you get more viewers who will understand it.

Kiya asay nahi ho sakta kay Humy hr dafa micro recording wala km na karna parhy

Sir JB esy bnd kar dety Hain tb Phir Humy dubara micro Kay Kay Sath Connect Karna parhta hai

Function NumberToWords(ByVal MyNumber As Double) As String Dim Units As Variant Dim Tens As Variant Dim Hundreds As Variant Dim Thousands As Variant Dim Millions As Variant Dim Billions As Variant Dim Currency As Variant Dim SubUnits As Variant Dim DecimalPart As String Dim IntegerPart As String Dim TempStr As String Dim Str As String Dim Num As String ' Define arrays for the number parts Units = Array("", "One", "Two", "Three", "Four", "Five", "Six", "Seven", "Eight", "Nine") Tens = Array("", "", "Twenty", "Thirty", "Forty", "Fifty", "Sixty", "Seventy", "Eighty", "Ninety") Hundreds = Array("", "One Hundred", "Two Hundred", "Three Hundred", "Four Hundred", "Five Hundred", "Six Hundred", "Seven Hundred", "Eight Hundred", "Nine Hundred") Thousands = Array("", "One Thousand", "Two Thousand", "Three Thousand", "Four Thousand", "Five Thousand", "Six Thousand", "Seven Thousand", "Eight Thousand", "Nine Thousand") Millions = Array("", "One Million", "Two Million", "Three Million", "Four Million", "Five Million", "Six Million", "Seven Million", "Eight Million", "Nine Million") Billions = Array("", "One Billion", "Two Billion", "Three Billion", "Four Billion", "Five Billion", "Six Billion", "Seven Billion", "Eight Billion", "Nine Billion") Currency = "Dollar" SubUnits = "Cent" ' Separate the number into integer and decimal parts IntegerPart = Int(MyNumber) DecimalPart = (MyNumber - IntegerPart) * 100 ' Convert integer part Num = CStr(IntegerPart) Select Case Len(Num) Case 1 ' Units Str = Units(Val(Num)) Case 2 ' Tens If Val(Num) < 20 Then Str = SpecialCases(Num) Else Str = Tens(Val(Left(Num, 1))) & " " & Units(Val(Right(Num, 1))) End If Case 3 ' Hundreds Str = Hundreds(Val(Left(Num, 1))) & " " & NumberToWords(CDbl(Right(Num, 2))) Case 4, 5, 6 ' Thousands TempStr = Left(Num, Len(Num) - 3) Str = NumberToWords(CDbl(TempStr)) & " Thousand " & NumberToWords(CDbl(Right(Num, 3))) Case 7, 8, 9 ' Millions TempStr = Left(Num, Len(Num) - 6) Str = NumberToWords(CDbl(TempStr)) & " Million " & NumberToWords(CDbl(Right(Num, 6))) Case 10, 11, 12 ' Billions TempStr = Left(Num, Len(Num) - 9) Str = NumberToWords(CDbl(TempStr)) & " Billion " & NumberToWords(CDbl(Right(Num, 9))) Case Else Str = "Number is too large" End Select ' Convert decimal part if present If DecimalPart > 0 Then DecimalPart = Int(DecimalPart) TempStr = CStr(DecimalPart) Str = Str & " " & Currency & " and " & NumberToWords(CDbl(TempStr)) & " " & SubUnits Else Str = Str & " " & Currency End If ' Trim and return the final string NumberToWords = Application.WorksheetFunction.Trim(Str) End Function Private Function SpecialCases(ByVal Num As String) As String ' Handle numbers below 20 Select Case Val(Num) Case 10: SpecialCases = "Ten" Case 11: SpecialCases = "Eleven" Case 12: SpecialCases = "Twelve" Case 13: SpecialCases = "Thirteen" Case 14: SpecialCases = "Fourteen" Case 15: SpecialCases = "Fifteen" Case 16: SpecialCases = "Sixteen" Case 17: SpecialCases = "Seventeen" Case 18: SpecialCases = "Eighteen" Case 19: SpecialCases = "Nineteen" Case Else: SpecialCases = "" End Select End Function

1 question jab hum new k button pay click kerty han to new invoice no genrate ho jata ha 1 say 2 lakin ager hum dubara new pay click keran to 2 say 3 ho jata ha. ager hum is pay if condition lga dain kay jb tak invoice main date na ho next no genrate na ho. thanks

Ap ny without macro kaha

Error run 438a rhahai sir

Hello .. iam from india I saw this video it's was very nice Can u place make data entry sheet for dental clinic

Hello sir insert slicer creat karne k liya jub data sleact kar k pyot tables existing sheet creat karte hai na. Tub error aara. Please advise me

First entry korne ki bad auto date nehiata he

Countif wala formula proper ni work krr rya ji

Very informative & easily interpreting video... Hats off to you

Sir kindly share your excel sheet with us so we can practice it..🥹plz sir

how to download your invoice

This is tooo long video and seems doing for your own

please create a simiple template in which only four things will be mentioned 1. opening balalnce 2. closing balance in stock market candlestick pattern . MEANS if my fund blance is 25000 INR and i got profit of 2000 inr so that day in my EXCEL FUND SHEET appear a green candle and if someday i got loss so that day there create a red candle . please HELP.

hello sir, i learned lot of thing from your videos, just keep uploading <3

Assalam Alaikum bhai app ka video wala file share karo bhai same file jo video mai bataye ho

Sir ager ek hi pdf main record ay to wo kaisy kary ga

Plz make more videos

sir what if i want to make some changes in the pervious invoices made

Hi plz provdie medical billing software in excel

Sir can u send these template on mail

invformative excellent

File bana hua chaiye ap bhej sakte

Ye file format bhej sakte kya aap

Force static kaise lagega

Sir can you share vba code or excel sheet

Old patient ki details k ly search ka colum kaise add kare

Well done

Really good

Bhai Module Code Kese likhen

Mashallah Bhot Acha Kr Raha Ha Inshallah Ak Din Channel Grow Hoga

plz sir help kardy Sajjad Bahai Okara sy.ma ny ap ke vedio dekh dekh kar sary automated invoice generate karli hia lakin macro nahi lag raha, problem ya hai ka micro banay ka bad jab button per click karty hai tu os ka uper replace ho jata hai dosara name pahly wala khatam ho jata hai or 1 bad 2,3 koi be add nahi hota invoice data ma. maslan Ali ka bad sajjad add keya tu ali khtam ho jy ga sajjad ajy ga.sajjad ka bad koi or add karo to wo ajy ga sajjad khatam ho jay ga.plz help.

"Run-time error '5' Invalid Procedure Cell or Argument" showing

MACRO RECORD AUR ASSIGN MACRO K BAAD ENTRY DATABASE K SIRF PEHYLY WALY COLUMN MAI HO RAHI HAI , HOW TO CORRECT IT ?

Sir can you make a file for us we are the tractor dealer

Sir put vba code in description

Sir put vba code in description

Sir put vba code in description

Sir put vba code in description

اگر ہر ڈاکٹر صاحب کے مریض الگ الگ کاونٹ کر نے ہوں تو کیا طریقہ کار اپنانا چاہیے

Save karne ka baad error dikha rahi hai ... Save nehi ho rahi hai

Plz Sir give me reply i make like this Report Card but the Obtained Mark coming #N/A problem so what i do can you give me reply 😢😢

good

Well explained 👍

Hi sir my iferror is not showing blank instead it's showing 0