Linking User Form Text Box to Spreasheet Cell

[cyork]

Hi,

I have a user form which has several text boxes linked to spreadsheet cells via their Data Control property. The problem I am having is displaying formating in the textbox as it appears on the spreasheet. For example the spreadsheet contains a cell with 45%, in the text box this appears as 0.45.

Thanks,

Chris

 

[RobBroekhuis]

You may need to get away from the data control property, and do the linking to the spreadsheet cell in a more manual fashion, e.g.

In the userform.activate method:

txtMyPercent = sheets("MySheet&quot.cells("D4&quot.text
(to fill the textbox when the sheet is first loaded)

and have the following additional method:

sub txtMyPercent_change()
on error resume next 'to ignore number conversion error
sheets("MySheet&quot.cells("D4&quot=val(txtMyPercent)
end sub

which updates the worksheet cell when the user makes changes.
Rob