Solved

Dynamic UserForm - Display Caption on top of Option Button

Posted on 2014-09-18
3
305 Views
Last Modified: 2014-09-19
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
Comment
Question by:Quiver
3 Comments
 
LVL 33

Accepted Solution

by:
Norie earned 500 total points
ID: 40330629
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
 
LVL 27

Expert Comment

by:Glenn Ray
ID: 40330841
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
 

Author Closing Comment

by:Quiver
ID: 40332323
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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now