将值从文本框中检索到范围 [英] Retrieving values into a range from textboxes

问题描述

我在输入表单上有一组文本框。我需要从文本框的值填充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

推荐答案

从表单中快速简便地执行此操作就像是...

Quick and easy way to do it from your form is like...

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

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