Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
reference frame caption associated with a checkbox
Hi,
I have several frames. Each frame has 1 to 3 checkboxes. I've setup the checkbox names so that I can loop through them using a variable (i.e. chkChoice1, chkChoice2, chkChoice3...chkChoice20) regardless of which frame they are in. As I am looping through the checkboxes, I am writing a row for each checked box. However, all the information is not located in the checkboxes. In order to finish writing the row, I need the frame caption. How can I reference the frame caption that is associated with the checkbox as I looped through the checkboxes? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
reference frame caption associated with a checkbox
Me.Controls("chkChoice1").Parent.Caption
Regards, Peter T "novice973" wrote in message ... Hi, I have several frames. Each frame has 1 to 3 checkboxes. I've setup the checkbox names so that I can loop through them using a variable (i.e. chkChoice1, chkChoice2, chkChoice3...chkChoice20) regardless of which frame they are in. As I am looping through the checkboxes, I am writing a row for each checked box. However, all the information is not located in the checkboxes. In order to finish writing the row, I need the frame caption. How can I reference the frame caption that is associated with the checkbox as I looped through the checkboxes? Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
reference frame caption associated with a checkbox
Thank you. This is exactly what I needed!
"Peter T" wrote: Me.Controls("chkChoice1").Parent.Caption Regards, Peter T "novice973" wrote in message ... Hi, I have several frames. Each frame has 1 to 3 checkboxes. I've setup the checkbox names so that I can loop through them using a variable (i.e. chkChoice1, chkChoice2, chkChoice3...chkChoice20) regardless of which frame they are in. As I am looping through the checkboxes, I am writing a row for each checked box. However, all the information is not located in the checkboxes. In order to finish writing the row, I need the frame caption. How can I reference the frame caption that is associated with the checkbox as I looped through the checkboxes? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
.BackColor of CheckBox only extends as far as the text in the caption | Excel Programming | |||
How to reference win.caption, when caption changes | Excel Programming | |||
Adding CheckBox Caption to a Listbox | Excel Programming | |||
Adding checkbox within a frame | Excel Programming | |||
Excel VBA - Capturing a checkbox caption into a worksheet. | Excel Programming |