Linked checkbox and list on a user form

[N2theSon]

Warning: newbie post ahead!

I have a form frmClientList with a single list box to provide a quick reference whether or not a client has already been entered into the system. This is populated from a dynamic named range. Another form, frmClientJournal, logs various interactions with clients. A drop-down on frmClientJournal is populated from the same named range.

I would like to add a check box next to each item in the frmClientList list box that is captioned Inactive. This would be linked to a new column in the named range. Code for the drop-down on frmClientJournal would then populate it only with active clients as determined from the Inactive column.

I'm having trouble, however, figuring out how to add checkboxes to frmClientList for each entry. Any help would be greatly appreciated. Thanks in advance!

Rex
(aka "the new guy")

 

[AlphaFrog]

Set these two properties for the ListBox...

<font face=Courier New>frmClientList.ListBox1.MultiSelect = fmMultiSelectMulti<br>frmClientList.ListBox1.ListStyle = fmListStyleOption</FONT>

You could also set them from the ListBox's property window.

 

[Marcelo Branco]

Hi and welcome,

Maybe this.

In frmClientList

Set the the MultiSelect property to
1 - fmMultiSelectMulti

and the ListStyle property to
1 - fmListStyleOption

The checkboxes on each item are displayed

M.

 

[N2theSon]

Thanks, AlphaFrog and Marcelo! That was a REALLY fast response. I posted a similar question on another really busy forum and got no responses in about a week. I'll look forward to trying this when I get back to the project.

I think I'm going to become a MrExcel addict!