Excel VBA 2016 Complete Tutorial for Beginners | Part 10 | Example 1

Dear Friends,

Presenting you all 10th video of 30,
Examples 1/15

I have discussed here 3 simple buttons and writing modules for those buttons finally assigning it.
Watch this video completely and try it yourself.

here is the coding part
-------------------------------------------------------------------------------------
Sub save()

End Sub

Sub Color()
Dim c As Variant

c = InputBox("Enter color index number")

Range("A1:B10").Interior.ColorIndex = c

End Sub

Sub clear()
Range("A1:B10").clear
End Sub
-------------------------------------------------------------------------------------

Please to Share with friends,
Subscribe | Share | Comment | Like

Also would u like to make money online watch my videos under playlists.

Thank you

ALLISWELL

[solomonall]

Thank you Bro for the wonderful and clear

[sudheepgrandhe]

Hi ..Daya..your VBA lessons... are very good..when can we expect remaining lessons advance from expert level lessons...????

[Pawhan]

Thank you Daya! This is very usefull for me in my jobfunction. Can you make an example with a form where various types of data is put into tables i other sheets? And is it possible to lock the sheets so it is only possible for an individual to access the form?

[PineDAnimations]

@daya, I do have a small doubt here. How did you assign the or mapped the color with the intex number. I mean when you select the number how the excel is identifying. We should map it then only the excel can identity it. I tried and I could not do it as it is not mapped for mine. Please do reply daya. Thank you