option buttons: black dot not appearing

greegan

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

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

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
618
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
618
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
618
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
618
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
618
THANK YOU!!
I added the me.repaint in each of the option button events(?) and it worked.
Awesome help.
Thank you
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,971
Messages
5,508,478
Members
408,688
Latest member
Bhojraj

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top