Solved

Dynamic UserForm - Display Caption on top of Option Button

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

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…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

777 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