ComboBox dilema

[Codman]

I have a combobox in which to enter numeric data and transfer this to a specific cell on a sheet. The value is stored in this cell and read back to the combobox when the file is next opened. However, if the file is not closed but a change is required the value passed back from the cell has many many places after the decimal point. The data read into this cell is alway in the range 1 through to a maximum of 4 with two decimal places ie 2.34. Is there any way I can limit the display in the combobox. I ve tried to format the spreadsheet cell to a numeric with 2 DP's. Here's my code:-


Private Sub Sett_Cmd_OK_Click()
MySettings.Sett_Cmb_Rate = Sett_Cmb_Rate
Sheet5.Range("L4&quot.Value = MySettings.Sett_Cmb_Rate
MySettings.Sett_Cmb_Curr = Sett_Cmb_Curr
Sheet5.Range("K4&quot.Value = MySettings.Sett_Cmb_Curr
MultiPage1.Value = 1
Unload Settings1

Any help would be appreciated.

Pete

 

[SkipVought]

Hi,

FORMATING a cell does NOT change the numeric value within the cell.

You will have to round the value to your specification.

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884