本文介绍了VBA - Excel FindNext输入框的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

您好,


我正在尝试设置find / next / replace输入框,但我不知道如何使vb这样做。目前我的代码有三个步骤。我有一个输入框,要求找到一个变量。然后,当它被找到时,它会将给定行上的所有信息放入电子表格中。如果只有一行包含所请求的信息,这将工作得很好。这是我查找函数的代码:

Hi there,

I''m trying to set up a "find / next / replace" input box, but I have no clue how to make vb do this. Currently my code has a three step process. I have an input box that asks for a variable to find. Then when it''s found, it puts it all the information on a given row into a spreadsheet. This would work just fine if there was only one row with the requested info. This is the code I have for the find function:

展开 | 选择 | Wrap | 行号

推荐答案

展开 | 选择 | Wrap | 行号




这篇关于VBA - Excel FindNext输入框的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

09-13 12:48