Mircosoft Excel?! Need help!?

Question

How to build a form in excel 2003 to add information?

Answer 1

Do you mean add a remark to a cell? Then it's simple: right click on the cell and choose 'insert remark' in the menu that is popping up.

Or do you mean something else? Maybe you should add a bit more explanation to your question...

Answer 2

I assume you want to add a userform in VBA for a user to use for data entry. If so, here is how to add one in Excel 2003 to enter text into cell A1:

Open your workbook

Press ALT + F11

Insert  >  Userform

If you don't see the Properties window in the bottom left corner,  press F4.

Click on the userform and in the Properties window, locate the Caption field and enter:  'Input Data in A1"  (no quotes)

Click on the TextBox (AB) in the Controls Toolbox, then click and drag it onto the userform.  Size and position it to your wishes.

Click on the Textbox you just added.  In the Properties window locate the ControlSource field.  Enter the cell reference A1 for the ControlSource property.

Next click on the Command Button in the Controls Toolbox (2nd row, far right).  Click and drag it onto the userform.  Size and position it to your wishes.

Click on the Commandbutton and in the Properties window, locate Caption and enter 'Close' (no quotes).

Double click on the Close button and type this in: Me.Hide

Copy this macro to the clipboard:

Sub frmUserform1_Show ()

UserForm1.TextBox1.SetFocus

Userform1.Show

End Sub

Insert  >  Module

Paste the macro into the Module space to the right.

Close back to Excel.

View  >  Toolbars  and click 'Forms'.

Click on the Commandbutton, then click on the spreadsheet and drag the Command button onto the worksheet.  Click on CommandButton1 (or whatever number it is) and rename the button, if you wish.

Right click on the button and 'Assign Macro'.

Click on frmUserform1_Show

Close back to Excel.

Now, click the command button on the worksheet and the userform will appear. Enter text into the textbox and close the form.  A1 will update to the text you entered.