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"
.Value = MySettings.Sett_Cmb_Rate
MySettings.Sett_Cmb_Curr = Sett_Cmb_Curr
Sheet5.Range("K4"
.Value = MySettings.Sett_Cmb_Curr
MultiPage1.Value = 1
Unload Settings1
Any help would be appreciated.
Pete
Private Sub Sett_Cmd_OK_Click()
MySettings.Sett_Cmb_Rate = Sett_Cmb_Rate
Sheet5.Range("L4"

MySettings.Sett_Cmb_Curr = Sett_Cmb_Curr
Sheet5.Range("K4"

MultiPage1.Value = 1
Unload Settings1
Any help would be appreciated.
Pete