Prev: Excel file is locked by User X
Next: Cdbl and Cstr with a "Type Mismatch" Error
From: Rock on 2 Apr 2010 22:13
I have an excel workbook with a Userform. Using the toolbox, I can add a
combo box to the form, however I am not sure how to get the selections that I
want to be available in the combo box to display in the combo box. Can you
explain to me how to do that?
From: John on 2 Apr 2010 22:19
Hi Rock
Try this site:
http://www.contextures.com/xlUserForm02.html

HTH
John
"Rock" <Rock(a)discussions.microsoft.com> wrote in message
news:93EFBA9A-28E5-4853-B66B-A44EB7D1C88C(a)microsoft.com...
>I have an excel workbook with a Userform. Using the toolbox, I can add a
> combo box to the form, however I am not sure how to get the selections that I
> want to be available in the combo box to display in the combo box. Can you
> explain to me how to do that?

From: Rock on 2 Apr 2010 22:27
I figured it out. While in VBA design view Right click on the combo box and
select properties go to row source and put the name and range that you want
to be included in the comb box..

"Rock" wrote:

> I have an excel workbook with a Userform. Using the toolbox, I can add a
> combo box to the form, however I am not sure how to get the selections that I
> want to be available in the combo box to display in the combo box. Can you
> explain to me how to do that?
From: ozgrid.com on 2 Apr 2010 23:28
Better if you use Dynamic Named Ranges and use the Name in the RowSource
http://www.ozgrid.com/Excel/DynamicRanges.htm


--
Regards
Dave Hawley
www.ozgrid.com
"Rock" <Rock(a)discussions.microsoft.com> wrote in message
news:C01CFBC8-CE74-41EB-8258-EBAF7D331196(a)microsoft.com...
>I figured it out. While in VBA design view Right click on the combo box
>and
> select properties go to row source and put the name and range that you
> want
> to be included in the comb box..
>
> "Rock" wrote:
>
>> I have an excel workbook with a Userform. Using the toolbox, I can add a
>> combo box to the form, however I am not sure how to get the selections
>> that I
>> want to be available in the combo box to display in the combo box. Can
>> you
>> explain to me how to do that?

From: Rock on 13 Apr 2010 20:34
Thanks for the tip dude!

"ozgrid.com" wrote:

> Better if you use Dynamic Named Ranges and use the Name in the RowSource
> http://www.ozgrid.com/Excel/DynamicRanges.htm
>
>
> --
> Regards
> Dave Hawley
> www.ozgrid.com
> "Rock" <Rock(a)discussions.microsoft.com> wrote in message
> news:C01CFBC8-CE74-41EB-8258-EBAF7D331196(a)microsoft.com...
> >I figured it out. While in VBA design view Right click on the combo box
> >and
> > select properties go to row source and put the name and range that you
> > want
> > to be included in the comb box..
> >
> > "Rock" wrote:
> >
> >> I have an excel workbook with a Userform. Using the toolbox, I can add a
> >> combo box to the form, however I am not sure how to get the selections
> >> that I
> >> want to be available in the combo box to display in the combo box. Can
> >> you
> >> explain to me how to do that?
>
 |  Next  |  Last
Pages: 1 2
Prev: Excel file is locked by User X
Next: Cdbl and Cstr with a "Type Mismatch" Error