Userform to spreadsheet
 

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

Userform to spreadsheet
 

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)

"Aashi" wrote in message
...
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

Userform to spreadsheet
 

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

--
Regards,
Tom Ogilvy

"Bob Phillips" wrote in message
...
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)

"Aashi" wrote in message
...
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