خرید بک لینک

Vote count: 0

I'm getting a run time error 1004, Method 'Range' of object '_Worksheet' failed.

This code worked before I changed some UserForm names... none of the named ranges or worksheet names have changed. Please help!

Private Sub UserForm_Initialize()
'Set Variables to populate combobox
Dim gProjects As Range
Dim ws1 As Worksheet

Set ws1 = Worksheets("Validation")

For Each gProjects In ws1.Range("Projects")

Me.cboProject.AddItem gProjects.Value
Me.cboAccount.AddItem gProjects.Value

Next gProjects

'Add static data for combobox
Me.cboTransactionType.AddItem "Income"
Me.cboTransactionType.AddItem "Expense"

asked 42 secs ago

برچسب: نویسنده: استخدام کار تاريخ: پنجشنبه 10 تير 1395 ساعت: 4:28

صفحه بندی