M
milred
I am wondering how to access the data chosen in a listbox control. I am
guessing that the cell underlying the control does not automatically assume
the value chosen in the control, so if I have another cell whose contents
depend on the list item is it possible to 'read' and act upon that info with
a regular Excel formula, or would it require some more heavy-duty VBA
programming? There would also be many listbox controls that do not affect
other cells (e.g., for displaying data only). After creating the first
listbox for each field I would want to copy it and any related formulas many
times with minimal effort... would controls make this more complicated than
its worth?
The spreadsheet I am creating is for personal use only, and will be more
or less a simple database... about 2 dozen fields but potentially thousands
of records. The few calculations involved are very mathematically simple.
I thought about doing this in Access instead, but started here because I'm
much more familiar with Excel. I'm using Windows XP Home with Office XP
(SP3).
Any help is greatly appreciated.
guessing that the cell underlying the control does not automatically assume
the value chosen in the control, so if I have another cell whose contents
depend on the list item is it possible to 'read' and act upon that info with
a regular Excel formula, or would it require some more heavy-duty VBA
programming? There would also be many listbox controls that do not affect
other cells (e.g., for displaying data only). After creating the first
listbox for each field I would want to copy it and any related formulas many
times with minimal effort... would controls make this more complicated than
its worth?
The spreadsheet I am creating is for personal use only, and will be more
or less a simple database... about 2 dozen fields but potentially thousands
of records. The few calculations involved are very mathematically simple.
I thought about doing this in Access instead, but started here because I'm
much more familiar with Excel. I'm using Windows XP Home with Office XP
(SP3).
Any help is greatly appreciated.