K
Kate
Has anyone heard of this:
I have designed a spreadsheet so that each cell's data
validation text and title appear in a text box at the top of
the screen as the cell is entered. I have used chr(10) in
the VBA code to insert a line feed between the title and the
text in the text box. This of course works fine in this
country (USA), but I had a report from a user in Sweden that
he was getting a run-time error at this line, 'can't find
project or library.' He has all the same references checked
as did I.
When I removed the chr(10) code and put the title and text
on the same line, it worked fine!
Is there some other linefeed character that anyone knows
about which works in ALL languages??
Thanks for your help all,
Kate
I have designed a spreadsheet so that each cell's data
validation text and title appear in a text box at the top of
the screen as the cell is entered. I have used chr(10) in
the VBA code to insert a line feed between the title and the
text in the text box. This of course works fine in this
country (USA), but I had a report from a user in Sweden that
he was getting a run-time error at this line, 'can't find
project or library.' He has all the same references checked
as did I.
When I removed the chr(10) code and put the title and text
on the same line, it worked fine!
Is there some other linefeed character that anyone knows
about which works in ALL languages??
Thanks for your help all,
Kate