Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rowsource Question
I originally posted this question on 11/14, but I still haven't been able to
figure out how to solve the problem based on the response that I got. So I am posting the question again in more detail. If Noah is the user, I want the RowSource of ListBox1 in UserForm1 to fill with values from Sheet1. If Joe is the user, I want the RowSource of ListBox1 in UserForm1 to fill with values from Sheet2. I am not sure if this is the right think to do, but I have left the RowSource field in the Properties of ListBox1 empty. ----------------------- I currently have the following code in Module1: Public rng as Range Sub Macro1() Dim User As String User = Environ("UserName") Select Case User Case "Noah" lastrow = Sheet1.Cells(1, 1).End(xlDown).Row rng = Sheet1.Range(Cells(1, 1), Cells(lastrow, 2)) UserForm1.Show Case Joe lastrow = Sheet2.Cells(1, 1).End(xlDown).Row rng = Sheet2.Range(Cells(1, 1), Cells(lastrow, 2)) UserForm1.Show Case Else End Select End Sub ----------------------- I currently have the following code in the code module for UserForm1: Private Sub UserForm_Initialize() Me.ListBox1.RowSource = rng.Address End Sub ------------------------ The error message that I keep getting is: "Could not set the RowSource property. Invalid property value." Please help! Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UserForm ComboBox RowSource Question | Excel Programming | |||
TextBox RowSource Question | Excel Programming | |||
help with rowsource | Excel Programming | |||
combobox rowsource | Excel Programming | |||
Using IF, Then with rowsource? | Excel Programming |