ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Radio Buttons (https://www.excelbanter.com/excel-programming/339138-radio-buttons.html)

ceemo[_30_]

Radio Buttons
 

Ive been working on a form that uses radio buttons but for some reason i
cant sem to get them grouped. When i press one the active one
deactivates but the new one doesnt check. This is causing me all sorts
of problems.

Ive tried changing the cells they are linked to and the same happens.
ive tries different option buttons linked to the cells as well as
different cells but no joy.

I opned up a new book and created a quick form linked to some cells in
the new book and that worked fine so i thought i would try and copy my
project accross to a new book but that didnt work either i really dont
know what to tey next please can someone give me some ideas to try.


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=401710


Doug Glancy

Radio Buttons
 
Ceemo,

When you first posted about this a few days ago, you were using some code
that grouped them and that contained GoTos. I had asked if you knew for
sure that the code that groups them was actually executed. Why don't you
include your current code and somebody might be able to help you.

Also, have you tried just grouping the buttons on the userform by putting
them inside a frame? I mean during the design of the form in the VBE, not
in the code.

hth,

Doug

"ceemo" wrote in
message ...

Ive been working on a form that uses radio buttons but for some reason i
cant sem to get them grouped. When i press one the active one
deactivates but the new one doesnt check. This is causing me all sorts
of problems.

Ive tried changing the cells they are linked to and the same happens.
ive tries different option buttons linked to the cells as well as
different cells but no joy.

I opned up a new book and created a quick form linked to some cells in
the new book and that worked fine so i thought i would try and copy my
project accross to a new book but that didnt work either i really dont
know what to tey next please can someone give me some ideas to try.


--
ceemo
------------------------------------------------------------------------
ceemo's Profile:
http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=401710




ceemo[_31_]

Radio Buttons
 

Thanks for your response. I shall have a look at this tomorrow and get
backto you. thank you again for looking at this again though.


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=401710



All times are GMT +1. The time now is 05:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com