textbox scrollbars disappear

Y

Yaniv

Hi

i have a textbox in my sheet.
i use the multiline option and the scrollbars option for that textbox.
when i enter text to the textbox, everything is fine (i can see the
scrollbar)
but if i close the sheet and open it again, the scrollbar for that textbox
disappears (so i can't tell that there are more lines in that textbox than
what i can see...)
only when i click in the textbox - the scrollbar reappears...

did anyone see that ?
is there a way to show the scrollbar when opening the file ?

thanks,
Yaniv
 
D

Dave Peterson

You have one commiserating post in .excel.
Hi

i have a textbox in my sheet.
i use the multiline option and the scrollbars option for that textbox.
when i enter text to the textbox, everything is fine (i can see the
scrollbar)
but if i close the sheet and open it again, the scrollbar for that textbox
disappears (so i can't tell that there are more lines in that textbox than
what i can see...)
only when i click in the textbox - the scrollbar reappears...

did anyone see that ?
is there a way to show the scrollbar when opening the file ?

thanks,
Yaniv
 
F

FMichaud76

"Dave Peterson" a écrit :
You have one commiserating post in .excel.

Hello,

I really don't like the answer of Dave...

The right answer is to set the focus to the textBox (so that it activates
the scrollbar) then set the pointer of the multiline text to the first line
(otherwise the textbox will show the end of the text). After that, don't
forget to set the focus to the proper element (below, the OK button)

If your the textbox name name is myTextBox and the OK button is cmdOK, add
this at the end of the userform_initialize sub :

Private Sub userform_initialize()
....
myTextBox.SetFocus
myTextBox.Curline=0
cmdOK.SetFocus
End Sub

will do the job

A+, Fred
 

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