28693006.xlsm

<div>
You're welcome and I'm glad I was able to help.<br />
<br />
In <a href="https://www.experts-exchange.com/M_258447.html" rel="ugc">my profile</a> you'll find links to some articles I've written that may interest you.<br />
Marty - MVP 2009 to 2015
</div>


You're welcome and I'm glad I was able to help.

In my profile [https://www.experts-exchange.com/M_258447.html] you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2015

<div>
<div class="content wysiwyg-content">
I have a worksheet:<br />
col a = partnum<br />
col b = description<br />
col c = process<br />
the data looks like this (col a: col b: col c)<br />
part1: apartnum1: Make<br />
part2: apartnum2: Buy<br />
part3: apartnum3: Make<br />
part4: apartnum4: Make<br />
part5: apartnum5: Buy<br />
part6: apartnum6: Make<br />
<br />
I want to have a combobox on a userform that displays only the parts that have a process of &quot;Make&quot; in column c. &nbsp;With the example above, I would see these partnum's in my combobox<br />
part1<br />
part3<br />
part4<br />
part6<br />
<br />
How can I do this? &nbsp;Attach an example spreadsheet if possible. &nbsp;Thanks.
</div>
</div>


I have a worksheet:
col a = partnum
col b = description
col c = process
the data looks like this (col a: col b: col c)
part1: apartnum1: Make
part2: apartnum2: Buy
part3: apartnum3: Make
part4: apartnum4: Make
part5: apartnum5: Buy
part6: apartnum6: Make

I want to have a combobox on a userform that displays only the parts that have a process of "Make" in column c.  With the example above, I would see these partnum's in my combobox
part1
part3
part4
part6

How can I do this?  Attach an example spreadsheet if possible.  Thanks.

Userform combobox display values that meet criteria from a worksheet or named range

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.