Much appreciate, if anyone could help me to auto create a command button when click another command button in a specific cell and assign code to the newly created command button.
I have very less knowledge on excel VBA. The first command button (let's say Command1) is on a user form. When Command1 is clicked a new command button (Command2) should be created on a specific cell in a worksheet (Sheet1). When Command1 is clicked macro should be auto assigned to Command2.
Please help me to get this done.