Userform to spreadsheet

[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

 

[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)

 

[Tom Ogilvy]

a nutter weigh wood B 2 use A die nam ik name.