• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 368
  • Last Modified:

Dynamic UserForm - Display Caption on top of Option Button

Using VBA on a dynamically created Userform, is there a way to display the option button captions at the top of the each button instead of to the left or right sides of each button?   Since I will have many rows of 5 option buttons each, my preference is to use the option button captions over labels.  Thank you!
0
Quiver
Asked:
Quiver
1 Solution
 
NorieData ProcessorCommented:
You can't do that with option buttons created at design time, the only choices for alignment are left and right.

I suppose you could add a label above each option button and set their captions to an empty string.
0
 
Glenn RayExcel VBA DeveloperCommented:
No points...slow on the draw!  But here's how one might look.   Separate labels over option buttons with no caption.
sample form with labels over option buttons
-Glenn
0
 
QuiverAuthor Commented:
Thank you for confirming that there isn't a way to place a caption on top of the option button dynamically.  In all of my research I wasn't finding anything, but I wasn't ready to give up until you confirmed it.  I actually had placed a label on top of each option button but thought it would be more efficient to use an option button caption if I could.  Thanks again.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now