User forms help

[mav93]

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!!!!!

[yngve]

hi

try this


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


regards Yngve

[Tom Ogilvy]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>