LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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/

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help! Cannot select option buttons when Excel sheet is protected. Jenn Excel Discussion (Misc queries) 1 December 21st 08 06:03 AM
Option Buttons/Radio Buttons John Calder New Users to Excel 7 May 16th 08 03:51 AM
Option Buttons coryrey Excel Discussion (Misc queries) 1 January 6th 06 03:49 PM
Can the captions for Option Buttons be drawn from other cells ? hedonist68 Excel Discussion (Misc queries) 3 September 8th 05 02:25 PM
Using 'Option Buttons' Julian Excel Discussion (Misc queries) 3 August 17th 05 07:36 PM


All times are GMT +1. The time now is 04:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"