Bổ sung thêm các phương trình biểu đồ. Các đường xu hướng và phương trình cho nóhấp chuột phải vào này cười và trên menu pop-up (hình 8-9), thay đổi Tên để Bắt, chọn Text Only (Always), và Assign Macro giao nút vĩ mô cùng tên. Irritatingly, quá trình này có thể mất vài phải nhấp chuột. | Example 6 8052 Microcomputer Register Setup Figure 6-13 shows the result so far. Figure 6-13 Setup of Counter Timer 0. Timer Counter Control Register TCON Only one bit in the TCON configuration register needs to be setup and this is TR0 the Timer control bit. We will use a Check box to indicate if this is set or not. The linked cell is A17 and named TR0. The control is just visible at the bottom of Figure 6-16. Counting Types Since the requirements of each of the counting types are dissimilar rather than create huge IF statements we will create each condition separately and then hide or unhide the associated series of lines. Unfortunately because the controls hover above the lines they cannot be made to disappear. In all of the counting types we need to enter a number but the number can be in hexadecimal or decimal we place Option buttons that can be used for all configurations of the counting types. The buttons are linked to A20 which has been named Base and of course is unprotected. 97 Excel by Example The Count up from . type is simple enough as all the user has to do is enter a value which will be written into the registers. There is a setup for each mode in this counting type in the cell block A23 H36 in Figure 6-16. In each mode there are a different number of bits that can be written to the registers. In each of the input cells remembering that from the user s perspective only one of these setup registers will be visible I have added a comment as to how many bits are permitted. In addition the input cell also has conditional formatting that will turn the cell red for a number that is too large. The conditional formatting is set to formula as shown in Figure 6-14. Figure 6-14 Using a formula in the Conditional Formatting box. The data entry cell is formatted as text so that later manipulation is consistent and won t have to consider numbers as well as text. To convert from text to a number we use the VALUE function. Cell A24 will always have the decimal value
