Wednesday, July 20, 2022

How to create button in Excel and Click event(macro) in it VBA

 > Open Exce

> Click on Developer

>Click on Insert

>Click on Button

> Right click on it and Click on assign macro or click on edit macro

and paste below code

macro below

Sub Button5_Click()
Range("A1").Value = "hello"
End Sub

No comments:

Post a Comment