View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim[_39_] Tim[_39_] is offline
external usenet poster
 
Posts: 71
Default checkboxes and option buttons

XP pro, xl2002

hi i have a userform with several checkboxes. if any of them are checked i
want their captions to be concatenated together with some text in a textbox
to be transferred together into another textbox at the click of a button.

eg, textbox1 = "TVC"
checkbox1 = checked (caption "-1")
checkbox2 = unchecked (caption "-2")
checkbox3 = checked (caption "-3")

so, textbox2 would = "TVC-1-3"

i CAN do all of this, but want to know if there is an efficient way of
working through each checkbox (of which there are 7)

subsequently, a smilar solution for the optionbuttons (although, obviously
only one will be 'true')

in addition (if it makes a difference), all the checkboxes are in one frame
and the option buttons in another frame - these are bth enclosed in another
frame... currently for aesthetic purposes, but don't know if it makes any
difference to what i want to achieve. can i refer to all objects enclosed in
a frame?

thanks all,

tim