来自另一个工作簿的VBA for ComboBox [英] VBA for ComboBox from another workbook

问题描述

Hello Guys，我在使用userform为我的组合框写VBA时出现问题。

我想用我的组合框做的是..

1）我想要的从另一个工作簿中选择我的项目列表。 （另一个工作簿地址="E：\ AtirsPsyche \ BMark \Data"）（列表范围=" C8：C）（工作表名称  =客户）

2）我想要自动在我的ComboBox中完成。

3）我希望ComboBox在aplhabatical order list中显示项目名称，因为我在ComboBox中写了我的项目的起始单词。 

4）ComboBox应该在其他工作簿的列表中显示添加的项目。因为该列表是可添加的。

5）我不希望ComboBox显示空列表。（即如果我的列表中有3个项目，列表范围是100行，则不应该在列表中的3个项目后显示空列表）

我收到未知错误和错误。

请将此用户表格的VBA发给我。

我的用户表单中也有命令按钮，它将在同一张表的某列中显示我选择的项目。因此，如果你也发送给我VBA，那么这将是更加appriciated。 （我的组合框选择值应出现的单元格名称="（E $ 7 $：G $ 7 $"））

提前多多谢谢。

S. Atir 。

Hello Guys, I am getting problem in writting VBA for my combobox in userform.
What I want with my combobox to do is..
1) I want to select list of my items from another workbook. (Another workbooks address = "E:\AtirsPsyche\BMark\Data") (list Range = "C8:C)(Sheet name  = Customer)
2) I want auto complete in my ComboBox.
3) I want ComboBox to show item names in aplhabatical order list as I write starting word of my item in ComboBox. 
4) ComboBox should show the added items in that other workbook's list. Because that list is addable.
5) I don't want ComboBox to show empty list.(i.e. if I have 3 items in my list and the range of list is 100 rows the it shouldn't show empty list after 3 items in my list)
I am getting unknown errors and bugs.
Please send me the VBA for this userform.
I also have command button in my user form which is going to show my selected item in certain column of same sheet. So if you send me VBA for this also, then that would be more appriciated. (cell name where my combobox selected value should appear = "(E$7$:G$7$"))
Thanks a lot in advance.
S. Atir.

推荐答案

这是讨论Microsoft Excel功能的问题和反馈的论坛，我'将你的问题转移到MSDN论坛上的Excel

This is the forum to discuss questions and feedback for Microsoft Excel features, I'll move your question to the MSDN forum for Excel

https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev

https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev

之所以如此我们建议适当地发布您是否会获得最合格的受访者群体，而定期阅读论坛的其他合作伙伴可以分享他们的知识或从您与我们的互动中学习。感谢您的理解。

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

问候，

Emi

这篇关于来自另一个工作簿的VBA for ComboBox的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！