dpaton05
Well-known Member
- Joined
- Aug 14, 2018
- Messages
- 2,352
- Office Version
- 365
- 2016
- Platform
- Windows
I have a combo box that has its source as a list in the spreadsheet. If an item is added to the list, how do I refresh that combo box as the code I have is not working.
The list has a header in A1 and the list may have nothing in A2 yet.
VBA Code:
Tracker.lboYP.List = YP.Range("A2:A" & Lastrow).Value
The list has a header in A1 and the list may have nothing in A2 yet.