Hi Sir, Your coaching is simply amazing, a non developer like me even can understand all the points which you explained in series of videos. its a gift for me.
really great trainings sir. sir if I want to give different colours for different sets in Colomn A. ex. if column A is different countries and Colomn B with codes. I want different colours for each country set and codes
Hi Pavan, you are really a unique in VBA teaching, i am trying to color the concatenate formula like this ="ABC"&(A1)&"buy"&(d2)&"from DBC". here, i need to apply the values or text of cells A1 & D2 . can you help.
My query is: If the stock level falls below the minimum level we can do a conditional formatting in excel and show the present stock as red color or set ut to blink. And in the same way what would be the VBA code to show the same minimum stock level in listbox .
How can I assign values that includes the formats like if it is bold. For example cells(1,2).value=cells(1,1).value but it must include the bold format from cells(1,1).
I woked with "yellow" & "Magenta" & they worked for me on VBA. Thats what I was confused seeing yellow as yello. I thought may be yello works on VBA. Thus I tried it on VBA & yellow worked for me well. :)
Hello Pavan, what if I want to hide text with a particular color in a "Cell"... for example in cell data is "My name is Firoz"... Firoz is in blue color and I want to hide blue color text so can you help me out with VBA code...
Sub font_color() Range(a1:a10).Font.Color=vbGreen(Total 8 standard Color) Range(a1:a10).Font.ColorIndex=1(1-56) End Sub vbWhite vbBlack vbYellow vbRed vbCyan vbBlue vbMagenta
Get Certified in Excel VBA:bit.ly/41fWeVP
Use coupon "TH-cam12" to get ‘’FLAT 12%’’ OFF at Checkout.
This is a great tutorial on Excel VBA. I have never seen a series like this. Thank you.
Hi Sir, Your coaching is simply amazing, a non developer like me even can understand all the points which you explained in series of videos. its a gift for me.
Hi Pavan, you are great man....i have not seen such a lucid and clear explanation in all your videos. God Bless!!
Thanks Buddy! I could use it inside the If statement , nice one!
Great Pavan. Simple to knowledgeable video. God Bless you for sharing such valuable stuff.
I like your tutorials. Just one thing to point out - it is not called magneta, but magenta.
This channel is so so brilliant! thank you!!
Regards from Indonesia.
Tq sir for your explanation , Is superb I learn VBA form your tutorial
The way you explain in english lang. with easy words I like it so much .
Great job
Great video. Just a small correction. The name of the color is vbMagenta and not vbMagneta
Grat..thanks so much
Damn I thank god I found your channel it help me a lot.
Wonderful every video. Thx
Nice sir
very very easy to lean vba
Thank you!
You are doing a good job sir...thank you ..
really great trainings sir.
sir if I want to give different colours for different sets in Colomn A. ex. if column A is different countries and Colomn B with codes. I want different colours for each country set and codes
simply superb
Hi Pavan, you are really a unique in VBA teaching, i am trying to color the concatenate formula like this ="ABC"&(A1)&"buy"&(d2)&"from DBC". here, i need to apply the values or text of cells A1 & D2 . can you help.
My query is:
If the stock level falls below the minimum level we can do a conditional formatting in excel and show the present stock as red color or set ut to blink.
And in the same way what would be the VBA code to show the same minimum stock level in listbox .
¿Qué te hiciste en estos 5 años, dónde estás?
How can I assign values that includes the formats like if it is bold.
For example cells(1,2).value=cells(1,1).value but it must include the bold format from cells(1,1).
can we get the sample file so that we can work on it
How to change font in whole sheet? Or we usually use ctrl+a in excel sheet.
Your vbMagneta didn't work, coz ots Magenta
What is difference in using the prefix as xl and vb?
gr8 Job
How to write VBA in power point for font color change
Please reply sir
4:15, yellow didn't wok, because the spelling of yellow was wrong (vbyello)...
also magneta wich should be "magenta"
I woked with "yellow" & "Magenta" & they worked for me on VBA. Thats what I was confused seeing yellow as yello. I thought may be yello works on VBA. Thus I tried it on VBA & yellow worked for me well. :)
Thanks , Yellow had not worked might be due to spell error
With Block could be used here it will be much easy to type
Hello Pavan, what if I want to hide text with a particular color in a "Cell"... for example in cell data is "My name is Firoz"... Firoz is in blue color and I want to hide blue color text so can you help me out with VBA code...
Thanks sir .. I think it should be yellow instead of yello
How to highlight active cell front in Excel workbook with the help of VBA
Why it is "Yello" instead of "Yellow"
There is one more method Range("a1:a10").font.color = RGB (0,255,0)
Hiii,
How to get colorindex number?
How can i get excel sheet
*Magenta
Correct
Hi Pawan! Its not Magneta, its Magenta!! Thats what I was thinking of!! Because I know Magenta colour which means dark pink.
It threw error when I used "Magneta". & Yello is yellow ok! :)
Is there any way to change the input characters color in an inputbox. I want to hide my password
'My Reference
With Range("A1")
.Font.Color = vbGreen
End With
Sub font_color()
Range(a1:a10).Font.Color=vbGreen(Total 8 standard Color)
Range(a1:a10).Font.ColorIndex=1(1-56)
End Sub
vbWhite
vbBlack
vbYellow
vbRed
vbCyan
vbBlue
vbMagenta
2 spelling errors - yello and magneta should be corrected to yellow and magenta.. also they are pronounced as yell-o and ma-gent-a..
It should be Magenta instead of Magenta
U wrote both spellings correct buddy! :) Pawan used Magneta & not Magenta. ;)