Returning VBA results to a cell
 

Ok, if anybody read my last post you would know that I am a newbie at
this VBA Stuff. So this question is probably gonna be obvious to most
people...I however have no clue.

I have written some code that comes up with a form with textbox for a
value...I want that value be exported to a cell somewhere on one of my
worksheets. I have figured out how to make a cell active but I can
not figure out how to get it to write a variable or return a fuction to
a cell....any help would be greatly appreciated as always..

Thank You,
Jason Self


---
Message posted from http://www.ExcelForum.com/

Returning VBA results to a cell
 

Just put the text value in the cell, you don't need to make the cell active,
like so

Worksheets("Sheet1").Range("A1").Value = Textbox1.Text

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"JasonSelf " wrote in message
...
Ok, if anybody read my last post you would know that I am a newbie at
this VBA Stuff. So this question is probably gonna be obvious to most
people...I however have no clue.

I have written some code that comes up with a form with textbox for a
value...I want that value be exported to a cell somewhere on one of my
worksheets. I have figured out how to make a cell active but I can
not figure out how to get it to write a variable or return a fuction to
a cell....any help would be greatly appreciated as always..

Thank You,
Jason Self


---
Message posted from http://www.ExcelForum.com/

Returning VBA results to a cell
 

awesome thanks

--
Message posted from http://www.ExcelForum.com