Assigning a Simple Button to a VBA Code – Excel Microsoft Visual Basic
This is a simple guide to create and assign a “button” to your simple VBA code. Credit to WiseOwlTutorials. You can check him on Youtube Let’s create a simple VBA code in a module A simple code like this will do for our example
|
1 2 |
Sub NameIsNanaKofi() Worksheets.Add Range("A1").Value = "My Name is Nana Kofi"End Sub |
Now let’s create an object Click on the Developer Ribbon…