-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
.rowsource
-
G
Listbox Rowsource Worksheet Name From ComboBox Value
Hi, Can I use a combo box value (comboBox1.value) in Listbox Rowsource worksheet property? See example below: With userForm1.Listbox1 .RowSource = userForm1.comboBox1.value & "!A1:B10" .ColumnHeads = True .ColumnCount = 2 .ColumnWidths = "100;120" End With I have several...- gugumnd
- Thread
- .columnheads .rowsource true userform1.listbox1 worksheet
- Replies: 1
- Forum: Excel Questions
-
L
Could not set the rowsource property. Invalid property value.
Hi all, I am a newbie in VBA and I need help with the dilemma I have. I have a listbox and a delete button in a frame with named range, lstRates,=OFFSET(ConKiloRates!$A$2,0,0,COUNTA(ConKiloRates!$A:$A) -1,11). My problem is when I delete the last item in the listbox. It displays Runtime...- lattechic
- Thread
- .rowsource delete listbox1 property runtime
- Replies: 4
- Forum: Excel Questions
-
V
List .rowsource property
I have mention below code, but .rowsource is not working. I am trying to get the data from sheet which is veryhidden. any Idea. Private Sub CommandButton5_Click() If Sheets("Show").Visible = xlSheetVeryHidden Then With Me.ListBox1 .ColumnCount = 6 .ColumnWidths =...- vmjan02
- Thread
- .columnwidths .rowsource 35;60;60;70;110;60 end me.listbox1
- Replies: 2
- Forum: Excel Questions
