Excel 10 Tutorial focuses on Each Excel Versions from Excel 2010 to Office 365. In this channel, I’ll be providing tutorials for both beginners & advanced users. I will be covering excel VBA, functions, formulas, graph, macros, pivot table, chart & everything else that is excel-ly possible. In this online excel training platform, I’ll focus on solving different Excel problems. I believe in “learn as we go” & that’s the best way to learn excel online. The idea is to increase the productivity of people who uses Microsoft Excel. In each tutorial, you’ll find a resourceful article in the description & all of these tutorials are tested. So, anything you find on #Excel10Tutorial, it works. You can request tutorials in “Community Tab” or even by leaving a comment, & I’ll be responding to each tutorial request promptly. There will be tutorials every day & as the host of the channel, I “Kazi”, cordially request you to subscribe to “Excel 10 tutorial”. A supportive community is everything to me
WOW!! The code macro code works amazingly well. I was able to delete 60 duplicate files out of a list of 763 files in a flash. Your video did go a bit too fast when clicking on the menu items. In future videos I suggest you slow down and move the cursor over the menu item to be selected for a few seconds before clicking so that the viewers can orientate their focus to what's being selected. You documented your code with many comments. I appreciated that. So many times I have copied undocumented code and it was very difficult for me to follow what was happening. Kudos to you, great job!
Thank you for this, gave me baseline to work on. I have tweaked the formula a bit to highlight anything that is expiring 90 days and beyond =AND($C10>TODAY(),$C10-TODAY()<>90)
Hello: Would you know how to get the EXACT RGB value in Excel using VBA? I am trying to get the exact RGB values so that I can then use Fill Color with that specific RGB value in other cells. I have many cells with different colors in certain cells, columns or rows. Need to fill certain cells with specific colors based on the content of other cells. Some have conditional formatting and others do not. Tried to do this using ONLY Excel funtions (like CELL(...)) but Excel does not have a non-macro way of identifying the color ** (which I find just incredible that Excel could not provide a simple CELL('rgbvalue') to obtain the RGB value of a cell). What would be the simplest VBA code for this? I am now reviewing your VBA course to see how to better use VBA to support Excel requirements. Good job in teaching these topics. Thanks.
Thanks for subscribing. Here is your solution. The formula will be =GetRgbColor(A2) where A2 will be the cell reference. The code will be the following: Function GetRgbColor(Rng As Range) As String Dim ColorValue As Long ColorValue = Rng.Interior.Color GetRgbColor = (ColorValue Mod 256) & ", " & ((ColorValue \ 256) Mod 256) & ", " & (ColorValue \ 65536) End Function
This worked like a charm, including and especially you showing me how to get to VBE; I'm on a Mac, and I didn't think there was a VBE. But there is, I found it, I followed your instructions (I removed the line "On Error Resume Next", since I'm only using it for individual cells), and it worked perfectly. I'm grateful for your clear instructions. Thank you! Perhaps more importantly, I then tried to click the "Thanks" button to throw a couple dollars your way, but it didn't do anything. If you have 'Thanks' enabled, it seems not to be working. If not, well, now you know that some of your viewers would like to appreciate your work, even if just a little bit.
Oh my goodness! You talk and click so fast that it is impossible to follow your instructions. I’ve watched it uncountable times just trying to see how you’re navigating. Please, if this is for the purpose of teaching other, slow it down by 75% and allow us to follow your steps, please. Otherwise, you are clear and understandable… just to fast!
Thanks a million for your input. I'll definitely follow that in the future. If you can please check the video description, I have explained that in the video description.