View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dennis I[_2_] Dennis I[_2_] is offline
external usenet poster
 
Posts: 1
Default No Frames in Control Toolbox?

Thank you for the information. I need to use the buttons' value property in
code I am writing for the a worksheet. When I put option buttons (say
OptionButton1 and OptionButton2) directly on a worksheet (not in a frame), I
use "OptionButton1.value" and "OptionButton2.value" to see which is selected
and to direct further actions. However, when I put the buttons into a frame
(named Frame1), than the code does not seem to recognize OptionButton1.value
and OptionButton2.value. I've tried accessing the value properties by
"frame1.OptionButton1.value", but that does not work. In fact, I have
similar problem for all the controls in put in the frame. I put a command
button in the frame ("CommandButton1"), but when I write code for the
worksheet it does not recognize that this object exists.

"Don Wiss" wrote:

On Fri, 23 Dec 2005, "Dennis I" <Dennis wrote:

Question for Leith Ross. I too was looking for help on finding a frames
control and was pleased to read your reply. Now I have put in a frame as you
have suggested and added some controls (option buttons). But I cannot find a
way to use the events from those buttons. How do I capture an event related,
say, to OptionButton1 in Frame1?


All Option Buttons have a linked cell. All buttons within the same group
share the cell. It will have a value of 1,2,etc. The default is all buttons
on a sheet are in the same group. Frames will allow more than one group on
the same sheet. The linked cell can be found on the properties sheet. You
can also have the clicking fire a macro. For a Forms button you give it the
name of the macro to run. So more than one button can call the same macro.
For a Controls button the macro will be unique for each button and resides
behind the sheet. To start the macro click view code.

Not sure if this answers your question, as I'm not sure of the question.

Don <www.donwiss.com (e-mail link at home page bottom).