How I can built combo box step by step

Have you tried looking in Help?

--

Vasant

"Friends2005" <Friends2005@discussions.microsoft.com> wrote in message
news:FF5036AA-3ED0-48D9-A493-214D3DC63928@microsoft.com...
> I need to built Combo box in which I can choose from down list menu. could
> you advise step by step how I can do it.

Yes I tried.
I know how I add combo box, but my question how I can put items in this box
in order to use it as (pick up from down list)

regards,

"Vasant Nanavati" wrote:

> Have you tried looking in Help?
>
> --
>
> Vasant
>
> "Friends2005" <Friends2005@discussions.microsoft.com> wrote in message
> news:FF5036AA-3ED0-48D9-A493-214D3DC63928@microsoft.com...
> > I need to built Combo box in which I can choose from down list menu. could
> > you advise step by step how I can do it.
>
>
>

Thanx a lot

"mangesh_yadav" wrote:

>
> 3 ways to add items, assuming you have selected the combobox from the
> control toolbox:
>
> 1.
> Enter the following code in the sheet module
> Private Sub Worksheet_Activate()
> ComboBox1.ListFillRange = "Sheet1!A1:J10"
> End Sub
>
> Or
>
> 2. Right-click on the combo and view properties. In the listfillrange,
> enter the source of the list
>
> or
>
> 3.
> Enter the following code in the sheet module
> Private Sub Worksheet_Activate()
> ComboBox1.AddItem "item1"
> ComboBox1.AddItem "item2"
> ' and so on
> End Sub
>
>
>
>
> Mangesh
>
>
> --
> mangesh_yadav
> ------------------------------------------------------------------------
> mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
> View this thread: http://www.excelforum.com/showthread...hreadid=378526
>
>

Have you tried looking in Help?

--

Vasant

"Friends2005" <Friends2005@discussions.microsoft.com> wrote in message
news:FF5036AA-3ED0-48D9-A493-214D3DC63928@microsoft.com...
> I need to built Combo box in which I can choose from down list menu. could
> you advise step by step how I can do it.

Yes I tried.
I know how I add combo box, but my question how I can put items in this box
in order to use it as (pick up from down list)

regards,

"Vasant Nanavati" wrote:

> Have you tried looking in Help?
>
> --
>
> Vasant
>
> "Friends2005" <Friends2005@discussions.microsoft.com> wrote in message
> news:FF5036AA-3ED0-48D9-A493-214D3DC63928@microsoft.com...
> > I need to built Combo box in which I can choose from down list menu. could
> > you advise step by step how I can do it.
>
>
>

Thanx a lot

"mangesh_yadav" wrote:

>
> 3 ways to add items, assuming you have selected the combobox from the
> control toolbox:
>
> 1.
> Enter the following code in the sheet module
> Private Sub Worksheet_Activate()
> ComboBox1.ListFillRange = "Sheet1!A1:J10"
> End Sub
>
> Or
>
> 2. Right-click on the combo and view properties. In the listfillrange,
> enter the source of the list
>
> or
>
> 3.
> Enter the following code in the sheet module
> Private Sub Worksheet_Activate()
> ComboBox1.AddItem "item1"
> ComboBox1.AddItem "item2"
> ' and so on
> End Sub
>
>
>
>
> Mangesh
>
>
> --
> mangesh_yadav
> ------------------------------------------------------------------------
> mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
> View this thread: http://www.excelforum.com/showthread...hreadid=378526
>
>

I need to built Combo box in which I can choose from down list menu. could
you advise step by step how I can do it.

Have you tried looking in Help?

--

Vasant

"Friends2005" <Friends2005@discussions.microsoft.com> wrote in message
news:FF5036AA-3ED0-48D9-A493-214D3DC63928@microsoft.com...
> I need to built Combo box in which I can choose from down list menu. could
> you advise step by step how I can do it.

Yes I tried.
I know how I add combo box, but my question how I can put items in this box
in order to use it as (pick up from down list)

regards,

"Vasant Nanavati" wrote:

> Have you tried looking in Help?
>
> --
>
> Vasant
>
> "Friends2005" <Friends2005@discussions.microsoft.com> wrote in message
> news:FF5036AA-3ED0-48D9-A493-214D3DC63928@microsoft.com...
> > I need to built Combo box in which I can choose from down list menu. could
> > you advise step by step how I can do it.
>
>
>

Thanx a lot

"mangesh_yadav" wrote:

>
> 3 ways to add items, assuming you have selected the combobox from the
> control toolbox:
>
> 1.
> Enter the following code in the sheet module
> Private Sub Worksheet_Activate()
> ComboBox1.ListFillRange = "Sheet1!A1:J10"
> End Sub
>
> Or
>
> 2. Right-click on the combo and view properties. In the listfillrange,
> enter the source of the list
>
> or
>
> 3.
> Enter the following code in the sheet module
> Private Sub Worksheet_Activate()
> ComboBox1.AddItem "item1"
> ComboBox1.AddItem "item2"
> ' and so on
> End Sub
>
>
>
>
> Mangesh
>
>
> --
> mangesh_yadav
> ------------------------------------------------------------------------
> mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
> View this thread: http://www.excelforum.com/showthread...hreadid=378526
>
>