Hi,
Instead of coding every possible AddItem for a List box, how do i set it on the user form to cover a range of data on a separate worksheet?
Hi,
Instead of coding every possible AddItem for a List box, how do i set it on the user form to cover a range of data on a separate worksheet?
Me.ListBox1.RowSource = Worksheets("Sheet1").Range("A1:A10").Address
--
HTH
Bob Phillips
(remove nothere from the email address if mailing direct)
"sam1" <[email protected]> wrote in message
news:[email protected]...
>
> Hi,
>
> Instead of coding every possible AddItem for a List box, how do i set
> it on the user form to cover a range of data on a separate worksheet?
>
>
> --
> sam1
> ------------------------------------------------------------------------
> sam1's Profile:
http://www.excelforum.com/member.php...o&userid=18280
> View this thread: http://www.excelforum.com/showthread...hreadid=526857
>
If it is on a separate worksheet as stated, it requires a bit more
Me.ListBox1.RowSource =
Worksheets("Sheet1").Range("A1:A10").Address(External:=True)
--
Regards,
Tom Ogilvy
"Bob Phillips" wrote:
> Me.ListBox1.RowSource = Worksheets("Sheet1").Range("A1:A10").Address
>
> --
>
> HTH
>
> Bob Phillips
>
> (remove nothere from the email address if mailing direct)
>
> "sam1" <[email protected]> wrote in message
> news:[email protected]...
> >
> > Hi,
> >
> > Instead of coding every possible AddItem for a List box, how do i set
> > it on the user form to cover a range of data on a separate worksheet?
> >
> >
> > --
> > sam1
> > ------------------------------------------------------------------------
> > sam1's Profile:
> http://www.excelforum.com/member.php...o&userid=18280
> > View this thread: http://www.excelforum.com/showthread...hreadid=526857
> >
>
>
>
Thanks for info, I'm tring to put Times in the combo box but when i select time values, they convert to numbers in the combobox, how do i keep the Time format?
Private Sub Combobox1_Click()
Combobox1.Value = format(Combobox1.Value,"hh:mm:ss")
End sub
--
Regards,
Tom Ogilvy
"sam1" <[email protected]> wrote in message
news:[email protected]...
>
> Thanks for info, I'm tring to put Times in the combo box but when i
> select time values, they convert to numbers in the combobox, how do i
> keep the Time format?
>
>
> --
> sam1
> ------------------------------------------------------------------------
> sam1's Profile:
http://www.excelforum.com/member.php...o&userid=18280
> View this thread: http://www.excelforum.com/showthread...hreadid=526857
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks