Setting Curline to 0 on a text box fails (Excel 2007)

A

Andrew B

I have a text box on a userform, which after filling with text I want to
reposition at the top so the first line displays at the top for the user. I
am doing this by setting its Curline property to 0. In the past this worked,
but has now started to fail with a VBA error. Setting Curline to any other
value (e.g. 1) does not fail but has no effect. Is this an Excel bug
introduced as a result of an update? Can it be fixed?
 
P

Patrick Molloy

i have both 2003 and 2007 and i get the same issue , ie .CurLine = 0 raises
an error (running a form in both vers).
i changed this to
..SelStart = 0
which worked ok
 
A

Andrew B

Yes this seems to work for me, thank you - though I first seem to need to set
CurX to 0 also
 
K

K@ssi

BUT:
I don't accept this as an fix! This is a general Office 2007 problem.
The "fm20.dll" generates this error. On all mashines where KB950278 is
installed (this is an Office 2003 fix!!) this error occured. After
deinstalling this update the curline=0 works fine.
Now we have the SP2 of Office 2007 and the probleme comes again.
So, somebody from Microsoft should have an eye on this.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top