Refresh Page

mart1n23

New Member
Joined
Oct 14, 2005
Messages
36
Hi everyone.

I have some code, for making a Combo become toggle between visible and not visible when an option button is selected.

Here it is.

Code:
Private Sub CommandButton22_Click()

    If Slide4.OptionButton22 = False Then
    Slide4.OptionButton22 = True
    Slide4.ComboBox2.Visible = True
    Else
    Slide4.OptionButton22 = False
    Slide4.ComboBox2.Visible = False
    End If
End Sub

The code works great. My problem is, when i'm in the presentation, I select the option button, the combobox appears, but I cannot make a selection on the drop down list. When I click on the combobox, the next slide appears. I think I need to refresh the page after the combobox becomes visible, but I don't know how.

Please Help.
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
Not 100% sure about the refesh, try this code :
Code:
Private Sub CommandButton22_Click() 
   Slide4.ComboBox2.Visible = not(Slide4.OptionButton22) 
   Slide4.OptionButton22 = not(Slide4.OptionButton22) 
   DoEvents	
End Sub
 
Upvote 0

Forum statistics

Threads
1,224,847
Messages
6,181,331
Members
453,032
Latest member
Pauh

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
Back
Top