用户表单搜索，显示和结果 [英] User Forms to Search, Display and result

问题描述

Hello Everyone。

我有一个问题，如果有人可以提供帮助，我将不胜感激....

附件是一个包含3个搜索标签的用户表单。我希望它能够在文本框中找到工作表显示结果，并在更新时将筛选列表添加一个数字（来自userForm）添加到一个表示ppo＃的列中。任何指导都会有所帮助。

附加文件

（21.8 KB，136 views）

哇感谢Guido为此我真的非常感谢你再次做到最好....我想让用户在发现每条记录后添加PPO＃是否可以继续添加PPO＃每次添加一个逗号时，每次添加一个逗号时都会使用逗号分隔，然后每次添加一个新标记时添加时间戳

Hello Everyone.
I have a question and i would appreciate if any one can help....
Attached is a user form with 3 Search critira. I would like it to seach the worksheet display result in text box and on update that filtered list add a number(From the userForm)into in a column that says ppo #. any guidance in this will help.

Attached Files

New USer form.zip (17.7 KB, 163 views)

解决方案

can anyone help? did i not explain it right????

Attached demo will:
- load all the existing values from the sheet into the Combo lists.
- Search according to the lists selection.
- Add in the text box some values from the found records.

Question: for each found record, must ppo# be automatically added in a column or must the user decide for it and add it yes or no?

Attached Files

New user form_v1.zip (21.8 KB, 136 views)

Wow thanks Guido for this i really appreciate this once again your the best.... I would like to have the user add a PPO# to the column after each record found is it possible to keep adding PPO#''s to that same column then seperate with a comma everytime a new one is add then time stamp in the next coloumn everytime a new one is add

这篇关于用户表单搜索，显示和结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！