Data Entry Listbox

[Guest]

I want to create a two column listbox that has year numbers (say, 1 to 20) in
the first column and a blank column for amounts that I can fill in myself,
year by year. Then I want the data to be pasted on a worksheet. What's the
best way to do this?

 

[Tom Ogilvy]

Since a listbox doesn't support data entry, it wouldn't be a list box.
Perhaps you would want to have a single column listbox with textboxes next
to it or two columns of Textboxes.


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