Option buttons to select a row of cells

  • Thread starter Thread starter mikewild2000
  • Start date Start date
M

mikewild2000

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?
 
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
 
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
 
Back
Top