![]() ![]() ![]() VBA code: Enable or disable two buttons based on two columns: Private Sub Worksheet_Change(ByVal Target As Range) In the Microsoft Visual Basic for Applications window, please copy and paste the below code into the blank module: Right click the sheet that contain the buttons, and then choose View Code from the context menu, see screenshot:Ģ. To solve this task, the following VBA code may help you.ġ. Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you every day!įor example, I have two command buttons in a worksheet, if Column A has data, the button1 is enable, and button 2 is disable if Column C contains data, the button 2 is enable, and button 1 is disable.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |