Solved

Dynamic UserForm - Display Caption on top of Option Button

Posted on 2014-09-18
3
320 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

828 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