Hi Everybody

I was wondering if it is possible to fill a text box on a user form
automatically with a value from a cell in a worksheet, or in other
words is there something like a row source in the properties?

or is it possible to hide the arrows of a list box, because when I use
the row source for the list box the number automaticlly changes but the
arrows make it look like the value can be changed.


Thanks and advance for the help!!!!!


--
mav93
------------------------------------------------------------------------
mav93's Profile: http://www.excelforum.com/member.php...o&userid=31592
View this thread: http://www.excelforum.com/showthread...hreadid=518423

hi

try this


Private Sub UserForm_Initialize()
TextBox1 = Range("a1").Value
End Sub


regards Yngve


--
yngve
------------------------------------------------------------------------
yngve's Profile: http://www.excelforum.com/member.php...o&userid=31943
View this thread: http://www.excelforum.com/showthread...hreadid=518423

The textbox has a control source property.

I don't understand that second one. I can't think of anything on a listbox
that I would call arrows.

--
Regards,
Tom Ogilvy


"mav93" wrote in
message ...

Hi Everybody

I was wondering if it is possible to fill a text box on a user form
automatically with a value from a cell in a worksheet, or in other
words is there something like a row source in the properties?

or is it possible to hide the arrows of a list box, because when I use
the row source for the list box the number automaticlly changes but the
arrows make it look like the value can be changed.


Thanks and advance for the help!!!!!


--
mav93
------------------------------------------------------------------------
mav93's Profile:
http://www.excelforum.com/member.php...o&userid=31592
View this thread: http://www.excelforum.com/showthread...hreadid=518423