Combo boxes

  • Thread starter Thread starter andy
  • Start date Start date
A

andy

Ok, here's the problem...
On my spreadsheet is a pair of combo boxes which when one
is changed the other will change to correspond with the
others data (e.g. the location name corresponds to the
cost per day). My problem is that i cannot seem to work
out the total cost of the location. I know that i should
multiply the cost per day by the number of days, but
seeing as the cost per day is in a combo box i can't do
it. Any suggestions? (also im not sure if the way i
entered the data in the combo boxes is correct, so any
help would be appreciated).
Cheers,
Andy
 
You can link a combobox to a cell (property LinkedCell). If you do this, you
can do your calculations based on the cell value rather than the combobox.

I hope this helps

Ian Coates
 
You can link the selected combobox entry to a cell (property LinkedCell). In
this way, you can do your calculations based on the cell values, not the
combobox.

Ther is also a ListFilRange property whereby you can enter the data for the
combobox in a series of cells which you can the protect and hide is
necessary.

Hope this helps

Ian
 
Back
Top