Returning VBA results to a cell

  • Thread starter Thread starter JasonSelf
  • Start date Start date
J

JasonSelf

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
 
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)
 
Back
Top