如何通过Combobox的数据验证列表进行TAB？ [英] How to TAB through a Data Validation Lists with Combobox?
问题描述
嘿所有，
我在组合框中创建了一个下拉列表。下拉包含100种不同的要求可供选择，其中大部分至少有5个以上的单词。
I've created a drop down list in the Combo box. The drop down consists of 100 different requirements to choose from, and a majority of them are at least 5+ words.
我可以开始在下拉列表中输入内容，它会自动填写正确的要求，但是，要将其保存/实现到下拉字段中，我需要单击电子表格中的其他单元格。
I'm able to begin typing in the drop down list and it will auto-fill the correct requirement, however, to save/implement that into the drop down field I need to click on a different cell in the spreadsheet.
组合框中是否有额外的代码或设置，所以当我开始输入我需要的要求时它会自动 - 填写，我可以简单地按
TAB 来填充它并移动到下一个单元格？
Is there an additional code or setting within the combobox so when I begin typing for the requirement I need and it auto-fills, I can simply press TAB for it to fill it in and move onto the next cell?
不确定我的要求是否清楚，但我很乐意提供更多信息。我只想通过下拉列表来选择TAB的功能。
Not sure if it's clear what I am asking for, but I'd be happy to provide additional information. I'd just like the function to TAB through the dropdown list.
感谢您提供的任何帮助。
I appreciate any assistance you can provide.
推荐答案
我真的不明白你想要做的一切。我假设您有一些与Combo相关联的VBA代码。
I don't really understand all that you are trying to do. I am assuming that you have some VBA code associated with the Combo.
您是否可以只使用组合和相关代码以及下拉列表中的一些数据组成一个简单的工作簿并将其上传到OneDrive 。包括一些指南，说明需要执行的操作以及在工作表中填充数据的位置。
Can you make up a simple workbook with just the combo and associated code and some data in the dropdown and upload it to OneDrive. Include some guidelines of what it is required to do and where the data is to be populated on the worksheet.
- 在OneDrive上上传工作簿的准则。 （如果您已经使用OneDrive并且保存到它的过程不同，那么您可以从步骤8开始获取链接，但请在上传之前压缩文件。）
- 压缩您的工作簿。不要只是将解压缩的工作簿保存到OneDrive，因为工作簿使用On-Line Excel打开，并且使用On-Line版本的有限功能会导致问题。
- 要压缩文件：在Windows资源管理器中右键单击所选文件，然后选择发送至 - >压缩（zipped）文件夹）。通过按住Ctrl键并在每个文件上单击鼠标左键，您可以选择多个工作簿，然后右键单击其中一个选项
以发送到压缩文件，它们将全部包含在一个Zip文件中。
- 不要使用第三方压缩应用程序，因为我无法解压缩它们。当Windows提供完美的应用程序时，我不会使用第三方应用程序阻塞我的计算机。
- 转到此链接。 https://onedrive.live.com
- 使用您在此论坛中使用的相同登录ID和密码。
- 在顶部的蓝色栏中选择上传，然后浏览到要上传的压缩文件夹。
- 选择打开（或双击）。 （请耐心等待，并在最初看到弹出窗口表示已完成后给它时间显示文件。）
- 右键单击OneDrive上的文件，然后选择共享。
- 选择"获取"一个链接"从弹出菜单中。
- 单击显示链接的字段，然后突出显示，然后将链接复制并粘贴到此论坛的回复中。 （我建议您避开"获取链接"屏幕上的"复制"按钮，因为它会引入不需要的额外步骤
。）
- Guidelines to upload a workbook on OneDrive. (If you already use OneDrive and your process for saving to it is different then you can probably start at step 8 to get the link but please zip the file before uploading.)
- Zip your workbooks. Do not just save an unzipped workbook to OneDrive because the workbooks open with On-Line Excel and the limited functionality with the On-Line version causes problems.
- To Zip a file: In Windows Explorer Right click on the selected file and select Send to -> Compressed (zipped) folder). By holding the Ctrl key and left click once on each file, you can select multiple workbooks before right clicking over one of the selections to send to a compressed file and they will all be included into the one Zip file.
- Do not use 3rd party compression applications because I cannot unzip them. I do not clog up my computer with 3rd party apps when there are perfectly good apps supplied with windows.
- Go to this link. https://onedrive.live.com
- Use the same login Id and Password that you use for this forum.
- Select Upload in the blue bar across the top and browse to the zipped folder to be uploaded.
- Select Open (or just double click). (Be patient and give it time to display the file after initially seeing the popup indicating it is done.)
- Right click the file on OneDrive and select Share.
- Select "Get a Link" from the popup menu.
- Click in the field displaying the link and it should highlight and then Copy and Paste the link into your reply on this forum. (I suggest that you avoid the "Copy" button on the "Get a link" screen because it introduces additional steps that are not required.)
这篇关于如何通过Combobox的数据验证列表进行TAB？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
