ActiveX is a means for define parts of reusable software independently in the programming language and Excel. It allows you to manipulate data so that action is taken, it is mostly used for web pages and each of its applications software is used for different components. You will learn how to configure ActiveX option buttons and customize the text of the linked cells.
The buttons access ActiveX content as they relate toolbars while browsing on the Internet, also used for creating programs and platforms such as Excel.
To you configure, go to the Developer then click Insert and be established in the group ActiveX Controls , which is Number control.
Taking active Option Button ActiveX , the mouse option in edit mode is activated and thus draw the control to your taste in Excel. With this option enabled you can configure and edit the properties as required.
When the set Property LinckedCell We will indicate whether true or false elresultado s, to perform this option click on the cell.
Property Caption , which refers to the text that is observed in the control can also be configured to your liking.
Also you can add two buttons to have more options to select. To do this, copy and paste the button that you already have and just change the Caption property.
Since you know the buttons ActiveX, you can easily access change fonts and colors, making. these options create groups of control buttons form and they are automatically added to nearby groups
Configure ActiveX for text buttons customize linked cells
The advantage of adding a text box in a cell is that, the modified contents of the cell also automatically make the text. It is simple and convenient:
First open the spreadsheet you want to use, and then from the superior tape options use the tool to create text box somewhere on the sheet. The function of the find text box on the Insert option.
Make sure your text box selected this either by clicking on the edge. And then select directly in the formula bar, then press click the still equal (=).
Keep pressing the cell whose contents you want to link the text box. Thus have selected both, text box and cell .
Press the Enter key and the result will be directly in the box. This will be reflected what is written in the selected cell. When the contents of the cell is changed it will note in the text box, as these are perfectly linked.