I'm not sure which userform control to use here

mortgageman

Well-known Member
Joined
Jun 30, 2005
Messages
2,015
For my biweekly biz, I have various clients to who send me checks each month. I get the checks at different times during the month, but I can easily get more than one check at once. As well, I send out money on their behalf each month. Thus I would like a list that is "connected" to a "check box" for credit or debit. I don't see a way to do this without making 2 checkboxes for each client - which would be a lot of check boxes. What I am thinking of is something similar to the way a Textbox can be "linked" (with code of course) to a spin box. Is there a control (or combination of controls) that would do this?
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

sunnyland

Well-known Member
Joined
Jan 27, 2006
Messages
912
Hello there, could you may be post about 3 or 4 rows of data to see where you will have your "debit, credit" choices.

As these choices just to know if debit or credit ie:

John Smith $450.50 debit
Jess Brian $125.00 credit

or are they supposed to modify something else.

As if was just a matter to have a debit or credit field, you could use data validation with a list meaning pretty easy to set up and you don't have to have several checkboxes.

If you really want to use a check box you could have only one for each client and tick could be debit and untick could be credit but this is cumbersome as depending on how many clients you have it could be a long task to add individual checkbox then to set the property controlsource to the cell that will hold the value. Too much time and resources consuming.

This is supposing you want your checkboxes directly on the worksheet.

I think more details or a sample are needed for people out there to give you some solution
 

mortgageman

Well-known Member
Joined
Jun 30, 2005
Messages
2,015
Put simply - I want a "listbox" that would allow me to choose more than one from the list at one time. Once they are choosen, there are - to make this simple - two choices for each member of the list: A (known) credit or a (known) debit. To make an analogy: I have a whole bunch of foods in the kitchen. I want to make a salad. Thus from all the foods, I would choose: lettuce, red peppers, green peppers, PR cheese and Newmans's own Italian.

I want a listbox that allows more than one choice. Does such a control exist?
 
L

Legacy 98055

Guest
See the MultiSelect property...

http://home.fuse.net/tstom/Screen 1022060919.jpg

 

NdNoviceHlp

Well-known Member
Joined
Nov 9, 2002
Messages
2,560

ADVERTISEMENT

Listbox1.MultiSelect = fmMultiSelectMulti... Is this what you mean? Dave
 

mortgageman

Well-known Member
Joined
Jun 30, 2005
Messages
2,015
Thank you both - this goes a long way to doing what I need to do. I was not aware of the "mutiselect" property - shows you what reading the documentation can do for you!

One question: It seems that if I want to select items that are not "next to" each other, I have to select all the items and then use the CTRL key to deselect the ones that I don't want. Is there a less "kludgey" way to do this?
 
L

Legacy 98055

Guest
Gene, if you use fmMultiSelectMulti, the selection process is simply click to select and click again to deselect. See the attached for an example of this behavior. No keyboard interact is needed at all...

GeneMultiSelect.zip
 

mortgageman

Well-known Member
Joined
Jun 30, 2005
Messages
2,015
Ok - got it. I initially was confused with all that SHIFT and CRTL stuff from the help that you posted.

Thanks again
 

Watch MrExcel Video

Forum statistics

Threads
1,111,599
Messages
5,541,166
Members
410,543
Latest member
ExcelGlenn
Top