option buttons: black dot not appearing

greegan

Well-known Member
Joined
Nov 18, 2009
Messages
625
What have i done wrong that the ob's dot is not showing when selected in the userform?
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

tweedle

Well-known Member
Joined
Aug 1, 2010
Messages
1,559
First thing that comes to mind is the Locked property is set to True.
 

greegan

Well-known Member
Joined
Nov 18, 2009
Messages
625
Thank you for your reply. I've checked and all three are false
 

tweedle

Well-known Member
Joined
Aug 1, 2010
Messages
1,559
Next thing would be if they in a container, such as a frame, that might be disabled.
When you click one, do you get a selector frame around the text?
 

greegan

Well-known Member
Joined
Nov 18, 2009
Messages
625

ADVERTISEMENT

I've grouped them as VDSoptions. When I select one I get the border of dots around it. I think that's what you're asking.
I should mention... the macro linked to the button works. Its only that the black dot isn't showing.
 
Last edited:

p45cal

Well-known Member
Joined
Nov 10, 2009
Messages
4,763
The display may not be updating; check out the repaint method.
 

greegan

Well-known Member
Joined
Nov 18, 2009
Messages
625

ADVERTISEMENT

The display may not be updating; check out the repaint method.
Thank you all for the replies and suggestions.
This one I'm not sure of. Where do I find the repaint method?
 

greegan

Well-known Member
Joined
Nov 18, 2009
Messages
625
It is a userform. I've searched on the forum for the repaint method and I am beginning to understand this now. I still haven't found a solution. This is what I have when the obVerification is called up...
' ** Opening Option Windows
Sub Center_obVerification() ' **Centers userform on primary monitor
Application.ScreenUpdating = True'added after forum suggestions
With obVerification
.StartUpPosition = 0
.Left = Application.Left + (0.5 * Application.Width) - (0.5 * .Width)
.Top = Application.Top + (0.5 * Application.Height) - (0.5 * .Height)
.Show vbModeless
obVerification.Repaint 'added after forum suggestions
DoEvents 'added after forum suggestions
End With

with and without the 'added after forum suggestions, nothing seems to work yet. I'm still reading though. But the site's making it difficult kicking me out every five minutes of non activity :(
 

greegan

Well-known Member
Joined
Nov 18, 2009
Messages
625
THANK YOU!!
I added the me.repaint in each of the option button events(?) and it worked.
Awesome help.
Thank you
 

Watch MrExcel Video

Forum statistics

Threads
1,133,324
Messages
5,658,155
Members
418,430
Latest member
Kizega

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top