Search : in
By :

How to eneter values from user form to excel

Last answer on Sep 4, 2009 10:07:27 am BST karthik_1_4u@yahoo.com, on Jun 5, 2009 7:34:56 am BST 
 Report this message to moderators

Hello,
I need a help from u guys to solve one of my problems.
i have requirement where i need to collect details from user using a form(with text boxes and submit button) and then place these values in the excel sheet.can anyone let me know how can i do these?

Configuration: Windows XP
Safari 525.19

Best answers for « how to eneter values from user form to excel » in :
VBA: Finding Hdc in an Excel worksheet or UserForm ShowVBA: Finding Hdc in an Excel worksheet or UserForm Here are two small examples on how to find Hdc in a worksheet: By clicking on Sheet1 the UserForm is displayed. Put the pointer on UF, hold the left mouse button down and drag the...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Inserting an animated gif in Excel ShowInserting an animated gif in Excel To insert an animated gif image in an Excel spreadsheet, you must insert the image into a control. To insert the control, go to the View menu/Toolbars/Control Toolbox Activate the first button Design...
Calc - calc.exe Showcalc - calc.exe The process calc.exe corresponds to Windows' Calculator application. The file that corresponds to this process is normally found in the directory "%SystemRoot%\system32\calc.exe" (where %systemroot% is usually C:\WINDOWS.) It is an...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Ask your question Reply

1

Excelguru, on Jun 7, 2009 10:15:44 am BST
  • +4

Hi use
sheets("Sheetname).cells(rowno,columnno).value=textbox1.text
for each text box
in submit button click event Winners are losers who got up and gave it one more try. -Dennis DeYoung
My Interests are financial Modelling and custom excel development.

   
Reply to Excelguru

2

 IB, on Sep 4, 2009 10:07:27 am BST

Hi Excel guru,

I have exactly the same question/problem.
I want to create sheet in excel where people can enter name and emailaddress, pressong an submit button and data will be saved in a list in a second sheet. Next person can enter data.....
Would you min to help me out with my problem.
Thank you

   
Reply to IB
Ask your question Reply
They need your help