Option buttons to select a row of cells
 

I am going to program buttons F1 to F8 (perhaps through a autoexec
macro) to add a "1" to the current total in a cell.

Therefore if i press F2 then "1" is added to cell B2.

However, i have 8 rows and i need to instruct which row gets the focus
for the F buttons.

Now 8 option buttons, one assigned to each row. If option button one is
selected then the F buttons add "1" to the first row.
If option button 6 is selected the row 6 has the F focus.

Is this possable? Is there an easier way? How could it be implimented?


---
Message posted from http://www.ExcelForum.com/

Option buttons to select a row of cells
 

If you figure out a way to do what you're suggesting please let me know.
In the meantime, as a second best alternative, you could assign the
macro to the key combination "Ctrl+Shift+1"

Effectively "Ctrl+!"

Or if three buttons is too much you could buttons "q" through "i" to
stand for the numbers under which they rest. Not what you'd hoped, but
functional... - Pikus


---
Message posted from http://www.ExcelForum.com/

Option buttons to select a row of cells
 

YO! I found it!!! Check this out:

Private Sub Workbook_Open()
Application.OnKey "{F1}", "HiThere"
End Sub

Which calls Public Sub HiThere()

Then return "F1" To normal by:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.OnKey "{F1}"
End Sub

This RULES!!! - Pikus


---
Message posted from http://www.ExcelForum.com/