View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default how to write vb code for multiple combo boxes

Because a checkbox only has two states, you can use one checkbox for yes and
no, same number of controls.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"HFB" wrote in message
...
Yeah, they will only contain yes and no. I don't actually have enough

space
in the form to do check boxes.

"Bob Phillips" wrote:

Will these boxes only contain Yes and No? If so, why not just use a
checkbox?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"HFB" wrote in message
...
I have several combo boxes with names: drill1, drill2, drill3 etc. I

want
to
write code that gives a Yes option and a No option in each of those

boxes
without having to write code for each one. Is there a way to do this?

thanks