Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
UserForm Data to Spreadsheet Andy Tallent Excel Discussion (Misc queries) 2 June 22nd 05 04:51 PM
userform for spreadsheet spreadsheets/userforms Excel Discussion (Misc queries) 1 May 20th 05 12:18 PM
spreadsheet on userform alcorjr Excel Programming 2 December 15th 03 07:19 PM
Can I program a userform via spreadsheet? Phillips Excel Programming 2 November 27th 03 04:11 AM
Spreadsheet in an Userform Lukas Rüttimann Excel Programming 0 September 23rd 03 05:06 PM


All times are GMT +1. The time now is 09:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"