1. How can I undo a Excel macro?
2. Is there any command in Excel VB similar to INKEY$ in QBASIC so that I can control user’s input key? I want to write a macro to swap two ranges’ information. The first step to move the cell pointer to the left-top corner of the first range and then press the macro shortcut key. Then highlight the range and press Enter. Then move the cell pointer to the left-top corner of the second range and press Enter to exchange two ranges’ data. If there is no similar command, would you please give me so advice?
2. Is there any command in Excel VB similar to INKEY$ in QBASIC so that I can control user’s input key? I want to write a macro to swap two ranges’ information. The first step to move the cell pointer to the left-top corner of the first range and then press the macro shortcut key. Then highlight the range and press Enter. Then move the cell pointer to the left-top corner of the second range and press Enter to exchange two ranges’ data. If there is no similar command, would you please give me so advice?
全站熱搜
留言列表