userform combobox to look up list in sheet

[H_Kennedy]

Hi

I have created a Userform . Can some code be added to my code for the userform to have the following

For combobox9 I need code to look at sheet "tools" starting in cell C4 to C100 and make that list available in combobx9

For Combobox10 I need code to look at sheet "tools" starting in cell C4 to C100 and make that list available in combobx10

My code for userform below

Thanks

Please Login or Register  to view this content.

[Trebor76]

Hi H_Kennedy,

Not sure why combobox9 and combobox10 have the same reference (typo?) but this this will do job as part of your form's initialize script:

Please Login or Register  to view this content.

How's the weather in Melbourne today? We've had a warm one in Sydney.

Cheers,

Robert

[H_Kennedy]

Hi Robert

Thank you....weather is mild....comfortable

Yes sorry my mistake should have been
For combobox9 C4 to C100 and make that list available in combobx9
For Combobox10 E4 to E100 and make that list available in combobx10

Should I place the code as follows

Please Login or Register  to view this content.

[Trebor76]

Should I place the code as follows

Yes, that's right. You have a Next statement without an accompanying For statement which will error out when you try and open the form I would image. Delete or comment that out and all should be right to go.

Regards,

Robert

[H_Kennedy]

Thanks

The userform now has a list for each combobox but it is reading from the wrong sheet.It is reading from the sheet where the userform commandbutton is situated

Any thoughts please?

Thank you

[Trebor76]

I'd suggest looping through each range and populating the relevant combo box that way, i.e.

Please Login or Register  to view this content.

Robert

[H_Kennedy]

Thanks Robert for your help...that works fine

[Trebor76]

That's great. If you could mark the thread as solved it would be appreciated.

Robert