Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Pedro Gilbert   on Jan 24 In MS Office Category.

Question about objects and OptionButtons


  
Question Answered By: Aaliyah Khan   on Jan 24

try using this. dunno if it'll work as it is....didn't have
time to run it....

Dim objObject As OLEObject

If Worksheets("sheet1").Range("Z5")> " " Then
For Each objObject In Worksheets("sheet2").OLEObjects
If objObject.ProgId = "Forms.OptionButton.1" Then objObject.Visible =
True
Next
Else
For Each objObject In Worksheets("sheet2").OLEObjects
If objObject.ProgId = "Forms.OptionButton.1" Then objObject.Visible =
False
Next
End If

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Question about objects and OptionButtons Or get search suggestion and latest updates.


Tagged: