Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
What I would like to accomplish is to insert a "Frame" control & then add "Option buttons" to the Frame for the User to select & then with VBA to manipulate them. I first tried using the FORMS Toolbar controls. The work how ever u then have no control over them with VBA, or if u do I dont know how, perhaps someone can exlpain that to me, for example to make them Visible or not. Then I tried using the CONTROL TOOLBOX controls. With these u can control them with VBA. However, this for some reason doesnt have a "Frame" control, but I as able to add one by selecting the "More Controls" toolbar & then find the "Microsoft Forms 2.0 Frame" When I add this "Frame" to my worksheet & then add the Option Button on top of the Frame, when I exit out of Design Mode the Option Buttons dissapear, sort of goes behind the Frame. The CONTROL TOOLBOX controls work for me better becuase then I can use VBA coding to manipulate them, but now I am experiencing the above problem. How can this be fixed ? Any help would be greatly appreciated. Thank you, Jeff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protecting Controls in a worksheet | Excel Discussion (Misc queries) | |||
Controls on worksheet | Excel Programming | |||
Tab Between Active X Controls on Worksheet | Excel Programming | |||
controls on worksheet | Excel Programming | |||
Worksheet Controls | Excel Programming |