| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo box in user form
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combo box in user form
Hi Rock
Try this site: http://www.contextures.com/xlUserForm02.html HTH John "Rock" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combo box in user form
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combo box in user form
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" wrote in message ... 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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combo box in user form
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" wrote in message ... 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? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combo box in user form
Right on man! Thanks for your help. This link is awesome.
"John" wrote: Hi Rock Try this site: http://www.contextures.com/xlUserForm02.html HTH John "Rock" wrote in message ... 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? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User form combo box | Excel Programming | |||
| Combo box on user form | Excel Programming | |||
| Combo Box on User Form Question | Excel Programming | |||
| combo box in a user form | Excel Programming | |||
| Can't seem to get Combo Box on User Form | Excel Programming | |||
Linear Mode
