Userform to spreadsheet

A

Aashi

i kno u can do this cause i have done it before, just
cant rememba how.

i have a userform and i want that information to go onto
a spreadsheet using VBE. does ne1 kno how? or is there ne
other way?

thanks
 
B

Bob Phillips

Something like this within the userform code

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

or


Worksheets("Sheet1").Range("A1").Value = Me.Combobox1.Text

--

HTH

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