| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
user form - data range
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
user form - data range
Me.ListBox1.RowSource = Worksheets("Sheet1").Range("A1:A10").Address
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "sam1" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
user form - data range
If it is on a separate worksheet as stated, it requires a bit more
Me.ListBox1.RowSource = Worksheets("Sheet1").Range("A1:A10").Address(Exter nal:=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" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
user form - data range
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
user form - data range
Private Sub Combobox1_Click()
Combobox1.Value = format(Combobox1.Value,"hh:mm:ss") End sub -- Regards, Tom Ogilvy "sam1" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User Form - Range Selector | Excel Programming | |||
| How to: User Form to assign a user defined range to a macro variab | Excel Programming | |||
| User form browsing for a range on a sheet? | Excel Programming | |||
| passing a range to a user defined function using a form | Excel Programming | |||
| My First User Form - How to Select Range(s) and Print | Excel Programming | |||
![sam1[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
