View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bruce001[_3_] Bruce001[_3_] is offline
external usenet poster
 
Posts: 1
Default Weird Macro Problem


Tom Ogilvy Wrote:
Radio buttons only allow one button in the group to be true.


Yes, this is how I'm using them. And in the macro sheet, I execute code
when a button is selected.

Tom Ogilvy Wrote:
It isunclear what you mean by
I have no idea why Excel would go
to the individual sheets macros like it does.


but this sounds like you are telling me that some event macros are
being
fired when you are making the updates. If this is so, then this is
the
likely cause of your problem. It sounds like you might have some type
of
recursive call going on or other code is altering these cells as well.


Yes. The event programming looks something like this:

Private Sub AppButton1_Click()
Worksheets("RBRQ7").Range("D34").Value = "FALSE"
Worksheets("RBRQ7").Range("E10").ClearContents
End Sub

How can I get rid of these recursive calls? (And thanks for your
help!)

Tom Ogilvy Wrote:
--
Regards,
Tom Ogilvy



"Bruce001"
wrote in
message ...

THanks for the reply Tom. I tried a separate subroutine like you
suggested and it does the same thing. I have no idea why Excel would

go
to the individual sheets macros like it does.

Let me give a bit more information. I use radio buttons on the page

to
set these cells to true or false. I did notice that some of my

buttons
had the same names across the different sheets, so I went back and
changed them to all unique. And it still does the same thing. What

is
truely weird is I have a bunch of other sheets in this workbook that

do
the same thing and those sheets don't act that way.

Any other help would be appreciated since I am running out of ideas

and
time.

Bruce Gold


--
Bruce001

------------------------------------------------------------------------
Bruce001's Profile:

http://www.excelforum.com/member.php...o&userid=26630
View this thread:

http://www.excelforum.com/showthread...hreadid=399045



--
Bruce001
------------------------------------------------------------------------
Bruce001's Profile: http://www.excelforum.com/member.php...o&userid=26630
View this thread: http://www.excelforum.com/showthread...hreadid=399045