本文介绍了将值从文本框中检索到范围的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我在输入表单上有一组文本框。我需要从文本框的值填充Excel工作表中的单元格。我是excel vba的新手。我该怎么做(例如)范围(R1C1)= txtbox1.value
范围(R2C1)= txtbox2.value \
|
|
\ | /
范围(RnC1)= txtboxn.value

I have a group of text boxes on an input form.  I need to populate cells in a range on an Excel Sheet from the value of the textboxes. I am very new at excel vba.  How do I do this (ex) Range(R1C1) = txtbox1.value
                                                                                          Range(R2C1) = txtbox2.value\
                                                                                                               |
                                                                                                               |
                                                                                                              \|/ 
                                                                                            Range(RnC1) = txtboxn.value

推荐答案

Activesheet.Range("A1").Value=TextBox1.Value
Activesheet.Range("A2").Value=TextBox2.Value


等......只要文本框和目标单元格是静态的,它就足够了

and so on...
As long as the textboxes and destination cells are static it should suffice


这篇关于将值从文本框中检索到范围的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-22 23:59