garden_rael
Board Regular
- Joined
- Apr 1, 2008
- Messages
- 100
Hi everyone,
I have an issue setting the rowsource property in a combobox in a form.
I set the property to a defined range depending on a value on a cell,
The first time the process runs works perfectly, but if I go back to the previous form and try to reload it it gives the error.
This is the code I'm using:
rivate Sub CommandButton8_Click()
Unload Me
Dim nmbrw As Variant
Dim rowsc As String
nmbrw = Workbooks("Workbook1.xlsm").Sheets("Config").Range("NmbrWKGP")
rowsc = "wkgp" & nmbrw
Tasks.WKGP.RowSource = rowsc
Tasks.Show
End Sub
It's really strange how it works on the first try.
Any ideas or workarounds?
I have an issue setting the rowsource property in a combobox in a form.
I set the property to a defined range depending on a value on a cell,
The first time the process runs works perfectly, but if I go back to the previous form and try to reload it it gives the error.
This is the code I'm using:
rivate Sub CommandButton8_Click()
Unload Me
Dim nmbrw As Variant
Dim rowsc As String
nmbrw = Workbooks("Workbook1.xlsm").Sheets("Config").Range("NmbrWKGP")
rowsc = "wkgp" & nmbrw
Tasks.WKGP.RowSource = rowsc
Tasks.Show
End Sub
It's really strange how it works on the first try.
Any ideas or workarounds?
