Adding a list box in place of a cell

  • Thread starter Thread starter Mr. Fins
  • Start date Start date
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
 
Found the solution. I need to use textbox instead of list box. Then set
vertical scrollbars to 2 - frmScrollBarsVertical, set MultiLine to
True, etc.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying zeros in cells 2
URGENT: How to prevent data in cells from changing? 1
Protection Lists 4
Combo Box dropdown data 20
Unobtrusive Place To Put Report TItle and a List? 5
Lists for List Validation 1
build a search tool in excel 1
Jump when copying a list of cells 3

Back
Top