how to load item in combo box in excel?

[Learnerprog]

Hello all,
I am new to VBA. I am trying to load a list of names that are stored in my excel spread sheet into a combo box on form load. How do I do that? and when I select the name on the drop down list from the combo box. I will only populate the the information belong to that individual on the spreadsheet only. Please guide me? Thank you very much. Joe

 

[SkipVought]

Hi,

Either you can use the AddItem method or assign the range to the ListFillRange property. I nearly always use NAMED RANGES.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[Learnerprog]

pullimall,
How do I grab the value from my sheet?

 

[SkipVought]

Are you using the FORMS dropdown or the CONTROL TOOLBOX?

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[Learnerprog]

how to filter all the data from spreadsheet based on the criteria that is input from the form e.g Name of person?
Thank you very much in advance

 

[SkipVought]

You did not answer my question.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[Learnerprog]

Sorry skip,
I am using the control toolbox. Thanks, CVL

 

[SkipVought]

Enter the sheet range in the ListFillRange like
[tt]
Sheet1!A2:A5
[/tt]
or Name the Range and enter the range name.

How can I rename a table as it changes size faq68-1331

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[Learnerprog]

Skip,
I could not get it to work based on your answer

 

[Learnerprog]

Can anyone help with the filter on the spreadsheet. basically, I need help on how to filter record on the spreadsheet based on input search from a form. The search will be based on First and Last Name. please help. Thanks, CVL

 

[SkipVought]

Hey joe,

how 'bout explaining SPECIFICLY what you're trying to do, example data et al.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[Learnerprog]

Skip,
I have figured it out. Thanks for all your help.