how do i program a vb script in excel to tell me which cell has f.
I need to write a VB script in excel that tells me which cell has focus.
Here's what I want to happen: I want to click on a cell, then push a pushbutton that will copy the contents of the cell to another worksheet. I can copy just fine, I just don't know how to determine which cell to copy. |
how do i program a vb script in excel to tell me which cell has f.
Msgbox Activecell.Address
Regards Trevor "ragnarok" wrote in message ... I need to write a VB script in excel that tells me which cell has focus. Here's what I want to happen: I want to click on a cell, then push a pushbutton that will copy the contents of the cell to another worksheet. I can copy just fine, I just don't know how to determine which cell to copy. |
All times are GMT +1. The time now is 03:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com