LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Linking option buttons and returning data across worksheets

First off, let me explain that although I've found similar questions posted
here, I couldn't figure out how to adapt them to fit my my needs. I am
currently using 2010 beta which may or may not make this trickier; and the
users will be using older versions - at least for now.

I have been given a workbook that was made up of worksheets from a few
different workbooks. Two of the pages there include a diagram with points
along it identified by numbered option buttons. When an option button is
selected, the corresponding number is returned in the cell that option button
is linked to. What we WANT is for the values of the option buttons to match
across the worksheets, AND for the corresponding number to be returned in the
linked cells on both pages.

i.e. When button 01 (of 48) on the worksheet named "Part 1 - Inspection
Data", is selected, cell E1 returns 01; accordingly, the value of button 01
on worksheet "Part 4 - Feasibilty" should also become TRUE with cell G16
returning 01.

What DOES happen is that when I select any button on either page, all
buttons on the other page become FALSE.

I have tried entering the worksheet name and cell range of the button on the
inspection sheet into the "linked cell field" of the properties of option
button 01 on the Feasibility sheet. I have also tried editing the code; but
that hasn't gotten me anywhere, either.... (I haven't really used visual
basic in quite some time and am afraid that I've forgotten more than I
haven't!) I'm under a deadline; so would greatly appreciate any help!!!

Thanks in advance!!!

 
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
Linking data between worksheets Pam S. Excel Worksheet Functions 1 November 11th 08 03:44 PM
Option Buttons/Radio Buttons John Calder New Users to Excel 7 May 16th 08 03:51 AM
Worksheets and Control Option Buttons KHaydel Excel Worksheet Functions 1 April 9th 07 11:19 PM
Linking worksheets by buttons. Moggie Excel Discussion (Misc queries) 1 April 20th 06 06:09 PM
Gathering Data from Option Buttons Susan Excel Worksheet Functions 0 April 11th 06 08:07 PM


All times are GMT +1. The time now is 08:46 AM.

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"