Multi Column Combo Box, with Variable data

**ddanfleetwood** · 12-23-2009, 08:20 PM

Hi All,

I'm currently working on an excel vba application for my local scout group with the prospect of making it open source to the scouting community.

I would like to have a Combo box that will look at a worksheet and populate with a drop down list of Camps the cubs have been on showing a 3 column drop down box.

Example below:

Camp Date |Camp Location | Number of Nights
01/06/2009 | Snowball | 2
06/07/2009 | Strensall Common | 1
09/09/2009 | Snowball | 3

Have seen this done on the net before but cant find the code

Thanks,
Dan

**Palmetto** · 12-23-2009, 08:45 PM

Once you have created the combo box, set the ListFillRange property to the sheet and cell references where the 3-column list of camps is contained.

Optional, but recommended: create a dynamic named range for the list of camps and use this named range as the source for the ListFillRange property.

Next, set the Column Count property to 3 to show all three columns. You may want to adjust the Column Widths property of the control to size them so all three of the columns clearly show the list items.

While in the VB Editor and in one of the property boxes, press the F1 key to get help on that property.

Post a sample workbook if you need more help.

**ddanfleetwood** · 12-23-2009, 09:03 PM

Hi Palmetto,

Cant get it to work, see workbook attached.

I can only get the one column showing.

Thanks,
Dan

**Palmetto** · 12-23-2009, 09:10 PM

Your dynamic named range formula is set to only encompass one column.

Your formula: =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$C),1)

Use this: =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),3)

**ddanfleetwood** · 12-23-2009, 09:16 PM

Palmetto,

Thank you for that bit of help, can I get the result to go into 3 text boxes

For example, if you select ;

10/09/2009 Snowball 4

Then the 3 text boxes on the userform will be populated with this info?

Thanks & Merry Christmas,
Dan

**Palmetto** · 12-23-2009, 09:27 PM

I see no reason why you would want to place the list items into textboxes, but here is code, which used the combobox change event.

Please Login or Register  to view this content.

Multi Column Combo Box, with Variable data

LinkBack

Thread Tools

Rate This Thread

Display

Multi Column Combo Box, with Variable data

Re: Multi Column Combo Box, with Variable data

Re: Multi Column Combo Box, with Variable data

Re: Multi Column Combo Box, with Variable data

Re: Multi Column Combo Box, with Variable data

Re: Multi Column Combo Box, with Variable data

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions