User forms in Excel

[Guest]

Hi,

Can anyone help me on how to create user form and in excel using combo box
and update data in my excel spreadsheet?

I would appreciate very much you help.

Regards
Eric

 

[JulieD]

Hi Eric

this is quite involved .... as there's vba code involved in this process.
If you'ld like to let us know what you're trying to achieve - particularly
in relation to the combo box we might be able to suggest easier
alternatives.

Cheers
JulieD

 

[Guest]

Thanks Julie for a quick response.

Okey, I have an excel file say for example in column 1 is a bowler name,
scores, etc. and further down the row of the spreadsheet for each week I have
to input their scores BUT I don't want go down every now then and locate
their names and input their corresponding scores. See example below:

Week1
Col1 Col2 Col3 Col4
Row1 Joe 100 150 160
Row2 Smith 120 140 170
..
..
so...on

Week2
Col1 Col2 Col3 Col4
Row51 Joe 120 130 140
Row52 Smith 130 122 140
..
..
so...on

Hope this helps... thanks again
Eric

 

[Tom Ogilvy]

These should get you started:

http://support.microsoft.com/default.aspx?kbid=161514
XL97: How to Use a UserForm for Entering Data

http://support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data

http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.
http://j-walk.com/ss/excel/tips/tip84.htm

http://support.microsoft.com/default.aspx?scid=kb;en-us;829070
How to use Visual Basic for Applications examples to control UserForms in
Microsoft Excel


Here is another sources of information: (applicable to xl97 and later)


http://support.microsoft.com/?id=168067
File Title: Microsoft(R) Visual Basic(R) for Applications Examples for
Controlling UserForms in Microsoft Excel 97
File Name: WE1163.EXE
File Size: 161742 bytes
File Date: 05/08/97
Keywords: kbfile
Description: This Application Note is an introduction to manipulating
UserForms in Microsoft Excel 97. It includes examples and Microsoft Visual
Basic for Applications macros that show you how to take advantage of the
capabilities of UserForms and use each of the ActiveX controls that are
available for UserForms