Adding a list box in place of a cell

M

Mr. Fins

I have a inherited a status spreadsheet that is updated ofen
Previously, the sheet was saved by date so if you wanted to view th
history of the comment field/column you had to open each spreadsheet.
would like to append history but not have the cell grow to an enormou
size. My thought is to use a list box but what I want to do is keep th
box a static size and scroll through the data. I can use a secondar
sheet to store and modify the data. TI
 
M

Mr. Fins

Found the solution. I need to use textbox instead of list box. Then set
vertical scrollbars to 2 - frmScrollBarsVertical, set MultiLine to
True, etc.
 
Top