PDA

View Full Version : Solved: Writing UserForm data to a Specific cell



simora
01-14-2009, 02:05 AM
I have assigned both row & column locations to variables.
How do I get VBA to write TextBox3. data to the location intersection of those 2 variables.

rsRow is the row variable
rsCol is the column variable

Something like



Range(rsRow, rsCol).Select

ActiveCell.Value = TextBox3.Value



This is where I have the problem.

Thanks

georgiboy
01-14-2009, 02:12 AM
Range(rsRow, rsCol).Value = Userform1.TextBox3.Value

Assuming that your userform is named Urerform1

simora
01-14-2009, 02:25 AM
Hi Thanks.

However, I did try that and the code stopped at that location.
THen, I tried
Range(rsRow, rsCol).Select
To see if it would select the cell at that location and the code also stopped at this point.

Any other ideas ?

Thanks

simora
01-14-2009, 02:44 AM
Figured it out;

Cells(rsRow, rsCol) = TextBox3.Value

Thanks for pointing me in the right direction.