View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mikewild2000[_2_] mikewild2000[_2_] is offline
external usenet poster
 
Posts: 1
Default 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/