Solved

Dynamic UserForm - Display Caption on top of Option Button

Posted on 2014-09-18
3
332 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 34

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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

688 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