So Im using Range("A1").value=textbox1.value etc to assign text or numbers to certain cells in a large table.
The problem is that i want to achor that value to that cell, like what can be done in normal excel.
So the code I want ideally is:
Ranges("$A1").Value = TextBox1.Value
Or something along those lines
Is this possible in <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-top-style: initial; border-right-style: initial; border-bottom-style: dotted; border-left-style: initial; border-top-color: initial; border-right-color: initial; border-bottom-color: rgb(0, 0, 0); border-left-color: initial; border-image: initial; cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym>? It would make my like 100% easier. turning a project from months to weeks!
Thank you
Tom
The problem is that i want to achor that value to that cell, like what can be done in normal excel.
So the code I want ideally is:
Ranges("$A1").Value = TextBox1.Value
Or something along those lines
Is this possible in <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-top-style: initial; border-right-style: initial; border-bottom-style: dotted; border-left-style: initial; border-top-color: initial; border-right-color: initial; border-bottom-color: rgb(0, 0, 0); border-left-color: initial; border-image: initial; cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym>? It would make my like 100% easier. turning a project from months to weeks!
Thank you
Tom