Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Entry Listbox
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 -- Regards, Tom Ogilvy "Stratuser" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto entry of data based on entry of text in another column or fie | Excel Discussion (Misc queries) | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions | |||
Different text format on a listbox entry | Excel Programming | |||
Disappearing listbox entry | Excel Programming |