Welcome rajanverma1...@gmail.com, have two ways to set upa List in the
Combobox.
01 ways: in the window Propeties Section RowSource you enterthe address of
the data you want included in CoboBox.
For example, G3: G20 (type a list from G 3 to cell G20) is the listthat
appears when you click on CoboBox.
02 ways: you use the Code to addItem.
Suppose that in Form I:
- 01 CommandButton name: cmdback.
- 01 CommandButton name: cmdcal
- 01 ComboBox name: cbogp
Code:
Private Sub UserForm_Initialize()
cmdback.Visible = False
Frame1.Visible = False
cmdcal.Visible = False
With cbogp
.AddItem "1800"
.AddItem "1900"
.AddItem "2400"
.AddItem "4200"
.AddItem "4600"
.AddItem "4800"
.AddItem "5400"
.AddItem "6600"
.AddItem "7600"
.AddItem "8700"
.AddItem "8900"
.AddItem "10000"
End With
End Sub
2011/8/31 Rajan_Verma <rajanverma1...@gmail.com>
> *See the attached Sheet..*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Rakesh Joshi
> *Sent:* Tuesday, August 30, 2011 9:29 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ How to load data into Combo box in user
> form****
>
> ** **
>
> Go to Property of Combo box type the Range under the row source of
> Combobox.:****
>
> On Tue, Aug 30, 2011 at 9:09 PM, Suryaprasad <suryaprasad...@gmail.com>
> wrote:****
>
> Hi All,****
>
> ****
>
> Attached is the sheet where i need the list of the countries to be added to
> the combo box****
>
> ****
>
> Note : The Combo box should be enabled once the data is entered in Text Box
> given above of Combo box.****
>
> ****
>
> Please do the needfull.****
>
> ****
>
> Thanks****
>
> Prasad****
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel****
>
>
>
> ****
>
> ** **
>
> --
> Rakesh Joshi****
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel****
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
