VBA UserForm TextBox formatting...it used to work

[Big Lar]

My 11yo VBA application worked until yesterday’s HD crash.
My backup copy for the replacement PC has
“Compile Error: Can’t find project or library”
issues with this and similar lines:

TextBox9.Value = Format(WS.Cells(iRow, 9).Value, "$ #.00")

The project works if I change the line to

TextBox9.Value = WS.Cells(iRow, 9)

However, the formatting is important for display readability and reports.

I’ve been many years retired and haven’t been keeping up. Corrective code assistance is appreciated.

 

[silentwolf]

Hi,

well I am not certain but have you checked all your Object Library is all checked there? If you had a crash mybe some got lost?

 

[silentwolf]

In References Tool Bar

 

[Big Lar]

Thanks for the suggestion.
"Missing - something or other"
I unchecked the box, closed and reopened the project.
It's working properly now!

Your "Hero Badge" is in the mail!

 

[silentwolf]

Cool