synergy16
Active Member
- Joined
- Mar 17, 2016
- Messages
- 422
- Office Version
- 365
- Platform
- Windows
Good afternoon everyone. i currently have a VBA program that looks to if a vendor is present on a spreadsheet, then goes and sees if that vendor has done any work to parts. the user than can click on a part number and all related serial numbers will display in another listbox. the array that is used for the serial number listbox is created before hand and redimmed based on how many part numbers were on the sheet in relation to the selected vendor, (one serial number to each part).
heres the problem im having. there is a possiblity all of the part numbers worked on at a certain vendor might not have serial numbers.
for example.
clicking on vendor A will populate 5 part numbers. so the serial number array gets dimmed with 5 elements in memory, but obviously the serial number listbox is empty. i would like to display a msgbox that the serial number cells arent populated with data by checking to see if the array is empty. the IsEmpty function does not seem to be working for me
heres the problem im having. there is a possiblity all of the part numbers worked on at a certain vendor might not have serial numbers.
for example.
clicking on vendor A will populate 5 part numbers. so the serial number array gets dimmed with 5 elements in memory, but obviously the serial number listbox is empty. i would like to display a msgbox that the serial number cells arent populated with data by checking to see if the array is empty. the IsEmpty function does not seem to be working for me